Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A marketing analyst is creating a Power BI report to analyze customer demographics and purchasing behavior. The dataset contains 'Customer ID', 'Age Group', 'Gender', 'Product Category', and 'Purchase Amount'. The analyst wants to create a visual that shows the distribution of 'Purchase Amount' across different 'Age Groups' and 'Gender' categories simultaneously, allowing for easy comparison of spending patterns. Which visual type is best suited for this multi-dimensional analysis?
- AWaterfall Chart
- BMatrix visual
- CGauge visual
- DStacked Area Chart
Show answer & explanationAnswer & explanation
Correct answer: B. Matrix visual
A Matrix visual (also known as a pivot table) is specifically designed to display data across multiple dimensions (rows and columns) with aggregated values at their intersections. It allows for easy comparison of 'Purchase Amount' by 'Age Group' (rows) and 'Gender' (columns) and can include subtotals, which is ideal for this multi-dimensional analysis.
Why the other options are wrong
- A. A waterfall chart shows how an initial value is affected by a series of positive and negative changes, not suitable for this demographic analysis.
- C. A gauge visual displays a single KPI against a target, not a multi-dimensional comparison.
- D. A stacked area chart is used for showing how proportions change over time, not for comparing discrete categories across two dimensions.
Matrix Visual
A Power BI visual that displays data in a grid format, allowing for hierarchical display of rows and columns and showing aggregated values at their intersections, similar to a pivot table.
- Excellent for multi-dimensional analysis.
- Supports drill-down and drill-up.
- Can display subtotals and grand totals.
Memory trick: Matrix Grids Organize Complex Data