ClearLend-Customer Cohert & Retention Dashboard

Client:

Personal

Duration:

2 weeks

Product Analytics

Retention & Cohort Analysis

ClearLend — Customer Cohort & Retention Analytics
ClearLend is a customer retention analytics platform built to track and visualise how customers behave over time — across channels, products, and regions. It simulates real product analytics workflows used at companies like CRED and Groww — covering everything from raw data to a live interactive app and a Tableau dashboard.

My Approach
The goal was simple — build something that answers the questions every product team is always asking: who is staying, who is leaving, and why. I generated 50,000 customer records using Python, wrote SQL queries to analyse retention patterns, deployed a live Streamlit app, and designed a Tableau dashboard that makes cohort data easy to understand at a glance.

The Problem It Solves
Most businesses struggle to understand why customers stop coming back. ClearLend brings retention data into one place — tracking 30-day to 1-year retention curves, lifetime value by channel and product, and flagging high-value customers at risk of churning before it's too late.

The Analytics App
The live Streamlit app includes a cohort retention heatmap, retention curves by acquisition channel, lifetime value comparisons, an LTV segmentation chart, and a churn risk table highlighting 376 high-value customers. Each section is built to surface a clear, actionable insight.

The Dashboard
The Tableau dashboard gives a complete view of customer retention — cohort performance, LTV breakdown, and churn risk — all in one place. It is clean, interactive, and built for anyone who needs to understand their customer base without digging through raw data.

Why It Matters
ClearLend is fully live and open to explore. It reflects the kind of analytical thinking I bring to every project — finding the signal in the data and turning it into something businesses can actually act on.
Explore the Project