DAA-C01 Question 256
Select 24.3 Given a use case, incorporate visualizations for dashboards and reports.A retail analytics team is building an executive dashboard in Snowsight for regional sales performance. Executives want to quickly compare total revenue by region, identify month-over-month trends, and see each region's contribution to overall revenue in the current quarter. The dashboard must be easy to interpret at a glance and avoid misleading visuals. Which combination of visualizations should the analyst use? Select TWO.
- A
Use a bar chart to compare total revenue across regions
- B
Use a line chart to show month-over-month revenue trends over time
- C
Use a pie chart with many slices to display monthly revenue by region across the last 24 months
- D
Use a scatter plot to show each region's contribution to total revenue in the current quarter
- E
Use a donut or pie chart to show each region's share of total revenue for the current quarter when the number of regions is small
Show answer and explanation
Correct answers: A, B
Explanation
This question tests the ability to match business requirements to appropriate dashboard visualizations in Snowsight. For comparing values across categories, bar charts are preferred because they support accurate comparison of magnitudes. For trends over time, line charts are the best practice because they show change across a continuous time axis clearly. Pie or donut charts can be used for simple part-to-whole views, but they become less effective with many categories and are not suitable for trend analysis. Scatter plots are intended for relationship analysis between measures, not categorical contribution. These choices reflect common visualization best practices that apply when building dashboards and reports in Snowsight and other BI tools: choose visuals that maximize clarity, support the analytical task, and reduce cognitive load for executive consumers.
- A. Correct.
Correct. A bar chart is an appropriate choice for comparing values across discrete categories such as regions. It makes it easy for executives to compare total revenue side by side and quickly identify top- and bottom-performing regions. This aligns with standard data visualization best practices for categorical comparisons in dashboards.
- B. Correct.
Correct. A line chart is the standard visualization for showing trends over time, such as month-over-month revenue changes. It helps users see direction, seasonality, and inflection points clearly, which is exactly what the executives need for trend analysis.
- C. Incorrect.
Incorrect. A pie chart with many slices is difficult to interpret, and using it across 24 months and multiple regions creates excessive visual clutter. Pie charts are generally only suitable for simple part-to-whole comparisons with a small number of categories, not for time-series analysis or large combinations of categories.
- D. Incorrect.
Incorrect. A scatter plot is best used to show relationships or correlation between two quantitative measures, not part-to-whole contribution by category. Using a scatter plot for regional contribution to total revenue would not communicate share effectively and would make the dashboard harder to interpret.
- E. Incorrect.
Incorrect in this scenario because the question asks for exactly two visualizations that together best meet all stated needs. While a donut or pie chart can be acceptable for showing part-to-whole relationships when the number of regions is small, the stronger core choices for this dashboard are the bar chart for regional comparison and the line chart for trends. If contribution needed to be emphasized as a third visualization, this option could be reasonable, but it is not part of the best two-option combination.