Alteryx Academy

  Hi Maveryx,   A solution to last week’s challenge can be found here. This challenge comes to us from @AkimasaKajitani . Thank you for your contribution, Aki!   Meteorite showers are a captivating natural phenomenon, though it can be challenging to see them depending on your location. Fortunately, residents and visitors in the Las Vegas area enjoy an advantageous position, being in proximity to expansive desert skies that offer excellent conditions for meteorite watching.   For this challenge, your mission is to plan a budget-friendly meteorite impact site tour near Las Vegas, ensuring enthusiasts visit locations where they have the best opportunity to witness this celestial spectacle.   Here are the tasks you must complete. Calculate all distances in kilometers.   Find a meteorite impact site that is closest to a hotel that costs less than $200 per night. Designate this location as the "First Stop." Identify the nearest meteorite impact site in relation to the First Stop. Label this site as the "Second Stop" and determine the distance between the first and second stops. Locate the nearest meteorite impact site in relation to the Second Stop. Name this site “Third Stop” and determine the distance between the second and third stops. Calculate the total distance traveled from the hotel to the third stop. Data Summary: You have two datasets. The text dataset contains the latitude and longitude of some hotels in Las Vegas with their cost per night. The second dataset, meteorite-landings.csv, contains the latitude and longitude of over 45,000 meteorites that have struck our planet.   Source: https://www.kaggle.com/datasets/nasa/meteorite-landings ... View more

Aggregate Consumer Purchases: For this week’s exercise we will look at customer purchase behavior to decide if we should offer a “Meal Deal” that would add a side and drink to a purchase of pizza or a burger. The incoming data is larger than usual for these exercises so I have packaged the workflow as an Alteryx Package. The link to the solution for last challenge #7 is HERE.   This week’s Objective: In order to decide if we should start including a new "Meal Deal" on our menu we want to study the potential impact on recent transactions. Please identify the number and percentage of orders since July 1, 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.   Summary of Data: Point of Sale data includes the ticket level information, and the lookup table categorizes items into higher level food categories.   Hint: Don't forget to join to the lookup table and filter by date.   As always we look forward to your feedback and suggestions!   UPDATE 01/18/2016: The solution has been uploaded.   UPDATE 12/28/2016: The challenge, text and solution have been updated. ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by @AkimasaKajitani. Thank you, Aki, for your submission.   The Alteryx Community hosts localized User Groups across the globe. Have you ever wondered how many people participate in these groups, or how many active groups exist?   Each User Group page displays the group name, the number of leaders, the number of members, the URL, and the region. The dataset below was created by web scraping User Group pages between June 2023 and March 2025. You can explore it here: Alteryx Community User Groups.   For this challenge, use the two datasets provided to complete the following tasks:   Calculate the total number of User Groups, the total number of members, and the percentage increase in membership between June 2023 and March 2025. Identify the top five User Groups with the largest increase in members.   Notes: Task 2 applies only to User Groups that exist as of March 29, 2025. Some User Groups may have changed names during the data period. Use the Change history dataset to align names correctly. Round all calculation results to two decimal places.   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: https://community.alteryx.com/t5/User-Groups/ct-p/usergroups  ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by our ACE Calvin Tang, @caltang . Thank you, Tang for your submission!   Organizations often deal with poorly formatted financial data stored in fixed-width flat files, which creates inconsistencies and makes analysis difficult. In this challenge, you will work on cleaning and standardizing transaction records containing account numbers, customer names, transaction types, and amounts. The goal is to improve data quality, enable efficient management, and support better financial decision-making.   Develop a workflow in Alteryx to:   Clean and format the data, then calculate the total for deposits and withdrawals. Use the Interactive Chart tool to create a graph that displays the total deposits and withdrawals.   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   Source: Dataset generated by AI (POE). ... 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