Analyzing customer churn in Excel

1.Project Title & Company Overview

Project title: Analyzing customer churn in Excel

Industry: Telecom

Business Introduction: The company is a telecom provider that operates in a saturated market where maintaining customer loyalty is challenging. They provide services such as mobile internet, and device plans to both individuals and businesses.

2. Business Problem

The telecom company was facing key challenges:

High level of customer churn
Untargeted marketing strategies
Revenue loss

3. Objectives

Identify churn patterns
Quantify customer churn
Improve customer retention.

4. Methodology and Tools Used

Data check in Excel
Data Exploration
Data Analysis & User Segmentation
Data visualization
Reporting and Recommendations

Tools used: Excel.

5. Key Deliverables

Delivered an Excel dashboard to identify churn patterns and make data-driven decisions.

6. Recommendations

Launch upgrade and loyalty offers for contract renewals
Improve support for senior customers
Implement proactive churn alerts using churn-risk profiles
Create personalized plans for seniors
Add value to entry-level plans