# Growth Accounting Lab

> In this lab, Zach walks through building a state transition tracking system to analyze user behavior, including churn and retention rates. He works with several datasets, specifically focusing on platform users and website events, and he demonstrates how to create and manipulate tables using SQL. H…

- Web page: https://www.dataexpert.io/lesson/growthaccountinglab-jan2026-p735-l1905
- Program: [AnalyticsExpert](https://www.dataexpert.io/program/analytics-expert)
- Module: Week 7: Analytical Patterns & CDC
- Access: Requires enrollment in AnalyticsExpert
- Length: 1 h 1 min video
- Skills: SQL, Data Modeling, ETL/ELT
- Academy: DataExpert.io Academy

## About this lesson

In this lab, Zach walks through building a state transition tracking system to analyze user behavior, including churn and retention rates. He works with several datasets, specifically focusing on platform users and website events, and he demonstrates how to create and manipulate tables using SQL. He also highlights the importance of understanding user activity over time and how to set up a growth accounting DAG with data quality checks.

## Navigation

- Previous lesson: [How to do Growth Accounting like Meta](https://www.dataexpert.io/lesson/howtodogrowthaccountinglikemeta-jan2026-p735-l1903.md)
- Next lesson: [Mastering Change Data Capture (CDC)](https://www.dataexpert.io/lesson/masteringchangedatacapturecdc-jan2026-p735-l1902.md)