Telco customer churn

This sample data module tracks a fictional telco company's customer churn based on various factors. T he churn column indicates whether the customer departed within the last month. Other columns include gender, dependents, monthly charges, and many with information about the types of services each customer has.

There is a calculated column that is named CLTV Category that creates a set of categories based on the range of values for CLTV:

case when ( CLTV ) <= 2500 then ('2000 - 2500')
when ( CLTV ) <= 3000 then ('2501-3000')
when ( CLTV ) <= 3500 then ('3001-3500')
when ( CLTV ) <= 4000 then ('3501-4000')
when ( CLTV ) <= 4500 then ('4001-4500')
when ( CLTV ) <= 5000 then ('4501-5000')
when ( CLTV ) <= 5500 then ('5001-5500')
when ( CLTV ) <= 6000 then ('5501-6000')
when ( CLTV ) <= 6500 then ('6001-6500')
else ('6501-7000')
end

There is a calculated column that is named Churn Score Category that creates a set of categories based on the range of values for Churn Score:

case when ( Churn_Score ) <= 10 then ('0-10')
when ( Churn_Score ) <= 20 then ('11-20')
when ( Churn_Score ) <= 30 then ('21-30')
when ( Churn_Score ) <= 40 then ('31-40')
when ( Churn_Score ) <= 50 then ('41-50')
when ( Churn_Score ) <= 60 then ('51-60')
when ( Churn_Score ) <= 70 then ('61-70')
when ( Churn_Score ) <= 80 then ('71-80')
when ( Churn_Score ) <= 90 then ('81-90')
else ('91-100')
end

There is a calculated column that is named %Churned that calculates the percentage of customers who left the company (for example, they have a Churn Value = 1):

_round ((aggregate ( Churn_Value)) / (aggregate(Count_))*100,1)

This sample is located here: Team content > Samples > By industry > Telecommunications > Data > Telco customer churn

The source data for this sample can be found here: Team content > Samples > Data > Source files > Telco

Telco_customer_churn_demographics.xlsx
Telco_customer_churn_location.xlsx
Telco_customer_churn_population.xlsx
Telco_customer_churn_services.xlsx
Telco_customer_churn_status.xlsx