Calculating churn
It will be extremely useful to have a measure that calculates churn before deepdiving into the analysis. There is a column called Churn Label
that indicates "Yes" or "No", but this column isn't the easiest to work with.
You'll convert this column to a binomial column that will contain a 1 or 0, indicating if the customer churned or not, and use that to calculate the churn rate.
We do not recommend doing so, but if you lost progress you can load the solution workbook of the previous exercise 1_1_datacheck_solution.twbx
from the Workbooks folder.
This exercise is part of the course
Case Study: Analyzing Customer Churn in Tableau
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
