Portfolio Projects/SaaS Churn & Retention Analysis
₹99data scientist · Core Skillintermediate · ~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.

DatabasePostgreSQL
ToolchainJupyter
Milestones5 Guided Stages
Recruiter OutputVerified GitHub Repo
View 5 Milestones
Full project workspace, live database credentials, AI mentor & verified certificate
Project Deliverables

What You Will Ship to GitHub

Hiring managers don't want to see another cookie-cutter Titanic or Iris tutorial. You will build a professional repository with modular scripts and executive business memos that demonstrate commercial analytical maturity.

github.com/your-username/saas-churn-retention-analysisPortfolio Structure
├── sql/
01_exploratory_profiling.sql // Schema audits, table volume, date ranges
02_revenue_trends.sql // Monthly GMV, order volume & AOV evolution
03_customer_concentration.sql // Pareto 80/20 distribution, repeat buyer cohorts
├── findings/
00_executive_summary.md // 3 core business takeaways for executive stakeholders
01_business_health.md // Detailed breakdown of margins, cancellations, and seasonality
03_customer_segments.md // Customer lifetime spend & cohort concentration
├── README.md // Professional project front-door with data schema diagram
Outcomes

What You Will Master

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
Curriculum

5 Guided Project Milestones

M1

Set up your project repo

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

~30 mins
M2

Foundation — definitions, MRR, topline churn

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

~90 mins
M3

Investigation A — cohort retention

Core Milestone

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

~90 mins
M4

Investigation B — behavioural predictors

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

~90 mins
M5

Synthesize — which lens matters more, and what to do

Review Pass Required

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

~60 mins
Career Value

ATS Keywords & Resume Ready Bullets

Tools
PostgreSQLPythonpandasmatplotlib/seabornJupyterGit/GitHub
Methods
Common Table Expressions (CTEs)Window FunctionsTime-Bucket AggregationsCohort AnalysisData Profiling & Auditing
Business Concepts
AOV (Average Order Value)Customer ConcentrationRepeat Purchase BehaviorCohort RetentionRevenue Health Metrics
Pre-Written Resume Bullet (Copy & Paste)

"Authored an end-to-end data analytics project on SaaS Churn & Retention Analysis utilizing PostgreSQL, Python, pandas — delivered production-grade queries, cohort distributions, and an executive stakeholder summary published as a portfolio GitHub repository."

Preparation

Reading & References

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

Ready to build and ship SaaS Churn & Retention Analysis?

Instant access to cloud database credentials, milestones, and starter queries.

Project Overview

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

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.

Access
₹99