Portfolio
Back to Projects

May 2026

Apex Revenue Assurance Dashboard

Telecom Customer Churn & Revenue Intelligence

PythonSQLStreamlitPlotlyPandasNumPy

Overview

A premium telecom analytics dashboard analyzing churn patterns and revenue leakage across 50,000+ customer records, with a revenue recovery simulation module for strategic decision-making.

Problem Statement

Telecom operators lose significant recurring revenue to churn that goes undetected until the customer has already churned. The challenge is identifying at-risk segments early and quantifying recovery potential.

Key Highlights

Analyzed churn patterns across 5 risk segments, identifying retention opportunities to recover up to 23% of at-risk revenue

Dynamic KPI dashboards visualizing churn trends, lifetime value, and segment risk scores across 50,000+ customer records

Revenue recovery simulation module enabling stakeholders to model retention scenarios for high-value decision support

Architecture

Multi-page Streamlit app with Pandas-driven data pipeline, NumPy-powered risk scoring, and Plotly for interactive segment drill-down and scenario simulation.

Challenges

Designing the segment risk scoring model to be both statistically robust and interpretable enough for a non-technical business audience.

Learnings

Revenue leakage modeling, stakeholder-focused dashboard design, and building simulation tools that drive real business action rather than just reporting.