# Applying Analytical Patterns Day 1 Lab

> The lab focuses on applying analytical patterns using a bootcamp web events table in Starburst. Participants will learn to create a daily dataset of user metrics, including sign-up, landing, and contact page visits, and implement state transition tracking for user behavior analysis. By the end, lea…

- Web page: https://www.dataexpert.io/lesson/applying-analytical-patterns-day-1-lab-jan2025
- Program: [2025 New Year  Data Engineering Boot Camp starting January 6th](https://www.dataexpert.io/program/2025-new-year-data-engineering-boot-camp-starting-january-6th)
- Access: Requires enrollment in 2025 New Year  Data Engineering Boot Camp starting January 6th
- Length: 38 min video
- Skills: SQL, Data Modeling, ETL/ELT
- Academy: DataExpert.io Academy

## About this lesson

The lab focuses on applying analytical patterns using a bootcamp web events table in Starburst. Participants will learn to create a daily dataset of user metrics, including sign-up, landing, and contact page visits, and implement state transition tracking for user behavior analysis. By the end, learners will understand how to manage user states such as new, retained, churned, and resurrected, enabling them to derive insights on user engagement and retention over time.

## Navigation

- Previous lesson: [Applying Analytical Patterns Day 1 Lecture](https://www.dataexpert.io/lesson/applying-analytical-patterns-day-1-lecture-jan2025.md)
- Next lesson: [Advanced SQL Patterns Day 2 Lecture](https://www.dataexpert.io/lesson/advanced-sql-patterns-day-2-lecture-jan2025.md)