churn analysis

Developed an interactive Customer Churn Analysis Dashboard in Microsoft Excel to analyze customer retention and churn behavior.

Performed data cleaning and preprocessing to prepare customer data for analysis.

Calculated key KPIs including total customers and churn rate using Excel formulas.

Analyzed major churn reasons such as pricing, service dissatisfaction, and competitor offers.

Built visualizations including bar charts, pie charts, and donut charts to present churn patterns clearly.

Conducted demographic analysis to understand churn distribution across different customer groups.

Analyzed competitor impact on churn, identifying factors like better offers, devices, and data plans.

Evaluated customer churn trends by age group to identify high-risk segments.

Designed a clean and user-friendly dashboard layout to support business decision-making.