Microsoft Certified: Fabric Analytics Engineer AssociateExplore and analyze data (15-20%)Hard
A data analyst is designing a Power BI report using data from a Lakehouse SQL endpoint in Microsoft Fabric. They need to visualize the distribution of `customer_age` for different `product_categories`. The goal is to easily compare the shape and spread of age data across categories, identifying any skewness or outliers. Which Power BI visual is best suited for this requirement?
- ABox and Whisker plot
- BStacked column chart
- CScatter chart
- DLine chart
Show answer & explanationAnswer & explanation
Correct answer: A. Box and Whisker plot
A Box and Whisker plot is specifically designed to display the distribution of a dataset, showing its median, quartiles, and potential outliers. When grouped by `product_categories`, it allows for direct comparison of these distributional characteristics across groups, perfectly addressing the need to compare shape, spread, skewness, and outliers.
Why the other options are wrong
- B. Stacked column charts are used to compare parts of a whole or totals across categories, not the statistical distribution of a continuous variable.
- C. Scatter charts are used to show relationships between two numerical variables, not the distribution of a single variable across categories.
- D. Line charts are used to show trends over time or ordered categories, not data distribution.
Box and Whisker Plot
A visual display of the distribution of a dataset through its quartiles, median, and potential outliers, often used for comparing distributions across different groups.
- Shows five-number summary: minimum, first quartile (Q1), median (Q2), third quartile (Q3), maximum.
- Whiskers extend to the lowest/highest data points within 1.5 times the interquartile range (IQR).
- Points beyond the whiskers are considered outliers.
Memory trick: Boxes show the spread, whiskers show the reach.