Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
A solution to last week's challenge can be found here!
The Tour de France is one of the most grueling competitions on the planet. Each year, incredibly fit athletes push the limits of human endurance to traverse some 3000+ kilometers (2000 miles) over about a three-week period ON A BIKE. Just finishing the race is an incredible achievement. But what do birds think about all this?
In this challenge, use Designer and data from the 2017 Tour de France to determine how long the race was, as the crow flies. That’s right, calculate how far the race would be for a bird flying all stages of the race.
This solution treated race days that started and ended in the same city as 0 km covered. Travel outside of racing was not included either (i.e. if the destination of one leg did not match the next leg’s origin, that distance was not included.
... View more
A solution to last week's challenge can be found here.
Using the values in the attached file "womens_world_cup_data.txt", determine which team won the most matches.
Go Team USA!
... View more
I'm not sure if you know it, but Alteryx isn't the only organization that puts on a Grand Prix. Turns out they are pretty common for something called Formula 1.
This week's challenge gears up for the 2019 Grand Prix by taking a look at race data from 1950-2018. In Formula 1, points are awarded to the top 10 drivers after each race. After all the races in the year, the driver with the most points is named champion. Drivers also represent their teams in the "Constructor's Championship". (Constructor = Team) Use the provided data to find the youngest and oldest ever champions, and what team they drove for during that season.
... View more
The solution to last week's Challenge can be found HERE!
Sometimes, Designer doesn't do what you want it to. Fortunately, it is endlessly extensible. This week's challenge will ease you into the world of the Alteryx SDKs - upon successful completion of the challenge, you will be an Alteryx Developer. You can do this - REALLY! For the purposes of this exercise, you have already extended Alteryx by creating a macro (Outlier.yxmc attached to this post). Eventually, you may want to further extend your new tool by leveraging open source Python functionality with the Python SDK. After you do that, you might want to make a fancy new interface with the HTML GUI SDK (see here for inspiration). But we're going to take baby steps, and will start by simply replicating the macro's UI using the HTML GUI SDK. Advanced Challenge: Do this on your own with nothing but Developer Community (happy one year anniversary!) and the documentation to guide you (this post is also very helpful). Basic Challenge: Place the Outlier folder contained within the attached zip file in your HTML plugins folder (e.g. C:\Program Files\Alteryx\bin\HtmlPlugins\ for an admin install). Restart Alteryx. You will now see the Outlier tool in the Data Investigation category. But the tool's interface is blank! Modify the Gui.html file to add the appropriate controls.
Hint below...
Add the following lines of code between the body tags:
<div class="widgetLabel">Z</div>
<ayx data-ui-props='{type:"NumericSpinner", widgetId:"z_spinner"}' data-item-props='{dataName:"z_spinner", dataType:"SimpleFloat"}'></ayx>
<div class="widgetLabel">Field to test</div>
<ayx data-ui-props='{type:"DropDown", widgetId:"field_dropDown"}' data-item-props='{dataName:"field_dropDown", dataType:"FieldSelector"}'></ayx>
... View more
The solution to last week's challenge is HERE!
This year at Inspire, our attendees’ ability to win games of chance will be tested – and not just because of the Las Vegas venue! The ability to obtain the hottest Alteryx swag will be decided by a round of Plinko at the Community hub. Can you use Alteryx to break down the probabilities of our board and ensure your odds are the best possible?
There are no start files to this week’s challenge - any workflow or app that assigns relative probabilities to the final outcomes of the board above will suffice!
Hints below:
Formulaic approach Reshaping approach
... View more