Data Aggregation
From the book I Am Datapedia!, published here free by the author.
Data Aggregation is the most used term in our daily lives whether it’s in office or in home, we use it everywhere.
‘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.
As 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.
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.