Aggregate data for analysis
Data aggregation
The process of gathering data from multiple sources in order to combine it into a single summarized collection
- Puzzle pieces = data
- Organization = aggregation
- Pile of pieces = summary
- Putting the pieces together = gaining insights
The aggregation process helps to identify trends, make comparisons, and gain insights that wouldn't be possible if each of the data elements were analyzed individually.
Data can also be aggregated over a given time period to provide statistics such as:
- Averages
- Minimums
- Maximums
- Sums
Functions play a significant role make data aggregation possible.
Subquery or nested query is a query within another query, which is often used in data aggregation.