Back to Gallery
SQLCapstone Project
Telecom Regional Revenue & ARPU Tracker
HM
BUILT BYHaris Mahmud
BEFORECustomer Support Representative
→
OUTCOMEReporting Analyst at Jazz
Status: Live DeployedInteractive Live Demo (Sandbox)→
Project Overview
An optimized SQL database structure and query pack answering complex regional revenue questions on millions of records.
Data Scrubbing & Cleaning Pipeline
The student imported raw messy CSV database backups, scrubbed redundant column entries, normalized data structures, handled duplicate records, and configured relationship models using SQL schemas and Power BI.
Analytical Insights Generated
Configured cohort retention models, isolated regional operational leakages, tracked active customer churn risk, and mapped average revenue metrics across locations.
Project Specs
CORE TOOLSQL
DATA ROWS PROCESSED500,000+ Records
TIME TO BUILD3 Weeks
COMPLEXITY LEVELHiring Grade