Skip to main content
HomeBusiness Intelligence

Course

Case Study: Analyzing Customer Churn in Excel

BasicSkill Level
4.8+
2,749 reviews
Updated 04/2026
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
ExcelReporting
1 hr
4 videos
21 Exercises
1,750 XP
28,736
Statement of Accomplishment

Create Your Free Account

Continue with GoogleShow more options

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

Group

Training a Team?

Try for Business

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.

Prerequisites

Introduction to Excel
1

Exploratory analysis

In this first chapter, you’ll start by exploring your new dataset in Excel and gain an initial understanding of why customers are churning.
Start Chapter
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.
Start Chapter
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.
Start Chapter
Case Study: Analyzing Customer Churn in Excel
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.8
from 2,749 reviews
85%
14%
1%
0%
0%
  • Vince
    9 hours ago

  • Giang
    10 hours ago

  • Andreas
    19 hours ago

  • Daniel
    yesterday

  • Nicholas
    yesterday

  • Andy
    yesterday

Vince

Giang

Andreas

FAQs

What is the main focus of this Excel case study?

The main focus is to apply your Excel skills. Specifically, the case study centers around analyzing customer churn rates in a subscription-based business context. You will learn to investigate and understand why customers are churning and how to reduce churn.

Do I need prior experience with Excel to take this course?

It is strongly recommended that you complete the Excel Fundamentals track on DataCamp before starting this case study.

How will this case study help me in a real-world business analysis context?

This case study will equip you with practical Excel skills directly applicable to real-world business scenarios, especially in subscription-based businesses. By learning to analyze churn data and create informative dashboards, you'll be able to provide valuable insights that can help in making data-driven decisions to reduce customer churn and improve business performance.

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

    Create Your Free Account

    Continue with GoogleShow more options

    or

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

    Grow your data skills with DataCamp for Mobile

    Make progress on the go with our mobile courses and daily 5-minute coding challenges.