An analyst has a collection of daily shipment records from multiple distribution centers. They aim to generate a concise table that shows total shipments per center each month. Which approach achieves this goal while reducing the volume of data?
Merge daily data from each source into a single table to consolidate all rows
Reformat the date fields into a shorter string format for grouping by day
Use recoding to give each center a unified identifier
Group daily entries by center and month, then sum shipment totals
Summarizing shipments by center and month reduces many rows into monthly totals. Merging daily records creates a single dataset but does not summarize data. Recoding IDs alters identifiers and does not create monthly totals. Reformatting dates changes the display without combining daily entries.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What does it mean to group data in this context?
Open an interactive chat with Bash
How do the different types of data aggregation work?
Open an interactive chat with Bash
Why is it important to reduce the volume of data in analysis?