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 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
A solution to last week’s challenge can be found here.
To solve this week’s challenge, use Designer Desktop, Designer Cloud Trifacta Classic and Designer Cloud Designer Experience.
We provided both a beginner and intermediate version of the challenge. It is up to you which one to solve!
A friend recently gifted you a LEGO® model kit; however, it did not come with the original packaging. You received the bricks and an ID number. Use the datasets provided to determine which LEGO model you are building.
Beginner Challenge:
Given the ID number 11148, determine which LEGO model you are building, the year it was released, the number of parts, and the LEGO collection it belongs to.
Intermediate Challenge (Desktop):
Create an app that allows users to enter an ID number to determine which LEGO model they are building, the year it was released, the number of parts, and the LEGO collection it belongs to. The results should be displayed in a table and output to a PDF file (as shown in the image below).
Data Source: https://www.kaggle.com/datasets/rtatman/lego-database?resource=download
... View more
A solution to last week’s challenge can be found here.
To solve this week’s challenge, use Designer Desktop or Designer Cloud Trifacta Classic.
According to the Harvard School of Public Health, tea and coffee are the two most consumed beverages on the planet after water. They are brimming with antioxidants and other biologically active substances that may benefit your health.
For this week's challenge, we will use a dataset containing information about the sales of coffee and tea in the USA for a 6-month period.
Based on the sales of each product, determine the following:
Which state is the biggest consumer of regular coffee?
Which state is the biggest consumer of decaf coffee?
What type of coffee drink is the most popular?
Which state is the biggest consumer of regular tea?
Which state is the biggest consumer of decaf tea?
What type of tea drink is the most popular?
Source: https://data.world/2918diy/coffee-chain
... View more
A solution to last week’s challenge can be found here.
calendar.png
This week's challenge can be solved using either Designer Desktop or Designer Cloud.
Almost any data project will include dates. Working with dates is a common task and is important for downstream tasks such as reporting. In this week's challenge, we are going to cover a common date manipulation that many will encounter.
In this scenario, we have a column of date data that is in the format of MM/dd/yyyy. We want to reformat that data to yyyyquarter. Your goal for this challenge is to convert the date format from MM/dd/yyyy to yyyyquarter. As an example, change 2/15/2023 to 2023Q1.
... View more