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...
Here is the new weekly challenge. The link to the solution for last challenge is HERE. For this challenge let’s look at ranking records when multiple records can have the same rank. The objective is to determine the top 5 ranking based on the count, however since there are multiple rows with same count (similar to a round of golf) multiple people can be in the same place (Rank) if they have the same score.
We have listed this as a beginner challenge and I expect it will go very quickly for many of you. Let us know what you think, we are looking forward to hearing your feedback.
UPDATE 1/25/2016
The solution has been uploaded.
... View more
A solution to last week's challenge can be found here!
Nothing makes you feel quite as nostalgic as hearing a song you haven't heard in a while. That's probably why Billboard magazine has been publishing their "Hot 100" list since 1958. If you aren't familiar, the "Hot 100" list ranks the top 100 singles in the US each year. It can be pretty fun to read through, but let's take a look at who dominated the decades.
This challenge's dataset includes rankings from 1965-2015. Determine which artist(s) created the most top 100 hits in each decade. Then, try the same but with top 10 rankings.
... 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
A solution to last week's challenge can be found here.
Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.
In the UK, National Fish and Chip Day is celebrated every year on the first Friday of June. This special day sees people across the country indulging in the iconic British dish, which is served in various establishments such as fish and chip shops, pub chains, restaurants, and retail outlets.
National Fish and Chip Day was established by the National Edible Oil Distributors’ Association (NEODA) in 2015. According to NEODA, British consumers devour a staggering 382 million portions of fish and chips annually.
For this challenge, we will use a dataset obtained from the UK's Department for Environment, Food & Rural Affairs. This dataset provides information on the average quantity of food and drink purchased by UK households per person, per week. Using the Major Food Code column, let’s determine the following:
The major food code containing fish with the highest per person, per week consumption rate since 2015.
The specific year, starting from 2015, that experienced the highest rate of fish consumption.
The major food code containing potatoes with the highest per person, per week consumption rate since 2015.
The specific year, starting from 2015, that experienced the highest rate of potato consumption.
Hints as you proceed:
Only use the Major Food Code column for the analysis.
If you come across a record that combines 2 years into a single record, for example 201516 or 2021-22, divide the value equally and generate a record for each year.
Note that traditional fish and chips in the UK do not include shellfish!
Source: https://www.gov.uk/government/statistical-data-sets/family-food-datasets
... View more
A solution to last week's challenge can be found here!
Tires: they smell bad and can be expensive, but we all need them. For being a basic piece of technology, they have a huge impact on arriving safely at your destination. For instance, the "contact patch" refers to the amount of a tire contacting the surface of the road. The size of a contact patch has a huge impact on stopping distance, traction, and even fuel economy. It's a similar story with tire height.
When looking for new tires, it can be useful to get information about a tire's width and height. Many sites have "tire calculators" which allow a user to enter a tire's size in a standard format and view more information on that tire. The standard format for tires is tire width in millimeters, a percentage of that width as the sidewall's height, and the radius of the rim in inches (e.g. 285/70/R17 is a 285mm wide tire, with a sidewall size of 199.5mm (285*.7), and fits on a 17" rim).
For this week's challenge, create a chained app to allow users to enter tire size information and view the additional information on file. Update the next field after the user makes a selection so that only existing options are available.
Your app interface should look similar to this:
Create a three-step app to find tires based on width, sidewall height, and rim radius.
... View more