Microsoft Azure Data FundamentalsDescribe core data conceptsMedium
A data analyst is working with a dataset that contains information about customer purchases. Each record includes `CustomerID`, `ProductID`, `Quantity`, and `Price`. The analyst needs to calculate the total revenue for each product category over the last quarter. Which common data operation is required to achieve this?
- AFiltering
- BSorting
- CAggregation
- DJoins
Show answer & explanationAnswer & explanation
Correct answer: C. Aggregation
Calculating the 'total revenue' for 'each product category' involves grouping data by category and then summing up the revenue, which is a classic aggregation operation.
Why the other options are wrong
- A. Filtering selects specific rows, but doesn't calculate totals.
- B. Sorting arranges data in a specific order, which is not directly used for calculating totals.
- D. Joins combine data from multiple tables, which might be needed but not the direct operation for calculating the total revenue.
Aggregation
A data operation that combines data from multiple rows to compute a single summary value.
- Common aggregation functions include SUM, AVG, COUNT, MIN, MAX.
- Often used with 'GROUP BY' clauses in SQL to summarize data by categories.
- Fundamental for reporting and analytical queries to derive insights from raw data.
Memory trick: Aggregating for Averages and Totals