# Advanced SQL and Applying Analytical patterns  (Day 1 Lab)

> This is a pre-recorded class. In this hands-on lab session, we embark on a practical journey of growth accounting. The video guides you through the step-by-step process, illustrating how to create a partition column, calculate active dates, and adeptly track state transitions. Common challenges enc…

- Web page: https://www.dataexpert.io/lesson/analytical-patterns-day-1-lab-v4
- Program: [Data Engineering Mastery Course](https://www.dataexpert.io/program/data-engineering-mastery-course)
- Module: Week 5: Analytical Patterns & Analysis in Iceberg
- Access: Requires enrollment in Data Engineering Mastery Course
- Length: 39 min video
- Skills: SQL
- Academy: DataExpert.io Academy

## About this lesson

This is a pre-recorded class. In this hands-on lab session, we embark on a practical journey of growth accounting. The video guides you through the step-by-step process, illustrating how to create a partition column, calculate active dates, and adeptly track state transitions. Common challenges encountered in this process are addressed, accompanied by effective solutions. By the conclusion of the video, you will have gained a lucid understanding of analyzing user growth and retention. This session equips you with practical skills to navigate and excel in the intricacies of growth accounting, providing valuable insights applicable to real-world scenarios. [Recorded on Nov 27, 2023]

## Navigation

- Previous lesson: [Kafka Fundamentals, consumer APIs with Confluent (Day 1 Lab)](https://www.dataexpert.io/lesson/flink-streaming-day-1-lab-v4.md)
- Next lesson: [Advanced SQL and Applying Analytical patterns  (Day 1 Lecture)](https://www.dataexpert.io/lesson/analytical-patterns-day-1-lecture-v4.md)