# Applying Analytical Patterns Day 1 Lab

> Learn how to apply analytical patterns using SQL and Starburst in this hands-on lab focused on web event data. Participants will create daily user metrics from a web events table, build a state tracking system to monitor user engagement, and analyze user behavior over time. This lesson is ideal for…

- Web page: https://www.dataexpert.io/lesson/applying-analytical-patterns-day-1-lab-jan2025-p736-l815
- Access: Requires enrollment
- Length: 38 min video
- Skills: SQL, Data Modeling, ETL/ELT
- Academy: DataExpert.io Academy

## About this lesson

Learn how to apply analytical patterns using SQL and Starburst in this hands-on lab focused on web event data. Participants will create daily user metrics from a web events table, build a state tracking system to monitor user engagement, and analyze user behavior over time. This lesson is ideal for data engineers and analysts looking to enhance their skills in data transformation and user analytics.