Analyzed customer churn data to provide actionable insights for retention strategies
Project Overview
In today’s competitive telecom space, retaining customers is more cost-effective than acquiring new ones. This project explores churn behavior across contracts, internet services, demographics, and support systems to guide business decisions. 🔗 Read the full story on Medium: https://medium.com/@danisinator123/reducing-telecom-customer-churn-a-deep-dive-with-power-bi-5ec5d43ce5c9
Objectives Understand why customers leave
Identify high-risk churn groups
Recommend data-backed strategies to improve loyalty
Tools & Technologies Power BI (for visual storytelling)
DAX (for custom measures)
Power Query (data transformation)
Key Insights
Month-to-month contracts had the highest churn rates.
No tech support and no online backup, users were more likely to churn.
Customers without dependents showed significantly higher churn.
Fiber optic users churned less compared to DSL users.
Dashboard Features
Churn rate visualized by contract type, internet service, gender, dependents, and more
Custom KPIs like average tenure, total charges, and churn volume
Filters for deep dives (contract type, service, age group, etc.)
Clean layout with a business-ready look
Files Included
PowerBI_Churn.pbix Full interactive report https://app.powerbi.com/groups/me/reports/d0672e5e-420c-49a4-af72-1e4be9771c82/26b2323d10f31b66a989?experience=power-bi
README.md – This project overview
Business Impact
Equips decision-makers with a clear picture of churn behavior, enabling:
Smarter customer segmentation
Targeted retention campaigns
Cost reduction in acquisition