Aggregating data

Aggregation is the process of combining data records. This can be achieved by:

  • Grouping– Specify a list of characteristics that uniquely identify a record in the result set. Thus, a data set is created for each occurring combination of these characteristics.
  • Calculations – Such as totals, average, minimum or maximum can be performed on all records that have been combined into one record based on the grouping.
  • Filtering – After aggregation, the aggregated data sets can be filtered based on the calculated data.
  • Sorting– At the end, the aggregated data can also be sorted.

Lesson Content
0% Complete 0/2 Steps