Lesson 2 of 10
Building cohorts and measuring retention
Track the same counts over time with a stable denominator.
32 minSQL Data Analyst
By the end of this lesson
- Define a cohort
- Deduplicate monthly activity
- Calculate interpretable retention
SQL Essentials
Unlock this lesson and continue the path.
Building cohorts and measuring retention is part of the complete programme: 38 lessons, 62 verifiable exercises and 8 published guided projects.
- Complete content with explained examples
- SQL simulator and expected result
- Detailed answer, common mistakes and challenge