← All case studies
E-commerceBusiness Intelligence
15+ KPIs · Real-time

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 comprehensive 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

Live analytics dashboard serving as the single operational review surface for e-commerce teams. Tracks comprehensive KPIs including CLV, churn rates, revenue metrics, sales performance, customer behavior, product trends, and demographic analysis.

  • 15+ interactive visualizations
  • Full KPI coverage: CLV, Churn, Revenue
  • Multi-page dashboard with linked filters
  • Product trends and demographic analysis
15+
Visualizations
CLV · Churn · Revenue
KPIs tracked
Real-time
Update frequency
Plotly · Streamlit
Stack
E-commerceBIPlotlyStreamlitCLVChurn Analysis