Interactive Power BI Dashboard to Tackle Telecom Churn IssuesInteractive Power BI Dashboard to Tackle Telecom Churn Issues
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
I built this 3-page interactive Power BI dashboard to find out exactly why customers are leaving a major Telecom company and where revenue is at risk. The project covers everything from cleaning the raw data to designing a professional, interactive app-style dashboard.
Core Insights & Business Value Delivered
The Churn Problem: Out of 7,043 total customers, the company has a 26.54% churn rate. This is a massive loss in numbers and shows a major revenue risk.
Contract Risk Factors: The data shows that Month-to-Month contract holders are the most likely to leave. Getting them onto 1-year or 2-year plans keeps them around much longer.
The 12-Month Danger Zone: The highest number of leaves happens within the first 0–12 months of a customer signing up. Fix the onboarding, and you save the customer.
Demographic Patterns: Churn rates change heavily depending on customer demographics, like whether they are senior citizens, or if they have partners and families.
Technical Implementation & Toolkit
Data Engineering & Cleaning (SQL): Imported the data, hunted down all null values and blank spaces, and structured the tables so everything runs fast and accurate.
DAX & Data Modeling: Wrote custom DAX formulas for KPIs like Total Revenue ($16.05M) and Average Tenure so all charts filter each other perfectly when clicked.
UI/UX Custom Dashboard Design (Power BI): Built a custom dark theme from scratch. I used floating shapes to create a clean left sidebar navigation menu, which completely gets rid of ugly white spaces and makes it look like a real app.
Back to feed
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started