Calculating churn

It will be extremely useful to have a measure that calculates churn before deep-diving 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 indicating if the customer churned or not. You need to use that to calculate the churn rate.

We do not recommend doing so, but if you lost progress you can load the solution report of the previous exercise 1_1_data_check_solution.pbix from the Exercises folder.