# Applying Advanced SQL for Analytical Insights - Mastering Growth Accounting: Hands-On Journey through User Growth and Retention Analysis (Day 1 Lab) 

> 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 a…

- Web page: https://www.dataexpert.io/lesson/analytical-patterns-day-1-lab-v3
- Program: [Data Engineering Boot Camp V2 Combined Track](https://www.dataexpert.io/program/data-engineering-boot-camp-v2-combined-track)
- Module: Week 3: Analytical Patterns & Analysis in Iceberg
- Access: Requires enrollment in Data Engineering Boot Camp V2 Combined Track
- Length: 51 min video
- Skills: SQL
- Academy: DataExpert.io Academy

## About this lesson

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: [Infrastructure Data Quality - Elevating Infrastructure Data Quality: Insights and Best Practices with Marc Lamberti (Day 2 Lecture)](https://www.dataexpert.io/lesson/infra-data-quality-day-2-lecture-v3.md)
- Next lesson: [Applying Advanced SQL for Analytical Insights - Exploring SQL, Scaling Projects, and Aggregation Analysis (Day 1 Lecture)](https://www.dataexpert.io/lesson/analytical-patterns-day-1-lecture-v3.md)