Can someone define data aggregation and explain how it works? or What does it mean to define data agg

Wow, thanks everyone! This really helps define data aggregation way better than the articles I was drowning in.

I tried the Excel pivot table thing and it kinda worked? But I’m still confused about when to use sum vs. average—like, which one’s better for sales data?

Also, gonna check out Tableau since a few of you mentioned it. Appreciate the real-world examples too—Netflix and Uber made it click for me.

(And yeah, raw data *is* a nightmare lol.)