Explain 'Pre-Aggregation'.

Explain 'Pre-Aggregation'.

Approach: Describe calculating sums/counts before they are requested.

The process of computing and storing aggregate values (e.g., daily sales totals) in advance of a query to reduce calculation time during real-time reporting.

Follow-up: What is the trade-off with pre-aggregation?

Key concepts: cubes, latency reduction.