Telecom Churn Analysis
About this project
The dataset consisted of 7043 customers in California and includes details about customer demographics, location, services, and current status.
Overview: Customer churn is one of the biggest challenges for telecom companies as it impacts the revenue and growth of the company. This project aims to analyze the customer churn rate for a telecom company using Microsoft Excel.
Objectives: The objectives of this project are as follows:
- To identify the factors that contribute to customer churn.
- To analyze the customer churn rate for the telecom company
- To develop strategies to reduce the churn rate.
Deliverables: The following deliverables was provided at the end of the project:
Customer Churn Report: A report was prepared that includes the analysis of the customer churn rate, factors contributing to churn, and strategies to reduce churn.
Dashboard: A dashboard was created using Excel that provides a visual representation of the customer churn rate and other relevant metrics.
Recommendations: Recommendations was provided to the telecom company based on the findings of the analysis.
Conclusion: This project helped the telecom company to understand the factors that contribute to customer churn and develop strategies to reduce churn rate. By reducing churn, the company increased revenue and improved customer loyalty.
