Learn

A solution to last week’s challenge can be found here. image source: https://en.wikipedia.org/wiki/States_of_Brazil   Did you know that Brazil is the largest country in South America? “Super legal!” you say to yourself em Português. Brazil is also an incredibly diverse country with many unique geographic regions. That’s why it’s a good idea to bring a map.   Unfortunately, the map I found is from 1920 and doesn’t show all 27 states (26 and the Federal District). Your task is to use the supplied data to update the map from the 22 existing states to include all 27.   Additionally, the capital moved from Rio de Janeiro to Brasilia in 1960, so the updated state of Rio de Janeiro should regain the land occupied by the Federal District in the 1920 map.   Boa Sorte! ... View more

Hi Maveryx,   Welcome to your very first Cloud Quest! This initiative is a thrilling journey into the world of the Alteryx Analytics Cloud, and we are kicking things off with a focus on Alteryx Designer Cloud. These new quests are not only tests of your skills but also opportunities to delve deeper into the practical uses of Designer Cloud in handling real-world data issues.   In the world of data processing, text files often include quotes, which are commonly used to manage strings. This can pose a unique challenge for extract, transform, and load (ETL) programs due to the presence of multiple character types.   In this quest, you have a CSV file containing two rows of concatenated data that include double quotes, single quotes, and commas, which enclose different data types. Use Designer Cloud to separate the data into three different columns: Poem, Poem ID, and Poem Read Date. Refer to the image below to see how your solution should look.       Hint: A combination of Formula, Text to Columns, and Select tools should be suffice to solve your problem! If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance: Getting Started with Designer Cloud Building Connection in Designer Cloud Building Your Workflow in Designer Cloud   Once you have completed this quest, capture a screenshot of your finalized workflow in Designer Cloud and attach the image of your solution to a comment on this post.   Here’s to a successful quest!   SOLUTION   ... View more

  Hi Community,   We posted the solution JSON file to Cloud Quest #40. 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 41.json to your Analytics Cloud library. Reconnect BreedAttributes.csv to the Input Data tool in your starting working 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: You manage a local dog shelter, and today you’re working with a first-time dog owner who wants to adopt their very first pet! They’re excited but uncertain about which furry friend will be the best fit for their lifestyle.   The adopter is looking for a small dog that can adapt well to apartment living, does not bark excessively, is friendly with strangers, and is a good match for novice owners.   Your challenge is to guide them in making the right choice by recommending the top three dog breeds based on these criteria. The provided datasets contain all the information you need, with each criterion ranked from 1 (low/not good) to 5 (high/excellent).     Hint:  Keep in mind which attributes should be scored low and which should be scored high. Data source: https://www.kaggle.com/datasets/yonkotoshiro/dogs-breeds?select=dogs.csv Image generated by ChatGPT, August 18, 2025, OpenAI.     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,   We posted the solution JSON file to Cloud Quest #39. 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 40.json file to your Analytics Cloud 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: A local arcade recently introduced a new virtual reality (VR) experience and surveyed users last week to assess headset performance. They want to analyze the results to determine which headset brand received the highest ratings, as they plan to purchase more of those models.   The arcade uses three VR headset brands: HTC Vive, PlayStation VR, and Oculus Rift. Analyze results for each brand, grouping users by ages 18–28, 29–39, 40–50, and  51+. The dataset includes each user’s Duration (minutes spent in VR) and Motion Sickness Rating (1–10, with higher values indicating more discomfort)     Ideally, users feel little motion sickness regardless of how long they use the headsets. Use the following Fun Score formula to assess the balance between duration and discomfort:   Fun Score = (Motion Sickness ÷ 60) × Duration   Using this formula, identify the brands and age groups where more than 20 users had a Fun Score less than 1, which the arcade considers LIFE CHANGING!   Fun Score scale:   9+ Refund 8+ Really sick 7+ Sick 6+ Dizzy 5+ Feeling weird 4+ Pretty good 3+ Fun 2+ Great! 1+ AMAZING <1 LIFE CHANGING!   Hint: Create Age Group categories using IF, THEN, ELSEIF, THEN, ELSE, ENDIF syntax. Image generated by Google Gemini, July 31, 2025.     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

    Hi Community,   We posted the solution JSON file to Cloud Quest #38. 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 39.json file to your Analytics Cloud 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: On December 30, 2021, a powerful windstorm swept across parts of Colorado’s Front Range. This dataset provided by the U.S. National Weather Service captured maximum wind speeds recorded at various locations throughout that day.   Your task is to analyze the data and answer the following:   Identify the county and location with the overall highest recorded wind speed. Rank all counties by their average highest wind speed. Determine whether the average highest wind speeds occurred before noon or after noon.   Hint:  Begin by parsing the provided input into separate columns up to the time component in the string. The RegEx character group [[:punct:]] can be used to identify and remove all punctuation from a string. Data Source: US National Weather Service Image generated by Google Gemeni, July 22, 2025, OpenAI, https://gemeni.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