Alteryx Academy

  Hi Community,   We posted the solution JSON file to Cloud Quest #46. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!     Let’s dive into this week's quest!   Download the provided ZIP file containing your starting data and workflow files. Upload Start Cloud Quest 47.json to your Alteryx One library. Reconnect Quest47Input.csv to the Input Data tool in your starting workflow.   For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process.         Scenario:   For this week’s Thanksgiving holiday themed Cloud Quest, you’ll take a look at what dishes people typically serve in different US regions.   The dataset contains information about the types of dishes served at Thanksgiving dinners in US households. The columns include type of protein, cranberry, gravy (yes/no), type of sides, pies, dessert, and the US region they are located in.   Task 1: Find the total number of food dishes (protein, cranberry, gravy, sides, pies, and dessert) served in each household. Task 2: Find the average number of dishes served for each US region. Task 3: Calculate what percentage of total pies comes from each region. Task 4: Determine the most popular combination of side dishes, and how many households are serving it.     Hint: You can use the Text to Columns tool to “pivot” concatenated values to rows Image: Generated by Google Gemini, Nov 24, 2025, https://gemini.google.com.   Earn Cloud Quest badges:   After completing your quest, head back to your Analytics Cloud library: Download your workflow solution file. In your reply, attach both your JSON solution file and a screenshot of your workflow. Keep submitting—every solution gets you closer to earning more Cloud Quest badges!   Here’s to a successful quest! - The Academy Team     Download Start File | Download Solution File     ... View more

With another Alteryx Inspire behind us, we wanted to share a workflow from a session in the Community Track: 'Born to Solve - Think Like an Alteryx Champion'   In this session, @patrick_digan presented a analytical challenge to @estherb47  sight-unseen!  The intent of the session was to show more than solving a problem, but show attendees how some of the top challenge leaders approach and think about problems. Would you like to try it yourself? See below!   THE CREW   Challenge Suppose you have 3 ordinary dice (6 sides with the numbers 1-6). You roll all 3 dice and compute the score like so: Multiply the largest number by the second largest number. Then add the remaining number. Given this unique method of scoring, which is the most likely score? ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Douglas Perez, @dougperez . Thank you, Douglas, for your submission!   A company recently hosted an internal Alteryx certification event to promote professional growth and upskilling across the organization. Each participant was assigned to a team, and throughout the event, employees earned various professional certifications.   Now that the event has concluded, it’s time to analyze the results and determine which team came out on top!   You’ve been provided with two datasets: A certifications dataset containing certification records, each with its status (Expires or Expired) and the date. A team mapping dataset linking each participant to their respective team.   Analyze the results and rank the teams based on the number of valid certifications earned by their members. Follow the rules below:   Only include certifications that are currently valid (status is Expires). Focus only on certifications with names that include Alteryx Designer or Server. Exclude any certifications that mention Cloud or Trifacta. Aggregate the results by team and rank them from highest to lowest based on the number of valid certifications.   Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Source: Dataset generated by ChatGPT.   Download Start File ... View more

The solution to last week's challenge can be found HERE.    Determine the items of clothing that have the highest average rating. In your analysis, include 1) only items of clothing that have at least 10 positive feedback reviews and 2) the five highest rated clothing items from each class.   The original data and its metadata can be found here.        ... View more

A solution to last week’s challenge can be found here.   The Eurovision Song contest or Eurovision is an annual song competition in Europe.    During a live show, contestants representing European countries, sing a song and receive points. The contestant with the most points wins. In 1974, the Swedish group ABBA became a household name in Europe by winning this contest with the song "Waterloo".   The dataset for this challenge provides information about the Eurovision from 1975 to 2019. The column “Edition” contains a date followed by one or two initials “f” or “fs”. For this challenge, use the values followed by “f”.   Use the dataset to: - Find out which country has won the contest from 1975 to 2019 - List by descending order the countries who have won the most time between these dates   Hint A country cannot give points to its representative. Make sure to take this rule into consideration. Mistakes happen in datasets. ... View more