Data Aggregation

Share this topic

Data Aggregation

From the book I Am Datapedia!, published here free by the author.

Part of I Am Datapedia!

Data Aggregation is the most used term in our daily lives whether it’s in office or in home, we use it everywhere.

A picture containing table

Description automatically generated‘Data Aggregation is about converting details into summarized format.’

For example, if someone asks you how many months there are in a year? You won’t be taking names of all the months rather you will answer, there are 12 months.

Referring to the image, if your manager asks how many installations our team has done, you rather sending left side details, you will send right side summarized report to your manager i.e., in-total there are 6 iOS and 3 Android installations.

Diagram

Description automatically generatedAs we normally use databases or data stores to store data, there are different aggregation functions normally used to summarize the data.

Aggregation Functions as per ISO Standards

  • COUNT
  • SUM
  • AVG
  • MIN
  • MAX

Few other Aggregation Functions

  • APPROX_COUNT_DISTINCT
  • CHECKSUM_AGG
  • COUNT_BIG
  • GROUPING
  • GROUPING_ID
  • STDEV
  • STDEVP
  • STRING_AGG
  • VAR, VARP

Express your reaction

Your Take on This Insight?

Share how this content resonates with you.

Comment
Useful0
Insightful0
Actionable0
Thought-provoking0
Inspiring0

0 reactionsSign in to react or comment

Comments (0)

No comments yet.

    Free account

    You can read every topic without one. A free account lets you react to this topic, comment under it and search the Knowledge Hub. Reacting and commenting need a confirmed e-mail address.