Churned Customer Analysis

The Churned Customer Dashboard is an analytical tool designed to provide insights into customer churn patterns. Key steps involved in the project include:

Data Cleaning: Ensured data accuracy and consistency by addressing missing values and inconsistencies.

Pivot Tables: Created to summarize and organize data for dynamic analysis of customer segments.

Key Metrics and Visualizations:

Core Metrics: Total customers, churned customers, churn rate, and average account length.

Churn Reasons: Displays main reasons for customer churn.

Customer Demographics: Pie chart showing age distribution.

Usage and Payment Patterns: Visuals for monthly consumption, age analysis, contract types, and payment methods.

The dashboard enables businesses to better understand and address customer churn, enhancing retention strategies.