Basic of creating DATA SUMMARY using AGGREGATION, GROUPING & ALIAS in SQL | BigQuery

Опубликовано: 14 Февраль 2025
на канале: Pivotalstats

853

This will explain the concept of Aggregation which include SUM, COUNT, AVERAGE, MAX & MIN functions. Also we will see when do we need to apply GROUP BY for summarizing our data. Last concept covered in this video is ALIAS and we will see how all 3 pillar of data summarization is used in combination with each other to give you lot of control while doing data analysis.

Data Used
https://www.kaggle.com/datasets/dansb...

Visit my blog for more content :
www.pivotalstats.com

Affiliate Links --
Best Web Hosting Service :
https://bluehost.sjv.io/k0OkNv

Cool tech used for these videos :
1. Blue Yeti Microphone - https://amzn.to/3CeMv7C
2. LG Ultrawide Curved Monitor - https://amzn.to/3EaHY8v

sql group by,bigquery sql,group by in sql,bigquery,sql,bigquery tutorial,group by clause in sql,group by in mysql,google bigquery sql, sql server, bigquery sql tutorial,group by,google bigquery tutorial,google bigquery,sql group by having,cloud sql federation in bigquery,clausula group by en sql sever,sql tutorial,sql bigquery,how to set up a cloud sql federation in bigquery,sql group by using multiple columns,analyzing cloud sql datasets in bigquery