# Applying Analytical Patterns: Aggregations and Cardinality Reduction Day 2 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.

- Web page: https://learn.dataexpert.io/lesson/applying-analytical-patterns-day-2-lab-yt
- Program: [Boot Camp: Community Edition](https://learn.dataexpert.io/program/free-community-boot-camp)
- Module: Applying Analytical Patterns
- Access: Requires enrollment in Boot Camp: Community Edition
- Length: 34 min video
- Skills: SQL, Data Modeling, ETL/ELT, Statistics
- Academy: DataExpert.io Community 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.

## Navigation

- Previous lesson: [Applying Analytical Patterns: Recursive CTEs and Window Functions Day 2 Lecture](https://learn.dataexpert.io/lesson/applying-analytical-patterns-day-2-lecture-yt.md)
- Next lesson: [Flink Lab Setup](https://learn.dataexpert.io/lesson/flink-lab-setup-yt.md)