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.