Customer Churn Case Study
Introduction
Understanding why customers leave is crucial for businesses aiming to improve their retention strategies and enhance overall customer satisfaction. This case study provides a comprehensive analysis of churn rates, examining various factors such as contract types, payment methods, customer demographics, and service-related issues. By exploring detailed data, we uncover key insights into the reasons behind customer churn, including competitor offers, service dissatisfaction, and pricing concerns. Join us as we navigate through the data to reveal patterns and trends that can help businesses reduce churn and foster long-term customer loyalty.
Project Overview
This project was built to help businesses understand why customers leave and how they can improve retention. Using Power BI, I created an interactive dashboard that transforms raw customer data into clear business insights.
Business Challenge
Customer churn directly impacts revenue and growth. The company had rising customer losses but lacked visibility into the reasons behind it. Without data-driven insights, retention efforts were reactive instead of strategic.
My Contribution
I collected and modeled customer data including demographics, contract types, payment methods, and service behavior. I designed a Power BI dashboard to track churn patterns across multiple dimensions.
Key analysis included:
Overall churn rate: 26.86%
Monthly contract churn: 46.29%
Yearly contract churn: 6.62%
Unlimited plan churn: 32.11%
Top churn reasons: competitor offers, pricing issues, service dissatisfaction
I also created visual reports for churn by age, payment method, account length, and support interactions.
Business Outcome
The dashboard helped identify high-risk customer segments and key retention opportunities. Based on the findings, the business can reduce churn through better pricing, stronger customer support, and improved service quality.
Final Conclusion
This project demonstrates how data analytics can turn customer behavior into actionable strategies. Instead of guessing why customers leave, the company can now make informed decisions backed by real metrics.