Projects/SaaS Churn & Retention Analysis
intermediate5 milestones · ~12 hours

SaaS Churn &
Retention Analysis

A SaaS CFO wants to know why customers leave and what to do about it. You'll run TWO independent investigations using different methods — cohort retention and behavioural predictors — then make the meta-call: which one is actually more actionable. Most analysts run every analysis they can think of. Mature analysts run several and recommend one. This project teaches the second skill explicitly.

Full project workspace, live PostgreSQL DB, AI Project Mentor & verified credential

What you'll learn

  • —Compute MRR and churn rate from raw subscription data — defensibly
  • —Run a cohort retention analysis and articulate what its shape reveals
  • —Identify behavioural churn predictors using event-log comparison
  • —Make the meta-call: which analytical lens is more actionable, and why
  • —Communicate that meta-call to a CFO in plain language with numbers

The 5 milestones

Each milestone is reviewed before you advance.

  1. 01

    Set up your project repo

    Milestone 1

    Before any analytical work: create a public GitHub repository, push the standard skeleton, and paste the URL into your workspace.

  2. 02

    Foundation — definitions, MRR, topline churn

    Milestone 2

    Map the SaaS data, lock down 'active' and 'churned' definitions, and compute the headline numbers.

  3. 03

    Investigation A — cohort retention

    Milestone 3

    First independent investigation: build cohort retention curves and articulate what they reveal.

  4. 04

    Investigation B — behavioural predictors

    Milestone 4

    Second independent investigation: identify what behavioural signals differ between churned and retained customers.

  5. 05

    Synthesize — which lens matters more, and what to do

    Milestone 5

    The meta-skill milestone: pick the more actionable investigation, argue for it, and ship the portfolio piece.

Reading & references

Pre-flight setup: Python environment for this project
Setup Guide · Premium
SaaS metrics: MRR, ARR, churn, NRR explained
Article
Computing MRR from raw subscription data
Article · Premium
Cohort retention analysis: a primer
Article
Building cohort heatmaps with pandas + seaborn
Article · Premium
Behavioural churn predictors in SaaS
Article · Premium
How to choose between competing analyses
Article · Premium
Anatomy of a great portfolio README
Article

Build your portfolio & get certified

Want more projects like this? Join our Data Analyst Work Experience Program to complete 5+ guided industry projects, gain real experience, and earn an internship certificate.

Join the Data Analyst Work Experience Program

Free SaaS Churn & Retention Analysis portfolio project — with AI review

Build a real saas churn & retention analysis project for your data analyst portfolio in your own public GitHub repo — free brief, starter template, and milestone guides. When your code is ready, the ₹99 pass gets every milestone reviewed against a fixed rubric (saas churn retention analysis walkthrough included) and issues a verifiable certificate on completion.

Is the SaaS Churn & Retention Analysis project free?

The full project brief, milestone guides, and starter template are free to audit. The AI-powered review pass and verified certificate unlock at ₹99.

Can I add the SaaS Churn & Retention Analysis project to my resume and GitHub?

Yes — that is the point. You build in your own public GitHub repo, every milestone is reviewed against a fixed rubric, and the certificate links to the repo employers can inspect. Only list what is visible in your repo.

How long does the SaaS Churn & Retention Analysis project take?

Most students finish the 5 milestones in 2–4 weekends. Milestones unlock in order, and you can re-submit any milestone that needs work.

Rubric-reviewed · Plagiarism-checked · Verifiable certificate