(Part 1) BigQuery Window Function | Explained in Sheets | Rank, Dense Rank, Lead, Lag
This tutorial is about Window Functions in BigQuery. Types of Window Functions covered in this video are RANK, DENSE RANK, ROW NUMBER, LEAD, LAG, FIRST VALUE, and LAST VALUE. Also, we see how to use BigQuery Aggregate functions like MIN, MAX, SUM, COUNT, AVG as window function.
Chapters:
0:00: Window Function Partition and Order
5:07: RANK ()
6:25: DENSE_RANK ()
7:24: ROW NUMBER ()
9:31: SUM () Partition by Date
11:07: ORDER_BY
13:09: COUNT()
14:25: LAG() and LEAD()
16:06: FIRST_VALUE () and LAST_VALUE ()
Company Website: https://www.datadice.io/
Follow us:
Medium (blog posts about Google Data Analytics Release Notes, Data Studio Tips & Tricks, Introductions to Google Cloud Tools and many more): https://bit.ly/3trJPRr
LinkedIn (stay informed about most important company news): https://bit.ly/3qqJKeX