CompTIA Data+ (DA0-002)VisualizationHard
A data analyst is preparing a quarterly business review for senior leadership, focusing on the performance of various marketing campaigns. The presentation needs to convey the impact of each campaign on sales, clearly showing which campaigns generated the most revenue and which were less effective. The analyst also wants to display the budget allocated to each campaign alongside its revenue. Which chart type would be MOST effective for comparing multiple campaigns' revenue and budget simultaneously?
- ALine Chart
- BStacked Bar Chart
- CDual-Axis Bar Chart
- DScatter Plot
Show answer & explanationAnswer & explanation
Correct answer: C. Dual-Axis Bar Chart
A dual-axis bar chart allows for the comparison of two different metrics (revenue and budget) that may have different scales, for the same categories (campaigns). This enables direct visual comparison of how much was spent versus how much was earned per campaign.
Why the other options are wrong
- A. A line chart is best for showing trends over time, not for comparing two different metrics across discrete categories.
- B. A stacked bar chart shows parts of a whole or components of a single total, not two distinct metrics for comparison.
- D. A scatter plot shows the relationship between two continuous variables, not a comparison of two distinct metrics for categorical items.
Dual-Axis Bar Chart
A chart that uses two independent Y-axes (or a combination of bar and line charts with two axes) to plot different metrics for the same categories, allowing for comparison of distinctly scaled data.
- Compares two different measures for the same categories.
- Handles metrics with different units or scales effectively.
- Useful for showing relationships like cost vs. revenue per item.
Memory trick: Dual Axes, Double Insight.