Capstone project
Pulse Activation, Cohorts, and Retention
Trustworthy activation funnel and cohort-retention analysis from product events. This public brief explains the scenario, deliverables, dataset, assessed skills, and guided-versus-independent expectations without revealing the full solution.
Scenario and deliverables
Trustworthy activation funnel and cohort-retention analysis from product events.
The project expects SQL, assumptions, bounded result snapshots, validation checks, and a local report export.
Milestones
Each milestone is graded as an activity and contributes to project evidence only after independent or transfer validation.
Result preview8 rows
| Step | Deliverable |
|---|---|
| Project step 1 | Event audit |
| Project step 2 | Milestone times |
| Project step 3 | Activation classification |
| Project step 4 | Funnel |
| Project step 5 | Account-month activity |
| Project step 6 | Cohort retention |
| Project step 7 | Segment comparison |
| Project step 8 | Product report |
Dataset, prerequisites, and workspace
The public brief describes the work; the app workspace provides the editor, dataset, hints, checker, and final export tools.
- Pulse Product dataset
- Prerequisite: Aggregate Functions and Null Semantics
- Prerequisite: GROUP BY and Report Grain
- Prerequisite: Dates, Timestamps, Time Zones, and Half-Open Ranges
- Prerequisite: Period Grouping, Complete Calendars, Cohorts, and Retention Foundations
- Prerequisite: Window Foundations and Ranking
- Open workspace
Page highlights
- Public project brief
- Milestone rubric summary
- Canonical dataset and prerequisite links to original SQL Trail assets
- Report-export expectation