Identifying Customers Likely to Churn for a Telecommunications Provider
- Guided Project
- 0.9 hours
- Beginner
- Excel
Practice Exploratory Data Analysis in Excel to identify customer churn risk profiles from real telecom data.
Overview
In this project, you'll take on the role of a data analyst at a telecommunications company. Your challenge is to explore customer data in Excel to identify profiles of those likely to churn. Retaining customers is crucial for telecom providers, so your insights will help inform proactive retention efforts.
You'll conduct exploratory data analysis, calculating key statistics, building PivotTables to slice the data, and creating charts to visualize your findings. This project provides hands-on experience with core Excel skills for data-driven business decisions that will enhance your analyst portfolio.
Objective: Analyze telecommunications customer data in Excel to profile churn risks and provide an actionable insights report.
What You'll Learn
- ✓ Calculate descriptive statistics using Excel functions
- ✓ Use descriptive statistics to analyze real-world data
- ✓ Create PivotTables to explore differences in the data
- ✓ Compare and contrast histograms to analyze frequency distributions
- ✓ Compile a report in Excel comprised of data visualizations and tabular data
Before You Start
- ✓ Calculating descriptive statistics in Excel
- ✓ Analyzing data with descriptive statistics
- ✓ Creating PivotTables in Excel to explore and analyze data
- ✓ Visualizing data with histograms and boxplots in Excel
Project Steps
10 steps
- 1 Introduction
- 2 Churn Rate
- 3 Initial EDA
- 4 Exploring Data Grouped by State and Churn
- 5 Exploring Data Grouped by voice_mail_plan and churn
- 6 Analyzing Frequency Distributions
- 7 Visualizing Data Grouped by State and Churn
- 8 Exploring and Visualizing Data Grouped by Churn
- 9 Final Report
- 10 Next Steps
Join 1M+ data learners on Dataquest.
- 1
Create a free account
- 2
Choose a learning path
- 3
Complete exercises and projects
- 4
Advance your career