Power BI workflow (get data, transform, visualize, share) - Real Business Scenario

Scenario Mode

👤 Your Role: You are a business analyst at a retail company.

📋 Request: Your manager wants a report showing monthly sales and profit trends to understand business performance.

📊 Data: You have a sales data file with columns: Date, Product, Region, Sales Amount, and Profit.

🎯 Deliverable: Create a Power BI report that shows monthly sales and profit trends with clear visuals and share it with your team.

Sample Data

Date	Product	Region	Sales Amount	Profit
2024-01-05	Widget A	North	1000	200
2024-01-15	Widget B	South	1500	300
2024-02-10	Widget A	East	1200	250
2024-02-20	Widget C	West	1300	270
2024-03-05	Widget B	North	1100	220
2024-03-15	Widget C	South	1400	280
2024-04-10	Widget A	East	1600	320
2024-04-20	Widget B	West	1700	340

1

Step 1: Get data into Power BI

Open Power BI Desktop. Click 'Get Data'. Choose 'Excel' or 'CSV' depending on your file. Select the sales data file and load it.

Expected Result

Sales data is loaded into Power BI with columns Date, Product, Region, Sales Amount, and Profit.

2

Step 2: Transform data to prepare for analysis

In Power Query Editor, check data types. Change 'Date' column to Date type if needed. Close and Apply changes.

Expected Result

Data is clean and ready with correct data types.

3

Step 3: Create a new column for Month-Year

In Power BI Data view, create a new column with formula: MonthYear = FORMAT('Sales'[Date], "MMM yyyy")

Expected Result

A new column 'MonthYear' shows month and year like 'Jan 2024'.

4

Step 4: Create measures for total sales and total profit

Create measure Total Sales = SUM('Sales'[Sales Amount]) Create measure Total Profit = SUM('Sales'[Profit])

Expected Result

Measures calculate total sales and profit dynamically.

5

Step 5: Build a line chart visual for monthly sales and profit trends

Insert a Line Chart. Set Axis to 'MonthYear'. Add 'Total Sales' and 'Total Profit' as Values.

Expected Result

Line chart shows sales and profit trends over months.

6

Step 6: Format the visual for clarity

Add chart title 'Monthly Sales and Profit Trends'. Enable data labels. Use contrasting colors for sales and profit lines.

Expected Result

Chart is easy to read and understand.

7

Step 7: Publish and share the report

Click 'Publish' in Power BI Desktop. Select your workspace. Share the report link with your team via Power BI Service.

Expected Result

Team members can view the report online.

Final Result

Monthly Sales and Profit Trends

MonthYear | Sales Amount | Profit
---------------------------------
Jan 2024  | 2500         | 500
Feb 2024  | 2500         | 520
Mar 2024  | 2500         | 500
Apr 2024  | 3300         | 660

(Line chart with two lines showing sales and profit rising and falling over months)

✓Sales and profit show steady growth from January to April.

✓April has the highest sales and profit among the months.

✓Sales and profit trends move closely together, indicating consistent profit margins.

Bonus Challenge

Add a slicer to filter the report by Region so users can see trends for each region separately.

Show Hint

Use the 'Region' column in a slicer visual. Connect slicer to the line chart to filter data dynamically.