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 #396: Analyze the Ultimate Motorsport - Formula 1

AYXAcademy
Alteryx
Alteryx

 

 

Maveryx_WC_Banner.png

 

 

 

 

 

 

 

 

 

 

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

 

Are you a big fan of Formula 1? 

 

This challenge is an exciting part of the Alteryx Formula 1 Fanalytics event. 

 

Rev your engines and get ready to race to the finish. Your goal is to analyze driver lap time data and pinpoint the best driver in rainy conditions, making them the top choice for any wet race conditions.

 

 

AYX_FAN-F1_paid-social-B_1200x628 (1).jpg

Bonus: Tune in to a recording of the “Alteryx + McLaren: Formula To Success with AI & Analytics” webinar to hear from McLaren Racing CEO, Zak Brown, and Alteryx CIO Trevor Schulze on how McLaren and Alteryx ride the data wave using AI and analytics to conquer change. 

 

Source: All data provided for this challenge is entirely fictional.

benjimoser
9 - Comet

My Solution

Spoiler
 
Screenshot 2023-11-06 150404.png
MatthewGrant12
8 - Asteroid

solution

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached,

Spoiler
image.png
mmontgomery
11 - Bolide

Took a minute to understand what was being asked

Spoiler
Workflow_396.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution!

 

Designer Desktop

Spoiler
I made 2 solutions.The upper one in screenshot is my favorite solution.The lower solution is fit for the sample output.スクリーンショット 2023-11-06 233150.png



Designer Cloud(Designer Experience)

Spoiler
スクリーンショット 2023-11-06 233139.png

Trifacta Classic

Spoiler
スクリーンショット 2023-11-06 233204.png



スクリーンショット 2023-11-06 233228.png

 

rmassambane
10 - Fireball

396!

nSpire
8 - Asteroid
Spoiler
396.png
sp6116588
5 - Atom

Go Fanalytics!

sp6116588
5 - Atom

Updated solution 

 

Why would the "best driver in rainy conditions" not be the driver with the fastest time in rainy conditions??

 

If I drove 93 secs in sunny conditions and 93 secs in rainy conditions, my delta is 0. But I'm still the slowest... 

 

Anyways, go Fanalytics!