Aggregate data for analysis

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.

Spredsheets VLOOKUP


Read more