Built an interactive Power BI dashboard during the PwC Forage Virtual Experience to analyze telecom customer churn, identify high-risk customers, and present actionable business insights through interactive visualizations and KPI reporting.
Overview
This project was completed as part of the PwC Forage Virtual Experience Program. The objective was to analyze telecom customer data and understand the key factors contributing to customer churn. Using Power BI, I developed an interactive dashboard that enables users to explore customer demographics, account information, subscription details, payment behavior, and churn trends through dynamic filters and visual reports.
Problem Statement
The telecom company had access to a large amount of customer data but lacked an easy way to identify why customers were leaving. Business users needed an interactive dashboard that could highlight churn patterns, customer segments, contract performance, and customer risk so they could make informed retention decisions.
Objectives
• Analyze customer churn across different customer segments.
• Identify customers with a higher probability of churn.
• Understand the impact of contract type, tenure, and payment method.
• Build an interactive Power BI dashboard for business users.
• Provide insights that support customer retention strategies.
• Enable faster decision-making using visual analytics.
Dataset & Cleaning
Data Source
The dataset was provided as part of the PwC Forage Virtual Experience Program.
The dataset included customer demographics, account details, subscription information, contract types, payment methods, internet services, monthly charges, total charges, tenure, support tickets, and customer churn status.
Data Cleaning & Prep
Before creating the dashboard, the dataset was prepared using Power Query.
The cleaning process included:
• Handling missing values
• Removing duplicate records
• Standardizing data types
• Renaming columns
• Validating categorical values
• Creating calculated columns required for reporting
Modeling & DAX
The dashboard was developed using Power BI Desktop.
The overall workflow included:
• Data transformation using Power Query
• Data modeling and relationships
• DAX measures for KPIs
• Interactive slicers and filters
• Multi-page dashboard navigation
• Cross-filtering between visuals
• KPI card creation
• Business-focused dashboard design
Key Performance Indicators
1869
Customer at Risk
27.89%
Overall Churn Rate
13.95M
Yearly Revenue
426.90K.
Monthly Revenue
2955
Tech Tickets
3632
Admin Tickets
16.06M
Yearly Charges
456.12K
Monthly Charges
Key Insights
Month-to-Month contract customers showed the highest churn rate.
Electronic Check was the most common payment method among churned customers.
Fiber Optic users experienced higher churn compared to DSL customers.
Customers with shorter tenure were more likely to leave the service.
Interactive filters helped analyze churn across multiple customer segments.
Recommendations
Promote long-term contracts to reduce churn.
Offer personalized retention plans for high-risk customers.
Improve onboarding experience for new customers.
Encourage customers to adopt value-added services.
Monitor churn trends regularly using the dashboard.
Business Impact
The dashboard simplified customer churn analysis by bringing all important business metrics into one interactive report. It reduced the time required to analyze customer behavior and helped highlight key areas where customer retention efforts could be focused.
Challenges Faced
Understanding customer churn across multiple business dimensions.
Preparing a clean dataset for reporting.
Creating meaningful DAX measures for KPIs.
Designing a user-friendly multi-page dashboard.
Learnings
Improved Power BI dashboard design skills.
Learned advanced Power Query transformations.
Applied DAX to create business KPIs.
Improved data modeling and relationship management.
Strengthened business storytelling through dashboards.
Tags
Power BICustomer AnalyticsTelecom AnalyticsBusiness IntelligencePwC ForageData VisualizationPower QueryDAXCustomer Churn