Zooming out

Case Study: Analyzing Customer Churn in Tableau

Carl Rosseel

Curriculum Manager

The 5 analysis steps from the drag-and-drop exercise

data analysis flow

Case Study: Analyzing Customer Churn in Tableau

The 5 analysis steps from the drag-and-drop exercise

data analysis flow

Case Study: Analyzing Customer Churn in Tableau

Insights discovered so far

  1. The churn rate for Databel is ~27%
  2. ~45% of the reasons why customers churn is related to competitors
  3. The churn rate in California is abnormally high (>60%)

big idea.jpg

Case Study: Analyzing Customer Churn in Tableau

There are many things we don't know yet.

  • Immediately started analyzing, without designing a plan
  • Many columns (over 20 out of 29) are still unexplored

looking glass.jpg

Case Study: Analyzing Customer Churn in Tableau

The metadata sheet is your friend

Analysis Group Related column names
Demographics Age, Under 30, Senior, Gender, ..
Groups Group, Number of Customers in Group
International Intl Plan, Intl Active, Intl Calls, Intl Mins, Extra International Charges
Data Unlimited Data Plan, Avg Monthly GB Download, Extra Data Charges
Other Account Length, Contract Type, Payment Method

Metadata sheet

Case Study: Analyzing Customer Churn in Tableau

Let's analyze!

Case Study: Analyzing Customer Churn in Tableau

Preparing Video For Download...