SaaS subscription and retention analytics

The brief

A subscription business tracks sign-ups in one sheet and payments in another, and nobody trusts the revenue numbers. Load the data into a database and answer the questions investors ask: monthly recurring revenue, churn, and how each monthly cohort of customers keeps buying. Good looks like: reconciled SQL queries, a cohort retention chart and a one-page summary of what drives churn.

What you will build

1. Load the transactions into PostgreSQL or SQLite
2. Calculate monthly revenue, active customers and churn in SQL
3. Build monthly cohorts and a retention table
4. Check totals reconcile with the raw data
5. Present the findings in a short dashboard or report

Free, open data to build it with

• Online Retail II ↗ UCI Machine Learning Repository
• Telco Customer Churn ↗ Kaggle (IBM sample data)

Check each dataset's licence before you publish your work. Your mentor gives your team its own version of the brief (data, scope or region), so every team's project is its own.