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!
This week's challenge was submitted by @kelly_gilbert - thank you for your contribution!
Challengers, get ready to have some fun with this one! And, with various levels of difficulty built into this challenge, there's something for everyone!
Your challenge this week is to build a Bingo Card! This challenge uses events/observations from a baseball game, but you can customize this input for anything from traditional numbers to things you might see at Thanksgiving Dinner. Enjoy!
Source: GIPHY
... View more
A solution to last week’s challenge can be found here. "Pumpkins Halloween 2013" by Mod Mischief is licensed under CC BY-SA 2.0
Pumpkins abound, and squirrels are happy. It’s that time of the year! Halloween is in just a few days, and you need to get candy for trick-or-treaters.
This Halloween dataset contains 85 types of candy. Take a closer look at the columns: - sugar percentage - The percentile of sugar it falls under within the data set. - price percentage - The unit price percentile compared to the rest of the set. - favorite percentage - The overall win percentage according to 269,000 matchups.
Your house is going to be a hit if your candy basket includes the following: - The 5 candies with the lowest “sugar percentage”. An average trick or treater consumes 7,000 calories worth of candy, so you want to offer some healthy options. - The 5 candies with the highest “favorite percentage”. Your neighbors know you are a people pleaser! - The 5 candies with the lowest “price percentage”. The giant tarantula inflatables you bought weren’t cheap, so you need to save some money on the treats.
And no peanut or almond candies. The teal pumpkins at your front door communicate that your candy basked is allergy-friendly. (Did you know that’s a “thing”?)
Hint
Make sure to filter out all candies that are not allergy friendly first.
Among the 85 types of candy from the dataset, what are the 15 candies to have in your basket?
... View more
This solution to last week's challenge can be found HERE.
A website log tracks every click visitors are making on a particular link on the site in order to measure interest in the link.
However, web consumers are impatient and may click a link multiple times in short succession.
The goal of this exercise is to flag "duplicate clicks" that is defined as the event fire date happening within 30 seconds of the previous event fire date for the same user (IDFA) and device (DeviceID)
... View more
A solution to last week's challenge can be found here.
This challenge comes to us from our ACE @Kenda . Thank you for your contribution, Kenda!
Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.
Father's Day is an annual celebration in the United States, observed on the third Sunday of June. As a result, the exact date of this holiday varies each year, meaning it is not fixed to a specific calendar date.
This week, we are providing a dataset that includes only the year, and your challenge is to determine the exact date on which Father's Day occurs in each year.
Have fun with the challenge and happy Father's Day to all the dads solving this challenge!
... View more
A solution to last week's challenge can be found here.
This challenge was submitted by Alteryx ACE Esther Bezborodko @estherb47 . Thank you, Esther!
Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge.
This challenge is a variation on the New York Times Spelling Bee puzzle. For this challenge, we will use the same list of words we used in Challenge #356.
Although Merriam-Webster’s Dictionary defines a pangram as “a short sentence containing all 26 letters of the English alphabet,” for the purposes of the New York Times Spelling Bee, their Glossary defines a pangram as a word that uses seven unique letters and is worth seven extra points. We will use this definition as a guide for our challenge.
Your goal here is to find, within the list of words, the pangram with the highest point value and the individual letters that comprise that word. For that, you need to do the following:
Find all the words within the list with seven unique letters. It does not matter if the word uses a unique letter more than once; this letter will still be unique within the word. For example:
Alteryx has seven unique letters.
Statistically also has seven unique letters.
Once you find the words with seven unique letters, determine their point value. Each letter is worth one point. For a pangram, the point value is calculated by adding 7 to the value for the length of the word. For example, in ALTERYX, the total value is 14 points (7 [the word length] + 7 [pangram extra points]).
The result should look like this:
... View more