Alteryx Academy

The link to last week’s challenge (challenge #41) be HERE   Last week in bloody England Alteryx celebrated our European customers at Inspire Europe 2016. In th' tradition 'o th' US Inspire conference thar was a Grand Prix contention whar drivers were challenged to solve business problems usin' the mighty Alteryx tool. 'tis exercise be th' first lap in th' rivalry, recollect that th' peasants only had 10 minutes to answer th' 4 questions in th’ lap so ye may want to the be weary of th’ hour yourself.   Do ye have what it takes? Th' correct solution gunna earn ye some lovely booty:   T' upload yer solution - take a wee little screenshot an' don't be spoilin it fer th' rest of us scurvy pirates. Put it in a Spoiler Tag and give ye a hearty YARRR!   A solvin tactic has been posted - but we wanna see yer bloody pirate way! ... View more

I hope everyone is enjoying the Grand Prix series, last week’s (challenge #30) solution is posted HERE.   Here is the Scenario for this lap:  With Inspire being held in beautiful San Diego, I'm planning on taking Friday off and trying out some of the world class surfing! Since it is summer, and I'm definitely a novice, I'd like to visit the surf sites in San Diego County that are appropriate for beginners and summer surfing season. Luckily, I found some datasets on the internet that provide this information.   The objective is to:  Join the site characteristics to the site location data and identify the four locations that are appropriate for a beginner skill level surfing in the summer season.   *Remember to time yourself, contestants only had about tem minutes per lap. ... View more

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. ... View more

The link to last week’s challenge (challenge #28) is HERE   Hi everyone, what an awesome time we had at the Alteryx Inspire 2016 Conference in San Diego last week.  It was so nice to meet many of the Community members in person.  If you attended the conference and went to the Grand Prix event, this week’s challenge is the first of the four laps.  We will cover all of laps as weekly challenges in the next weeks.   See if you have what it takes to compete, keep in mind the contestants only had about 10 minutes per lap maximum so maybe time yourself.   Use Case:  You are the commissioner for your fantasy baseball team. You recently completed your draft and you want to run some simple statistics about each fantasy team.   You have 3 inputs 1) Fantasy pick summary from your draft 2) Hitter stats on all field players (whether selected in your draft or not) 3) Pitchers stats on all pitchers (whether selected in your draft or not)   Objective:  In order to run some stats on your draft, you first need to prep your data. Please combine all 3 files so that you have a single output that contains stats on each player drafted in your draft, ordered by "Overall_Pick."   Drivers start your engines! ... View more

A solution for last week's challenge has been posted here in both video and workflow forms!    This week's Challenge lets you get crafty!  Create an app to allow a user to search a list of craft canned beers by state of origin or beer style.  Configure the app's interface to utilize radio buttons to expose the selection elements for each selection option: a Text Box for searching by state, and a Drop-Down for beer styles.  Feel free to customize the app as you see fit!                ... View more