Alteryx Academy

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

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 Maveryx,   Thanks for submitting your solutions for our first official Cloud Quest! In the video solution we posted, Alteryx Chief Evangelist, Joshua Burkhow (@joshuaburkhow) will guide you through the workflow (scroll down the page to locate the video). Thank you, Josh, for the exceptional guidance!   For this week’s quest, you are taking on the role of a restaurant manager. You want to review customer purchase behavior to decide whether your restaurant should offer a meal deal that would add a side and drink to a pizza or burger purchase. To make this decision, you need to study recent transactions to determine the potential impact it could have.   The Point of Sale dataset includes the ticket-level information, and the two lookup tables categorize items into higher-level food types.   Your task is to determine the percentage of orders since July 1, 2013, that include the Food category (Pizza or Burger) paired with a Side AND Drink. To accomplish this, you need to determine the total number of orders placed within the specified timeframe and identify those that meet the criteria for the potential meal deal you are considering for your menu.   Hint 1: Remember to combine the dataset with the lookup tables and filter by date. Hint 2: Remember to account for dates after June 30, 2013 to include July 1, 2013 in the output.   Your final result should look like the following image:                   Hint: A combination of Join, Filter, Summarize, Cross Tab, Append Columns, and Summarize tools should solve your problem, not necessarily in this sequence.   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 Connections 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   We want to hear from you! As we introduce our Cloud Quests for the first time, we value your input. Share your thoughts on the clarity of instructions, the provided dataset, the expected output, and any suggestions to enhance your experience.   Thank you!   ... View more