A data analyst is creating a report that will provide information about various regions, products, and time periods. Which of the following formats would be the MOST efficient way to deliver this…

Question

Options

• AA workbook with multiple tabs for each region
• BA daily email with snapshots of regional summaries
• CA static report with a different page for every filtered view
• DA dashboard with filters at the top that the user can toggle

• A
  16% (4)
• B
  4% (1)
• C
  8% (2)
• D
  72% (18)

Explanation

A dashboard with interactive filters is the most efficient delivery method when a report spans multiple dimensions (regions, products, time periods). Users can self-serve by toggling filters to explore the exact data they need without requiring the analyst to generate separate reports. A workbook with multiple tabs requires users to navigate many sheets and becomes unwieldy as dimensions increase. A daily email with static snapshots is not interactive and can become stale between sends. A static report with a different page for every filtered view would require generating an enormous number of pages (e.g., every region × product × time period combination) and is not scalable or user-friendly. Dashboards with filters offer flexibility, reduce redundancy, and scale well.

No community discussion yet for this question.