I hope you all had fun with last week’s challenge, completing lap one form the Inspire 2016 Grand Prix event (challenge #29). The solution is posted HERE. Now that you have your data prepped it is time for Race 1 lap 2, you need to answer some questions so you will have content for your annual "Draft Recap" newsletter. Objective: Please use Alteryx to answer the following questions – * Who has the youngest team and what is the average age? * Which team has the best (lowest) average pitcher rank? * What is the Pearson correlation between 2015 Team Rank and Hitter Rank? * Please build a table containing the count of players on each fantasy team by position, the sum of home runs for the hitters by fantasy team, and sum of wins for the pitchers by fantasy team, ordered by 2015 team rank. *Keep in mind the contestants only had about 10 minutes per lap maximum so time yourself. challenge_30_start_file.yxmd challenge_30_solution.yxmd

Spoiler My Solution 30 Solution.yxmd 30 Solution.bmp

Did not finish in less than 10 mins. Did finish in less time than lap 1. little wins. challenge_30_bel.yxmd

Challenge #30: Alteryx '16 Grand Prix (Race 1, L2)

I hope you all had fun with last week’s challenge, completing lap one form the Inspire 2016 Grand Prix event (challenge #29). The solution is posted HERE.

Now that you have your data prepped it is time for Race 1 lap 2, you need to answer some questions so you will have content for your annual "Draft Recap" newsletter.

Objective: Please use Alteryx to answer the following questions –

Who has the youngest team and what is the average age?
Which team has the best (lowest) average pitcher rank?
What is the Pearson correlation between 2015 Team Rank and Hitter Rank?
Please build a table containing the count of players on each fantasy team by position, the sum of home runs for the hitters by fantasy team, and sum of wins for the pitchers by fantasy team, ordered by 2015 team rank.

*Keep in mind the contestants only had about 10 minutes per lap maximum so time yourself.

challenge_30_start_file.yxmd

challenge_30_solution.yxmd

Join

Preparation

Advanced

Data Analysis

Data Investigation

Transform

Basic

Accepted answers

All comments

jdunkerley79

Took about 6 mins this time

Spoiler

JohnJPS

Ouch - this would have been a big fat DNF for me, as I took well over 10 minutes.

Spoiler

TaraM

A solution has been posted above.

Spoiler

2016-06-27 14_24_20-Alteryx Designer x64 - Fantasy_Baseball_GP2016_Lap2_Solution.yxmd.png

SeanAdams

07:25. Lots of fun, thank you!

Failed the previous lap (as @JohnJPS said, my prev lap was a DNF)

challenge_30_SeanSolution.yxmd

NicoleJohnson

Solution! Didn't officially time, but should have been around 10 minutes as the cookies in the oven were baking for 12, and I finished before the timer went off.

Spoiler

challenge_30_NicoleJohnson.yxmd

estherb47

took about 5 minutes

Spoiler

challenge_30_EHB_solution.yxmd

estherb47

challenge_30_EHB_solution.yxmd

LordNeilLord

About 5 mins for this one, it would have been quicker but the instructions in the workflow were incorrect

Spoiler

challenge_30_LNL.yxmd

A_Twa

I did get an answer, but I missed the 10min cutoff - mainly because I failed to read all of the instructions and wasted a lot of time trying to determine which fields the Pearson correlation was applied to....

challenge_30_start_file_AJT.yxmd

nick_ceneviva

Solution attached

challenge_30_Ceneviva.yxmd

Laurap1228

Completed this in 8 min!

Spoiler

Good Challenge

I liked this one

Solution attached.

Spoiler

challenge_30_JL.yxmd

patrick_digan

Spoiler

challenge_30_start_file.yxmd

marcreid

Solution

Spoiler

challenge_30_MR.yxmd

Natasha

I got stuck at the correlation part as there were no clear instructions in the file itself and I didn't read the instructions here in the post...

Spoiler

challenge_30_Natasha.yxmd

JoshKushner

God these are so fun! I can't wait to do these in person at Inspire or in an online competition. Chess.com style

challenge_30_start_file.yxmd

luciebrett

Wasn't sure what Pearson was so had to check for help but that was actually the most straight-forward bit!

challenge_30_LB.yxmd

Waynemk

almost missed the wins and HR. always good to reread when submitting.

challenge_30_waynek.yxmd

samN

Quick and Easy

challenge_30.yxmd

ggruccio

I was a bit distracted watching football LOL so forgot to time it...but finished fairly quickly - around 10 minutes if I had to guess. Seems like some of the instructions contained in the post are missing from the actual workflow....

challenge_30_gg_finish.yxmd

philipmannering

Solution attached

Spoiler

challenge_30 - Grand Prix 2016 R1 L2.yxzp

SGolnik

I would have done great if I had even the slightest idea of what a Pearson correlation was! Googling that took me an extra 7 minutes.

challenge_30_mysolution.yxmd

LandonG

Solution attached.

challenge_30_start_file.yxmd

jasperlch

Solution attached.

challenge_30_JL.yxmd

msicak

Technically I would not get to this round, but I made this one with 15 secs to spare. Got a bit carried away with the table challenge, plus the actual questions missing from the start file

Spoiler

challenge_30_ME.yxmd

derekbelyea

Spoiler

challenge_30_JDB_AnalytixStudio.yxmd

blairmbailey

Solution attached! Took a bit longer than 10 mins - got a bit confused since the instructions in the workbook were incorrect/partial. Oh well - thanks!