Skip to main content

Case Study: Analyzing Customer Churn in Power BI

4.6+
46 reviews
Beginner

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

Start Course for Free
3 Hours4 Videos25 Exercises
20,595 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.

Loved by learners at thousands of companies

Course Description

Are you ready to apply your Power BI skills to a real-world dataset?

Apply your Power BI skills with a Case Study

For subscription-based businesses, reducing customer churn is a top priority. In this Power BI case study, you'll investigate a dataset from an example telecom company called Databel and analyze their churn rates.

Understand why customers churn

Analyzing churn doesn’t just mean knowing what the churn rate is: 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 measures and calculated columns while simultaneously creating eye-catching report pages.
  1. 1

    Exploratory Analysis

    Free

    In this first chapter, you'll start exploring the new dataset and revisit creating measures in Power BI to get a better understanding of why customers are churning.

    Play Chapter Now
    Analyzing customer churn in Power BI
    50 xp
    Analysis process
    100 xp
    Data check time
    100 xp
    Understanding churn
    50 xp
    Calculating churn
    100 xp
    Investigating churn reasons
    100 xp
    Digging deeper into churn categories
    100 xp
    Use maps to your advantage
    100 xp
  2. 2

    Investigating Churn Patterns

    You'll continue by leveraging the Power BI knowledge you gained from the prerequisite courses to further investigate why customers are leaving Databel.

    Play Chapter Now
    Zooming out
    50 xp
    Analyzing demographics
    100 xp
    Age groups
    100 xp
    Inspecting groups
    100 xp
    Multiple fields to investigate
    100 xp
    Unlimited plan
    100 xp
    International calls
    100 xp
    Advice to Databel
    50 xp
    Contract type
    100 xp
  3. 3

    Visualizing your Analysis

    In the last chapter, you'll create dashboard-style pages and arrange them into stories, so that you can share your results with stakeholders.

    Play Chapter Now
    Creating a cohesive story
    50 xp
    Dashboarding best practices
    50 xp
    Overview page
    100 xp
    Age brackets & groups
    100 xp
    Payment method and contract category
    100 xp
    International and data plan
    100 xp
    More insights
    100 xp
    Wrap-up
    50 xp

In the following tracks

Data Analyst in Power BIPower BI Fundamentals

Datasets

DataCamp vs. Local ExperienceExercises and DatasetsMetadata sheet

Collaborators

Collaborator's avatar
Azat Saskal
Collaborator's avatar
Carl Rosseel

Prerequisites

Introduction to DAX in Power BIData Visualization in Power BI
Iason Prassides HeadshotIason Prassides

Content Developer at DataCamp

Iason holds a Master’s degree in Chemistry from UCL and is now a Content Developer at DataCamp. He is also a certified Power BI data analyst. Prior to working at DataCamp, Iason held a number of analytics roles within a range of industries across different countries. Having a passion for education, data, and storytelling, he has found a great place at DataCamp to develop engaging content for learning. As an avid sports fan, he has a keen interest in sports statistics
See More

Don’t just take our word for it

*4.6
from 46 reviews
78%
13%
7%
2%
0%
Sort by
  • Fareed B.
    18 days

    I found the case study to be really nice and practical to see how everything we’ve learnt so far comes together to be meaningful for businesses

  • Bryan H.
    25 days

    z

  • Mamkon O.
    25 days

    I love the methodology and presentation

  • HAROON R.
    25 days

    Great

  • Marcin Z.
    about 1 month

    It is an eye opener, I had no idea how much information you can get from data. Everything is nicely explained and every excercise planned carefully

"I found the case study to be really nice and practical to see how everything we’ve learnt so far comes together to be meaningful for businesses"

Fareed B.

"z"

Bryan H.

"I love the methodology and presentation"

Mamkon O.

Join over 12 million learners and start Case Study: Analyzing Customer Churn in Power BI 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.