Alteryx Academy

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by John Primeaux (@jeprime) . Thank you, John, for your submission!   This week, you’re stepping into the role of a data quality detective. A data table has been populated with critical tracking codes—but many of them have been entered incorrectly.   Each code is supposed to follow a very specific structure. This format is vital because these codes are used to locate corresponding documentation within a larger database. Your mission: clean them up and restore order.   The required format is 1 to 4 alpha characters, a hyphen, 3 digits, a hyphen, 2 digits, then one optional alpha character.   The numeric portions (3-digit and 2-digit groups) are always generated correctly by the system. However, delimiters (- vs. _) may be missing or incorrect.   Hint: Assume that the three digits and two digits inside the code are created by a computer; therefore, the hyphen is never missing.   Task 1: Create the code in the correct format (using only hyphens "-"), including the optional letter suffix, and compare it to the old code.   Task 2: Calculate the percentage of codes with a letter suffix, as well as the percentage of codes that are missing or contain incorrect delimiters.   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   Download Start File | Download Solution File   Source: Dataset generated by challenge creator. ... View more

  This challenge comes to us from @Kenda . Thank you for your contribution, Kenda! Use Designer Desktop or Designer Cloud, Trifacta Classic to solve this week's challenge. Imagine you work as a data analyst for a company that develops video games. They want to create a strategy to increase profitability. The company has asked you to use industry sales data to determine whether the number of new video games released by a company impacts its profit for that year. You have a dataset (video_game_data.csv) that contains historical sales data of video games by multiple publishers around the world across several platforms. Your challenge is to do the following: • Determine the years when the same video game publisher released the most game titles (based on the exact value in the Name column) AND had the most sales globally (a value you need to calculate).     Source: https://www.kaggle.com/datasets/gregorut/videogamesales ... 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 Download Solution File  ... View more

Hi Maveryx,   We posted the solution JSON file to Cloud Quest #4. 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 start file and upload it into your Analytics Cloud library. For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article  Cloud Quest Submission Process Update.   Scenario:   Understanding client feedback has been critical for companies to improve their products and services. In your role as a data analyst, you are assigned the task of analyzing client feedback to measure their satisfaction and enhance the quality of services at your company.   For this task, you will need to manually connect the two provided datasets:   Clients_dataset.csv: Contains information about each client, including their Client ID. Requests_dataset.csv: Includes each client's Request Number (identical to the Client ID), Status (indicates whether the request has been processed), Status2 (provides a comment), and Professional (the name of the client). Your tasks are:   Count the number of clients (Professional) with a Status of Evaluated who left comments of Below Expectations, Exceeded Expectations, or Met Expectations in the Status2 field. Identify the three clients (Professional) who provided the highest average ratings. The ratings are on a scale of 1 to 5 where 5 is the highest.   Hint 1: Client and Professional are distinct fields. The Client field displays the Company Name, while the Professional field shows the individual client's name. Hint 2: Start by filtering the data at the beginning to only include entries where Status = Evaluated. Hint 3: Remember to combine the dataset using Client ID and RequestNumber as the key fields.   A combination of the Join, Filter, Summarize, and Sample tools should solve your problem, but not necessarily in this sequence. If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance: Getting Started with Designer Cloud Building Connections in Designer Cloud Building Your Workflow in Designer Cloud   Once you have completed your quest, go back to your Analytics Cloud library. Download your workflow solution file as a JSON file. You can also capture a screenshot of your finalized workflow in Designer Cloud. Include your JSON file and workflow screenshot as attachments to your comment on this post.   Here’s to a successful quest!     ... View more

Happy New Year, Community Members!   A big thank you to Erin Miller (@Erin)  for this special submission. Erin, you've contributed so many fantastic challenges throughout 2025, and it’s only fitting that Challenge #500 comes from you. We truly appreciate your creativity and dedication. Thank you again!   A solution to last week’s challenge can be found here.   It’s 2026: time for resolutions, fresh routines, and rethinking your media diet.   Your friend has been deep into true crime podcasts, so deep, in fact, that their spouse is starting to give them some serious side-eye. It’s clearly time for a change: something lighter, brighter, or just totally different.   Luckily, you’ve come across a daily dataset of Spotify’s Top 200 Podcast Episodes, complete with detailed show and episode info from the Spotify API. What better way to kick off the new year than with a chained analytic app to help your friend discover their next podcast obsession?   Your 2026 Podcast Discovery App – Let’s Build It!   Create a chained app experience where each selection refines the next. The app should include the following filters:   App 1 – Filter by Region App 2 – Filter by Language (Feeling a little extra? Let the user select multiple languages!) App 3 – Filter by Average Podcast Duration (Really feeling extra? Group durations into 15-minute intervals for a smooth user experience!)   After all filters have been applied, calculate the average show rank and identify the top-ranked episode for each show. The final result should include a summary of the selected filters and a table displaying the top 10 shows by average rank, along with the show description, average show duration, publisher, highest-ranked episode, and episode description.   Did you know that Alteryx has a podcast within the Alteryx Community? Check out the Alter Everything Podcast here: https://community.alteryx.com/t5/Alter-Everything-Podcast/Alter-Everything-Podcast-Episode-Guide/ba-p/450065    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/daniilmiheev/top-spotify-podcasts-daily-updated    Download Start File ... View more