Alteryx Academy

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

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 #8. 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!   Upload the provided Cloud Quest 9 - Start File.json file into your Analytics Cloud library. The necessary datasets are pre-populated in the Text Input tools.   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:   In this week’s quest, a general contractor needs your assistance assessing his business using date-time analysis.   Bob, who had been working as a home builder, decided to transition his business towards leasing construction equipment. Among other equipment, he has two cranes he has been leasing for a while. He wants to get a better idea how his crane leasing business has been going.   Create a workflow that will show how many days both of his cranes have been leased at the same time during the years 2016-2018, the only years where he has a full set of data for both cranes.   Hint: In Designer Desktop, the Generate Rows tool would be the most efficient way to tokenize records within a date range. Unfortunately, the Generate Rows tool is not yet available in Designer Cloud (coming soon in 2024!), but you can still solve this quest thinking outside the box with a cartesian join from the Append Columns tool.   A combination of the Summarize, Filter, Append Columns, Formula, 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. Include your JSON file and a screenshot of your workflow as attachments to your comment.   Here’s to a successful quest!   ... View more

  Welcome! It is time for the third Auto Insights Special Edition challenge!   We hope you had lots of fun discovering the features of this amazing tool and are ready to start taking your insights to the next level.   A solution to the Week 2 Auto Insights challenge can be found here.   A friendly reminder: To participate, you will need access to Alteryx Auto Insights (AAI), which is part of the Cloud Platform. If you do not have AAI already, you can take this opportunity to start a free Cloud Trial. Additionally, remember that you can access interactive lessons in Maveryx Academy for extra assistance.   In this final challenge, you work for HelpNow, a software company based in the USA and renowned for their excellent customer support. You are a call centre team lead for Team 4 and are about to conduct your monthly customer service agent performance reviews. You want to use Auto Insights to identify performance trends to help facilitate your coaching conversations with customer service agents.   To solve this, you will use the Call Centre Operation Analysis dataset, which contains the call centre data from HelpNow. In this dataset, each row represents the calls a customer service agent takes and has information about the agent, the brand the call is related to, call type, time of call, and team details. The date range of the data is May 31, 2020, to April 30, 2022.   Task: Create a Mission (KPI Deep Dive Report) using the preloaded Call Centre Operation Analysis dataset (available in the Datasets tab) using the Calls column as your Measure.   Answer the following questions for your team (Team 4): The teams have a monthly competition for the greatest number of calls taken. What is the total number of calls did Team 4 take? Which rank did Team 4 place in the competition that month? How did calls trend in April 2022 compared to March 2022 for Team 4? Which agent(s) on Team 4 contributed most to the overall trend? Which agent(s) on Team 4 had the largest increase in Average Handling Time? Which call type drove this increase? Going forward, you would like to monitor Team 4’s productivity on a monthly basis. How can you automate this so that you receive a report on the first of every month?   Solution: To share your solution, please upload your PowerPoint presentation to this post. Posting your solution to the challenge will count towards earning Weekly Challenge badges!   Enjoy solving this Auto Insights challenge!   Video Solution: ... View more

A solution to last week’s challenge can be found here.   To solve this week’s challenge, use Designer Desktop.   This challenge comes to us from @Pawel_Paleczny  Thank you for your contribution.   The FIFA World Cup is currently taking place in Qatar. Pavel would like to perform analyses on the event.   The first dataset contains information about the stadiums: stadium name, city, capacity, latitude, and longitude. The second dataset contains information about the events: match number, round, dates, location, which teams are playing, and the group or phase.   For this challenge: 1. Assuming that each match will have a full audience, find the top 10 teams that could have the largest audience in the group stage. 2. Find the three cities with the most World Cup matches. ... View more