Q: A data analyst uses a spreadsheet function to aggregate data. Then, they add a pivot table to show totals from least to greatest. This would happen during which phase of the data life cycle?
or
Q: To aggregate data, a data analyst utilizes a function in a spreadsheet. To display totals from lowest to largest, they then include a pivot table. In which stage of the data life cycle would this occur?
- Analyze
- Manage
- Capture
- Plan
Explanation: Data aggregation via the use of a spreadsheet function and the creation of a pivot table are examples of activities that normally take place during the “Processing” or “Analysis” stages of the data life cycle. Data analysts do data manipulation, cleansing, and aggregation at this stage. Spreadsheet functions and tools like pivot tables are often used to organize and summarize data for further analysis.
