Learn

A solution to last week's challenge can be found here. This dataset contains a list of holiday dates that are observed by each country from Feb. to Dec. 2020. Your Challenge is to figure out for that period: - Which country has the most holidays and how many? - Some holidays are only observed by one country. Which country has the most unique days off and how many? - Which day is the most shared in the world as a holiday and which countries are sharing this holiday? ... View more

    Hi Community,   We posted the solution JSON file to Cloud Quest #48. 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 JSON file containing your starting data and workflow files. Upload Start Cloud Quest 49.json file to your Alteryx One library. All necessary datasets are contained within Text Input tools in the 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: Happy Holidays! 🎄 This dataset contains the top 40 most populous countries and a list of federal / national holidays observed by each in 2025. Practice your parsing and data cleansing skills to answer the following questions:   1. Which country observes the highest number of federal holidays in 2025, and how many does it have? 2. "Unique holidays" are dates where only one country in this list has a day off. Which country has the most of these exclusive holidays, and what is that count? 3. On which specific date do the most countries in this list share a holiday? List the date and the names of the sharing countries.   Hint: While the holidays and dates are separated by clear delimiters, use the Tokenize method within the RegEx tool to split them into rows for an added parsing challenge. Dataset: Generated by Google Gemini, Dec 23, 2025, google.gemini.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       ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Erin Miller. Thank you, @Erin , for another great challenge!   According to Erin, someone who wins at Mario Kart seems to know every shortcut and trick, and it’s easy to assume they’re always choosing the perfect character and kart combo. But not anymore! We now have access to in-game data for every driver, kart/body, tire, and glider in Mario Kart 8 Deluxe.   Using the datasets provided, the mission is to identify the most optimal combinations that deliver the best overall racing performance.   What You Need to Do Compute the average value for each stat category (speed, acceleration, handling, etc.) across each individual dimension: driver, kart/body, tire, and glider. Determine the average stat values for every combination of driver, kart/body, tire, and glider. For example: What is the average speed for a specific driver when paired with a given kart, tire, and glider? For each combination, calculate a total weighted average using the provided weights table (or create your own!) to reflect the relative importance of each stat.   The final output should include each driver–kart–tire–glider combination, the corresponding average stat values, and a total weighted score.   Feeling a Little “Extra”? Use a macro to automate repetitive tasks (such as calculating averages).   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: https://www.kaggle.com/datasets/marlowspringmeier/mario-kart-8-deluxe-ingame-statistics   Download Start File   ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by Griffin Welsh, @griffinwelsh. Thank you, Griffin, for your submission, and for making our Halloween even more fun!   Halloween is just around the corner, and you have been tasked with creating the scariest possible haunted house for your accounting department. You have received survey results showing each employee’s fear and corresponding fear intensity.   However, not everyone filled out the survey correctly.   Your goal is to determine the scariest haunted house feature, measured by the total sum of fear intensity from all respondents. For respondents who listed a fear but did not provide an intensity, use the median intensity from other respondents who reported the same fear. Ignore any respondents who did not list a fear in their response.   Bonus Task Was the first challenge not scary enough for you? You have now been given a budget of $1,700 to build your haunted house. Your goal is to find the combination of features that maximizes the total fear intensity while staying within budget. Each feature can only be used once.   Using your results, create a short proposal paragraph describing your recommendations based on the data.   Once you’ve completed the 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 Microsoft copilot.   Download Start File Download Solution File  ... View more

The solution to last week's challenge is HERE.   This week we will be offering our third ever challenge on converting strings to dates. Sometimes these may be simple, but every once in awhile, we come across those source systems that drop things in a format that are better understood by machine than by a human. In this week's challenge, convert the string to a date using the following rules:   1) The Input contains dates formatted as year, month, day where the first character details if the year begins with 19 or 20. 2) It is 19 when the first character is 0 and 20 when the character is 1. 3) The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.   Example: 1040202 should become 2004-02-02.   ... View more