Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Case Study: Analyzing Customer Churn in Excel

via DataCamp

Overview

You will investigate a dataset from a fictitious company called Databel in Excel, and need to figure out why customers are churning.

Are you ready to apply your Excel skills to a fictitious dataset? 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.

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.

Syllabus

  • 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.
  • Investigating churn patterns
    • You’ll continue leveraging the Excel knowledge you gained from the prerequisite courses to investigate further why customers are leaving Databel.
  • 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.

Taught by

Jess Ahmet

Reviews

Start your review of Case Study: Analyzing Customer Churn in Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.