# Grouping sets and Window functions Lab

> In this lab session, Zach demonstrates various queries and aggregations that can be applied to the bootcamp web events table. The talk emphasizes the significance of reducing cardinality and showcases the use of functions like coalesce and rollup. Zach also touches on the concept of self-joins and…

- Web page: https://www.dataexpert.io/lesson/grouping-sets-and-window-functions-lab-p735-l581
- Program: [AnalyticsExpert](https://www.dataexpert.io/program/analytics-expert)
- Module: Week 7: Analytical Patterns & CDC
- Access: Requires enrollment in AnalyticsExpert
- Length: 38 min video
- Skills: SQL
- Academy: DataExpert.io Academy

## About this lesson

In this lab session, Zach demonstrates various queries and aggregations that can be applied to the bootcamp web events table. The talk emphasizes the significance of reducing cardinality and showcases the use of functions like coalesce and rollup. Zach also touches on the concept of self-joins and how they can aid in analyzing a users journey on the website.

## Navigation

- Previous lesson: [Grouping sets and Window functions Lecture](https://www.dataexpert.io/lesson/grouping-sets-and-window-functions-lecture-p735-l580.md)
- Next lesson: [Capstone Project Day 1 Lecture](https://www.dataexpert.io/lesson/capstone-project-day-1-lecture-april2025-p735-l1051.md)