Alteryx Academy

The link to last week’s challenge (challenge #42) is HERE   As a follow on from last week’s challenge here is the second lap of the Inspire Europe Grand Prix.  Keep in mind that the participants only had 10 minutes to complete the race.  Fasten your seatbelt and give it a try. ... View more

The link to last week’s challenge (challenge #41) be HERE   Last week in bloody England Alteryx celebrated our European customers at Inspire Europe 2016. In th' tradition 'o th' US Inspire conference thar was a Grand Prix contention whar drivers were challenged to solve business problems usin' the mighty Alteryx tool. 'tis exercise be th' first lap in th' rivalry, recollect that th' peasants only had 10 minutes to answer th' 4 questions in th’ lap so ye may want to the be weary of th’ hour yourself.   Do ye have what it takes? Th' correct solution gunna earn ye some lovely booty:   T' upload yer solution - take a wee little screenshot an' don't be spoilin it fer th' rest of us scurvy pirates. Put it in a Spoiler Tag and give ye a hearty YARRR!   A solvin tactic has been posted - but we wanna see yer bloody pirate way! ... View more

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