Customer Churn Analysis
Databel Telecom Provider
Completed March 2024
-
Databel Executives and Marketing Team
-
Databel is a fictitious company. The data set was created by Data Camp for the purpose of completing case studies.
The data is a time stamp that includes customer status, demographics, contract information, subscription types end charges, and plan information.
-
Interactive Dashboard in Excel
-
Customer Churn
Excel Functions, Pivot Tables, ad Visualizations (LEN, SUMIF, COUNTIFS, FILTER, REPLAC, SLICERS, AND/OR)
Descriptive Statistics
Business Recommendations
Dashboard Design
-
Excel
Context and Objective:
Databel is a fictitious Telecom provider. They seek to understand why customers are churning, or leaving, Databel. Databel has noticed that adding new customers has not necessarily increased their revenue. Their top priority is reducing churn to retain their current customers rather than focusing on attracting new customers.
Key Questions
1. Why are customers leaving Databel?
2. How can Databel retain its current customers to increase profit?
Final Deliverable: Excel Dashboard
I began the analysis by exploring the data to develop a data understanding and relate the data to the business goals. Focus areas included reason for leaving, age groups, data plan type, international calls, and contract type. After calculating churn, I identified that customers are leaving Databel primarily because of competitor factors. Finally, I compiled key insights into an interactive Dashboard.