Customer Churn Analysis (Excel)

This project analyzes telecom customer churn using Excel. The workbook includes the raw dataset, cleaned tables, pivot tables, and a churn analysis dashboard built with pivot charts excel_dashboard/ Analyzing Customer churn.xlsx

documentation/ dashboard_notes.md

Key Questions Answered

• Which contract type has the highest churn rate?
• Do customers with higher monthly charges churn more?
• Do customers with fewer subscribed services churn more?
• Does payment method influence churn?
• Are short-tenure (new) customers more likely to churn?
• Which customer segments have the highest churn risk?

Insights Summary

• Month-to-month customers churn the most.
• Higher monthly charges correlate with higher churn.
• Customers with fewer add-on services churn more.
• Paper Check users churn at a higher rate.
• New customers (low account length) have the highest churn probability.

Tools Used

• Microsoft Excel
  • Pivot Tables
  • Pivot Charts
  • Basic data cleaning and transformation