Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #452: Predicting Customer Churn

AYXAcademy
Alteryx
Alteryx

Weekly Challenge LMS Banner.png

Hello Community Members!

 

A solution to last week’s challenge can be found here.

 

Who is up for a predictive challenge? With Black Friday just around the corner, it is the perfect time to put your predictive skills to the test. This week, take on the task of predicting how many customers are likely to switch their telecommunications provider, also known as churning.

 

This challenge, submitted by Ollie Clarke (@OllieClarke), is designed to take your abilities with the Designer Predictive palette to the next level.

 

You have a training dataset (Training Data.yxdb) containing information about a telecommunication company’s customers and whether they have churned. You also have a testing dataset (Testing Data.yxdb) with information about new customers. Your task is to predict how many of the new customers from the testing dataset are likely to churn from the company.

 

Just follow the steps and you will be able to tackle this challenge, even if it is your first time building a predictive model!

 

Here is how to get started:

  • Split the Training Data: Divide the training data into two samples with a seed number of 1: Estimation (70%) and Validation (30%).
  • Build Four Models: Using the Estimation output, create four models—Boosted Model, Decision Tree, Forest Model, and Logistic Regression. Use their default configurations to predict churn, using all variables (columns) except for ID.
  • Compare Models: Use the Validation output to compare the models and identify the one with the highest F1 score. (Use the E anchor from the Model Comparison tool to identify the highest F1 score.)
  • Score the Testing Data: Rerun the entire training dataset through the best model, then score the testing data to calculate the likelihood of churn (Score_yes > 0.5). Count how many customers in the testing dataset are likely to churn.

Need a refresher? Review the following lessons in Academy to gear up:

Happy solving!

Source: https://kaggle.com/competitions/customer-churn-prediction-2020

 

The Academy Team

mmontgomery
11 - Bolide
11 - Bolide

C452

Spoiler
c452.png
balajilolla2
9 - Comet
Spoiler
Solution Attached

Screenshot 2024-11-25 083717.jpg
Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
W452.jpg
peter_gb
10 - Fireball

Always good to practice the predictive tools, I forget that they don't have to be complicated!

 

Spoiler
Challenge_452_pgb.png

 

OllieClarke
15 - Aurora
15 - Aurora

I think I submitted this challenge for the Grand Prix try outs, nice to see it get a slightly wider audience 😁

 

Spoiler
image.png
Jeff_Neklason
8 - Asteroid
8 - Asteroid

Fun one Ollie! Thank you!

Spoiler
452_Capture.JPG

 Also - A shoutout to Ben for his attention  to detail! 

Hub119
11 - Bolide
11 - Bolide

Solution attached.

Spoiler
C452 Pic.png
BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

It's amazing how fast you can be up and running with building predictive models! Really enjoyed this challenge.

Spoiler
Screenshot 2024-11-25 173302.png



All the best,
BS

LinkedIN

Bulien