[Visualization and Reporting]A manager wants to use the information in a recurring report on incomplete timesheets for the prior month to guide…

A snapshot report is the most appropriate choice because it captures the state of data for a specific, completed period—in this case, the "prior month." This creates a static, historical record that is perfect for a recurring review. The manager needs a definitive list of employees with incomplete timesheets as of the end of the last month to perform outreach. A snapshot report provides this exact point-in-time, unchangeable list, ensuring that everyone is working from the same historical data for the follow-up task.

A. Summary: A summary report primarily aggregates data (e.g., counts, totals). While useful for an overview, it would not inherently provide the specific employee details needed for outreach without being a detail report.

B. Infographic: An infographic is a graphical visualization for storytelling or presenting high-level insights, not for providing an actionable, detailed list for an operational task.

D. Ad hoc: An ad hoc report is a one-time report created for a specific, non-repeating purpose. The scenario explicitly states the report is "recurring," making this option incorrect.

---

1. Kimball

R.

& Ross

M. (2013). The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (3rd ed.). Wiley. In Chapter 5

"Accumulating Snapshot and Periodic Snapshot Fact Tables

" the authors describe periodic snapshots as capturing data "on a predictable

periodic basis" such as monthly. A report generated from this data structure is a snapshot report

ideal for analyzing a prior month's status.

2. Microsoft. (2023). Power BI documentation: Use aggregations in Power BI Desktop. Microsoft Learn. This document defines aggregation as the process of summarizing values (e.g.

SUM

COUNT). This highlights the primary function of a summary report

which contrasts with the manager's need for a specific list of employees (detail-level data).

3. University of California

Berkeley

School of Information. (n.d.). Course curriculum for "Working with Data: Intermediate Data Analysis". The distinction between different report types is a fundamental concept in data analysis education. Courseware typically defines snapshot reports as capturing a state at a point in time

essential for historical and period-over-period analysis

which directly applies to the scenario's need for a "prior month" report.