Report Builder overview in Power BI - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a clear report showing total sales by product category and region for the last quarter.

📊 Data: You have sales data including Date, Product Category, Region, and Sales Amount for the last quarter.

🎯 Deliverable: Create a report using Power BI Report Builder that shows total sales by product category and region with a simple table and a bar chart.

Sample Data

Date	Product Category	Region	Sales Amount
2024-03-01	Electronics	North	1200
2024-03-05	Clothing	South	850
2024-03-10	Electronics	East	950
2024-03-15	Home Goods	West	700
2024-03-20	Clothing	North	650
2024-03-25	Home Goods	South	400
2024-03-28	Electronics	West	1100
2024-03-30	Clothing	East	900

1

Step 1: Connect Power BI Report Builder to the sales data source containing Date, Product Category, Region, and Sales Amount.

Use the data connection wizard to link to the sales database or Excel file.

Expected Result

Data source connected and ready for report creation.

2

Step 2: Create a dataset that filters sales data for the last quarter (March 2024).

Use a query with WHERE Date BETWEEN '2024-03-01' AND '2024-03-31'.

Expected Result

Dataset contains only sales records from March 2024.

3

Step 3: Insert a table into the report to show total sales by Product Category and Region.

Group rows by Product Category, columns by Region, and use SUM([Sales Amount]) as the value.

Expected Result

Table displays total sales amounts for each product category and region.

4

Step 4: Add a bar chart to visualize total sales by Product Category.

Set Category axis to Product Category and Values to SUM([Sales Amount]).

Expected Result

Bar chart shows sales totals for each product category.

5

Step 5: Format the report with clear titles, labels, and consistent fonts for readability.

Add report title 'Sales by Product Category and Region - March 2024' and label axes on the chart.

Expected Result

Report is easy to read and understand.

6

Step 6: Preview the report to verify data accuracy and visual clarity.

Use the preview feature in Report Builder.

Expected Result

Report shows correct sales totals and clear visuals.

Final Result

Electronics

↓

Clothing

↓

Home Goods

✓Electronics had the highest total sales in March 2024, especially strong in North and West regions.

✓Clothing sales were solid across South and East regions.

✓Home Goods sales were lower but consistent in South and West regions.

Bonus Challenge

Add a filter to the report that allows users to select a specific region and see sales data only for that region.

Show Hint

Use a report parameter for Region and modify the dataset query to filter by the selected parameter.