E-commerce Analytics Platform with CLV & Churn Prediction

Problem

E-commerce and growth teams managed multiple KPIs (revenue, CLV, churn, product mix) without a unified interactive platform for cohort filtering and time-range analysis. Spreadsheets could not handle real-time dashboard requirements.

Approach

Built a full analytics platform using Python and Pandas for data aggregation with 15+ interactive Plotly charts. Implemented Customer Lifetime Value (CLV) calculations, churn analysis, and revenue tracking in a multi-page Streamlit application with linked filters. Designed for regular business review cycles.

Result

One dashboard replaced spreadsheet chaos for the entire growth team. CLV, churn, and revenue visible in real time, no more weekly export rituals.

• ◆One dashboard replaced multiple spreadsheet workflows
• ◆Growth team reviews CLV, churn, and revenue in real time
• ◆Linked filters let leaders drill from overview to cohort in seconds
• ◆Weekly export rituals replaced with live data