Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A global logistics company uses Power BI to monitor shipment statuses. They have a dataset with 'Shipment ID', 'Origin Country', 'Destination Country', 'Status' (e.g., 'In Transit', 'Delayed', 'Delivered'), and 'Expected Delivery Date'. The operations manager needs a report that allows them to quickly identify all shipments that are 'Delayed' and then see the count of delayed shipments by each 'Destination Country' on a single, interactive visual. Which visual type is best suited for this task?
- ATreemap visual with 'Destination Country' and 'Status' as groupings
- BFunnel chart showing shipment statuses
- CMap visual with a slicer for 'Status'
- DTable visual with conditional formatting on 'Status'
Show answer & explanationAnswer & explanation
Correct answer: A. Treemap visual with 'Destination Country' and 'Status' as groupings
A treemap visual is excellent for displaying hierarchical data and proportions. By grouping by 'Destination Country' and then 'Status', and sizing by count, it can immediately show the proportion of 'Delayed' shipments within each country, allowing for quick identification and comparison in a single, interactive visual.
Why the other options are wrong
- B. A funnel chart shows sequential stages, not a breakdown of delayed shipments by country.
- C. A map visual shows geographic distribution but doesn't easily show counts of delayed shipments per country in a single, aggregated view.
- D. A table visual would list details but isn't as effective for quick visual comparison of proportions and counts across multiple countries as a treemap.
Treemap Visual
A visual that displays hierarchical data as a set of nested rectangles, where the size of each rectangle is proportional to its value.
- Good for showing proportions and part-to-whole relationships.
- Effective for hierarchical data structures.
- Interactive, allowing drill-down into categories.
Memory trick: Tree of Boxes, Sizes Tell the Tale