Challenge #170: 2019 Grand Prix US - Heat 1

A solution to last week's challenge can be found here!

This week's challenge will look familiar for those that attended Inspire this year. And for those that competed or were pit crew, you'll know this one well.

For those that have never attended Inspire, we have a contest among the fastest Alteryx users on stage in front of the entire Inspire audience. This year, roughly 5000 attendees watched as the 5 finalists competed to solve each Heat.

Although you won't have the aid of a pit crew to help you along the way, feel free to time yourself as you try complete this workflow. Give yourself about 2-3 minutes to read and understand the question, then start the clock. At the 11-minute mark, you may open up the tool contained named "Turbo Boost" which will reveal roughly 75% of a completed solution. Use this however you want.

For those that plan to attend Inspire Europe, keep your eyes peeled on the Analytics Blog to register for the Grand Prix Europe!

17-f2t-20190613_170525_olivia_y_rycoM0inspireRYC05601.jpg

Data.zip

FINAL_Heat1_question_Weekly Challenge.yxmd

Join

Preparation

Intermediate

Transform

Predictive

Accepted answers

All comments

NicoleJohnson

I fear I cannot adequately express my love for the Grand Prix, and for solving these problems within ridiculous time limits. (Spoiler: THE LOVE IS DEEP.)

Spoiler

But my favorite graphic is this one - 8 minutes, baby!!! 🙂

Huge props to all 5 contestants at the GP this year!!

Cheers,

challenge_170_NicoleJohnson.yxmd

wdavis

Managed to complete the challenge, having seen some other solutions I think I could have made my life a bit easier! I wasted a bit of time when adding the (now apparently unnecessary) 0 to the empty sessions as type Double so my average figure for those years was slightly different due to the precision. Taken me about 16 minutes to complete

Spoiler

170 Heat 1.yxmd

Adam_Dooley

Messy but it gets there.

challenge_170-AdamDooley.yxmd

RolandSchubert

My solution

Spoiler

FINAL_Heat1_question_Weekly Challenge_solution_rsc.yxmd

patrick_digan

Spoiler

Just like @Kenda did on stage, my natural instinct is to join the data back as opposed to filling the gaps using the multi-row tool. It takes longer to build unfortunately.

FINAL_Heat1_question_Weekly Challenge.yxmd

echuong

Thought I'd remember the answer from the Grand Prix, but I had to think through this one! Great challenge

FINAL_Heat1_question_Weekly Challenge.yxmd

bnelly1987

It was a lot of fun watching this happen at #Inspire19

Spoiler

FINAL_Heat1_question_Weekly Challenge_170.yxzp

JORGE4900

I wonder why they decided to use a ETS model to predict the quantity of participants, since the data looks like a linear regression. To be honest, I would have used a linear regression, since the data does not seem to have big seasonal up or downs because it is summarized by year.

Spoiler

FINAL_Heat1_question_Weekly_Challenge_Jorge_Solution.yxmd

adley31

Spoiler

FINAL_Heat1_question_Weekly Challenge_AA.yxmd

philipmannering

@echuong I definitely can't remember the answer..

viveknshah

Spoiler

This was fun! I have never used ETS predictive before so was good to learn that component hence all those browse tools at the end. Took me 20 minutes because all the playing around.

170_FINAL_Heat1_question_Weekly Challenge_vivek_shah.yxmd

T_Willins

Spoiler

Goal (and not just to watch):

Challenge_170_Solution.yxmd

Greg_Murray

This was a fun one! Took me a little bit longer than the folks on stage (but who's counting!?).

Spoiler

Challenge_170_solution GM.yxzp

neilgallen

Whew.

Spoiler

Unfortunately I had to leave inspire before the grand prix, so no clue how I would have fared.

FINAL_Heat1_question_Weekly Challenge._NGA Solution.yxmd

acastelazo

Finished in just under 11 minutes in the comfort of my desk. Can't imagine what it must have been like to be on stage in front of 5,000 slightly inebriated nerds! Respect!

Spoiler

FINAL_Heat1_question_acastelazo.yxmd

john_miller9

Solution is below:

Spoiler

challenge_170.yxmd

danilang

And a fine time was had by all!

Spoiler

There seems to an interesting split between those who chose to work with wide data, those enlightened individuals who worked with the long form data.

Not that I'm judging!

Dan

challenge_170_solution_DL.yxmd

David-Carnes

After failing the Expert exam due to time mismanagement I am hitting the weekly challenges as fast as I can go. This is not pretty but stream-of-consciousness got me to the end and the correct answer on my first try. Also, I plan on putting a comment in on every challenge to record my time, no matter how ugly.

Spoiler

Now that I've looked at other entries I see that using a stopwatch on one's phone is a great way to get an accurate measure. I went from file creation time to time of the run and rounded up to the next whole minute.

David-Carnes_170.yxmd

phottovy

Pleasantly surprised that my solution is similar to some of the already posted solutions!

Spoiler

challenge_170_PH_Solution.yxmd

RichoBsJ

Nice challenge, it took me 11 minutes!

FINAL_Heat1_question_Weekly Challenge_richobsj.yxmd

DataG8

I wouldn't have made it through this heat. Rarely do I use Time Series tools. Much respect to the Grand Prix drivers. @Garrett this was way more challenging than you made it look.

Spoiler

challenge_170_DataG8.yxmd

mpennington

Solution attached, although I watched this live and they walked through the solution. Still much slower than the awesome competitors.

Spoiler

Weekly Challenge 170 MP.yxmd

cplewis90

I feel like it is a bit cheating that I did this on stage, so my timing was definitely quick. I did not time myself though. One of my favorite moments at the conference!

Spoiler

challenge_170_CL.yxmd

grazitti_sapna

Solution.

Challenge_170_solution.yxzp

jasperlch

FINAL_Heat1_question_JL.yxmd

George_Walker

Spoiler

Won't be beating Phill Mannering any time soon, but I got it in about 10 mins

FINAL_Heat1_question_Weekly Challenge.yxzp

JungKim

Spoiler

FINAL_Heat1_question_Weekly Challenge.yxmd

Ladarthure

Fun challenge!

FINAL_Heat1_question_Weekly Challenge.yxmd

CPAul

Spoiler

FINAL_Heat1_question_Weekly Challenge_PTM.yxmd

JSNelson08

I had some trouble with the ETS tool on this because i've never used that before (and i'm using 11.5, so the output didn't seem very intuitive to me). I got to that point at around the 9 minute mark, so i'm pretty happy with myself, and I think the results are right in line with expectations:

Spoiler

challenge_170_solution_jln.yxmd

estherb47

Fun!!!

Spoiler

Made the most sense to me to crosstab to determine the nulls for each session, and then 2 multi-row formula tools to impute the average for the null values. A formula tool to summarize by year, then ETS, and then TS Forecast.

Easy peasy when there's not an audience of thousands watching 🙂

FINAL_Heat1_question_Weekly Challenge.yxmd

NickC

🙂

FINAL_Heat1_question_Weekly Challenge_completed.yxmd

SaiKrishna2589

you cant use regression models on time series data. the regression models dont allow for temporal component

alacoume

my solution:

challenge_170_start_file.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703