Skip to main content
HomeReportingCase Study: Analyzing Customer Churn in Excel

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 Free
1 Hour4 Videos21 Exercises
5,783 LearnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
GroupTraining 2 or more people?Try DataCamp For Business

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.
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more
Try DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Excel Fundamentals

Go To Track
  1. 1

    Exploratory analysis

    Free

    In this first chapter, you’ll start by exploring your new dataset in Excel and gain an initial understanding of why customers are churning.

    Play Chapter Now
    Analyzing customer churn in Excel
    50 xp
    Analysis process
    100 xp
    Data preparation
    100 xp
    Understanding churn and it's applications
    50 xp
    Calculating churn
    100 xp
    Investigating churn reasons
    100 xp
    Digging deeper into churn categories
    100 xp
  2. 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.

    Play Chapter Now
  3. 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.

    Play Chapter Now
For Business

GroupTraining 2 or more people?

Get your team access to the full DataCamp library, with centralized reporting, assignments, projects and more

In the following Tracks

Excel Fundamentals

Go To Track

Datasets

Metadata SheetExercises and Datasets

Collaborators

Collaborator's avatar
Joanne Xiong
Jess Ahmet HeadshotJess Ahmet

Content 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.
See More

What do other learners have to say?

FAQs

Join over 14 million learners and start Case Study: Analyzing Customer Churn in Excel today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.