Why advanced visuals reveal deeper insights in Power BI - Business Case Study

Scenario Mode

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

📋 Request: Your manager wants you to create a report that shows sales performance with visuals that help reveal deeper insights beyond simple totals.

📊 Data: You have monthly sales data by product category and region, including sales amount, units sold, and profit margin.

🎯 Deliverable: Create a Power BI report with advanced visuals like clustered bar charts, line charts with trend lines, and heat maps to highlight patterns and trends in sales performance.

Sample Data

Month	Region	Category	Sales Amount	Units Sold	Profit Margin (%)
Jan	North	Electronics	12000	100	15
Jan	South	Electronics	15000	120	18
Jan	East	Furniture	8000	50	20
Feb	North	Electronics	13000	110	16
Feb	South	Furniture	9000	60	22
Feb	East	Electronics	14000	115	17
Mar	North	Furniture	8500	55	19
Mar	South	Electronics	16000	130	18
Mar	East	Furniture	8200	52	21

1

Step 1: Load the sales data into Power BI by importing the table.

Use 'Get Data' > 'Excel' or 'CSV' depending on your file format, then load the data into Power BI.

Expected Result

Sales data is available in Power BI data model with columns: Month, Region, Category, Sales Amount, Units Sold, Profit Margin (%).

2

Step 2: Create a clustered bar chart to compare total Sales Amount by Region and Category.

Visual: Clustered bar chart; Axis = Region; Legend = Category; Values = SUM(Sales Amount).

Expected Result

Bar chart shows sales totals for each region broken down by product category.

3

Step 3: Add a line chart to show monthly sales trends for Electronics category across all regions.

Visual: Line chart; Axis = Month; Legend = Region; Values = SUM(Sales Amount) filtered where Category = 'Electronics'.

Expected Result

Line chart displays how Electronics sales change month to month in each region.

4

Step 4: Create a heat map to visualize Profit Margin (%) by Region and Category.

Visual: Matrix with conditional formatting; Rows = Region; Columns = Category; Values = AVERAGE(Profit Margin (%)); apply color scale from red (low) to green (high).

Expected Result

Heat map highlights regions and categories with higher or lower profit margins using color intensity.

5

Step 5: Add a trend line to the line chart to show overall sales direction for Electronics.

Select line chart > Analytics pane > Add Trend line for SUM(Sales Amount).

Expected Result

Trend line appears on the line chart showing if sales are increasing or decreasing over months.

6

Step 6: Use slicers for Month and Category to allow interactive filtering of the report.

Add slicer visuals; Fields = Month and Category.

Expected Result

User can filter all visuals by selecting specific months or categories.

Final Result

Clustered Bar Chart

↓

Line Chart

↓

Heat Map

↓

Slicers

↓

Jan

↓

Electronics

✓South region consistently has the highest Electronics sales.

✓Profit margins are highest in Furniture category in the South region.

✓Electronics sales show an upward trend from January to March.

✓Heat map quickly reveals regions and categories with lower profit margins needing attention.

Bonus Challenge

Add a calculated measure to show Sales per Unit and use it in a scatter chart to analyze sales efficiency by Region and Category.

Show Hint

Create a DAX measure: Sales per Unit = DIVIDE(SUM('Sales'[Sales Amount]), SUM('Sales'[Units Sold])) and plot it on X axis with Profit Margin on Y axis.