Microsoft Certified: Power BI Data Analyst AssociateVisualize and analyze the dataMedium
A product manager needs a Power BI report to track the adoption rate of new features in their software. The dataset includes 'Feature Name', 'User ID', 'Usage Date', and 'Feature Version'. The manager wants to visualize the cumulative count of unique users who have adopted each feature over time. The visual should clearly show the growth curve for each feature individually and allow for comparison between different features' adoption trajectories. Which visual type is most appropriate for this analysis?
- AArea chart with 'Usage Date' on the X-axis and 'Cumulative Unique Users' on the Y-axis, with 'Feature Name' in the Legend.
- BTable visual listing 'Feature Name' and 'Cumulative Unique Users'.
- CPie chart illustrating the proportion of 'Cumulative Unique Users' for each feature.
- DClustered bar chart showing 'Cumulative Unique Users' by 'Feature Name'.
Show answer & explanationAnswer & explanation
Correct answer: A. Area chart with 'Usage Date' on the X-axis and 'Cumulative Unique Users' on the Y-axis, with 'Feature Name' in the Legend.
An area chart is excellent for visualizing cumulative data and trends over time. By placing 'Usage Date' on the X-axis and a measure for 'Cumulative Unique Users' on the Y-axis, and using 'Feature Name' in the legend, the analyst can create distinct growth curves for each feature, allowing for easy comparison of adoption trajectories and the overall cumulative trend.
Why the other options are wrong
- B. A table visual provides raw data but lacks the visual trend and comparison capabilities required.
- C. A pie chart shows static proportions, not cumulative trends over time.
- D. A clustered bar chart would show cumulative values at a single point in time, not the growth curve over time.
Area Chart for Cumulative Trends
A line chart with the area between the line and the x-axis filled, often used to display the magnitude of change over time and for cumulative or part-to-whole relationships over a continuous axis.
- Excellent for showing trends over time.
- Effective for cumulative data.
- Can compare multiple series with different colors/shading.
Memory trick: Area Grows, Adoption Shows