SOURABH BANSAL

Customer Churn Analysis

ABOUT
Find CODE
on GitHub
(If Applicable)
Customer Churn Rate Analysis Dashboard is an interactive tool designed to help businesses monitor and analyze customer retention patterns. This comprehensive dashboard provides key insights into customer churn, enabling companies to identify trends, evaluate the effectiveness of their services, and implement strategies to reduce churn rates. The dashboard visualizes critical metrics such as average tenure, monthly charges, gender distribution, churn correlation with services, and the impact of customer support interactions, making it an essential resource for data-driven decision-making.
Key Features:
Dynamic Filtering: Users can interact with multiple filters, including Contract Type, Payment Method, and Paperless Billing options, to drill down into specific customer segments.
Churn Visualization: The dashboard displays churn rates across various categories, such as gender, partner status, and service types, helping identify high-risk segments.
Correlation Analysis: A scatter plot illustrates the correlation between monthly charges and tenure, segmented by churn status, offering insights into pricing strategies and customer loyalty.
Ticket-Based Churn Analysis: The impact of technical support tickets on churn is visualized, highlighting the relationship between the number of tickets raised and customer retention.
Service Utilization: Detailed metrics on services availed, such as Phone Service, Internet Service, and value-added services like Streaming TV, Online Security, and Tech Support, are presented to understand customer preferences.
Requirements:
Power BI Desktop: Required for building, viewing, and interacting with the dashboard.
Dataset: A structured dataset containing customer information, service details, tenure, monthly charges, and churn status is essential for accurate analysis.
Customer Churn Rate Analysis Dashboard is a powerful tool that equips businesses with the insights needed to proactively address customer churn. By visualizing key metrics and uncovering correlations, this dashboard helps organizations make informed decisions to enhance customer satisfaction and retention.