This project focuses on analyzing customer churn data from a telecommunications company. The objective was to understand customer behavior, identify churn patterns, and create visualizations that provide meaningful business insights.
- Explored dataset structure
- Sorted customers by tenure
- Filtered churned customers
- Created column chart for churned vs non-churned customers
- Added labels and formatting
- Created histogram for monthly charges
- Analyzed distribution patterns
- Built pivot tables
- Created clustered bar chart comparing churn behavior across genders
- Analyzed relationship between tenure, monthly charges, and churn behavior
- Created heatmap visualization
- Microsoft Excel
- Pivot Tables
- Data Visualization
- Data Analysis Techniques
- Customers with shorter tenure showed higher churn rates.
- Monthly charges had a noticeable impact on customer churn.
- Gender-based churn differences were analyzed using pivot tables and charts.
- Visualizations helped identify important customer retention patterns.
- Customer Churn Dataset
- Excel Analysis Files
- Charts and Visualizations
- Project Notes and Documentation
Roshan Manjal