Case Study: Analyzing Customer Churn in Excel
You will investigate a dataset from a fictitious company called Databel in Excel, and need to figure out why customers are churning.
Start Course for Free3 Hours4 Videos21 Exercises
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Loved by learners at thousands of companies
Course Description
Are you ready to apply your Excel skills to a fictitious dataset?
Apply your Excel Skills with a Case Study
For subscription-based businesses, reducing customer churn is a top priority. In this Excel case study, you'll investigate a dataset from an example telecom company, Databel, and analyze their churn rates.Understand why customers churn
Analyzing churn doesn’t just mean knowing the churn rate: it’s also about figuring out why customers are churning at the rate they are and how to reduce churn. You'll answer these questions by creating calculated columns and fields, building PivotTables, and creating an eye-catching dashboard.- 1
Exploratory analysis
FreeIn this first chapter, you’ll start by exploring your new dataset in Excel and gain an initial understanding of why customers are churning.
- 2
Investigating churn patterns
You’ll continue leveraging the Excel knowledge you gained from the prerequisite courses to investigate further why customers are leaving Databel.
- 3
Creating a cohesive story
In the last chapter, you’ll create a dashboard-style sheet and arrange your visuals to present your results to stakeholders in a cohesive story.
In the following tracks
Excel FundamentalsCollaborators

Prerequisites
Introduction to ExcelJess Ahmet
See MoreContent Developer at DataCamp
Jess is a Content Developer at DataCamp. Prior to joining DataCamp, she worked in various analyst roles within healthcare and most recently online gambling. She has a passion for education, data, and business which she has been able to combine in her role at DataCamp. Outside of work, you can often find her in front of a TV watching Soccer and Formula 1.
What do other learners have to say?
Join over 12 million learners and start Case Study: Analyzing Customer Churn in Excel today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.