Maveryx Academy

The link to the solution for last challenge #37 is HERE.   One of the powers of Alteryx is to be able to batch processes without the need to write scripts of use complicated code.   A single output tool can be configured to generate many output files.   Use Case:  A company needs to blend data from three sources and generate an output file for each product - region combination, a total of 15 output files.   Objective:  Create a cross join between the Product Group, Region Reference and Data tables to produce 15 unique CSV Data files.  Please note that only 1 output tool should be leveraged in your solution.   Thanks to all that are playing along! ... View more

With another Alteryx Inspire behind us, we wanted to share a workflow from a session in the Community Track: 'Born to Solve - Think Like an Alteryx Champion'   In this session, @patrick_digan presented a analytical challenge to @estherb47  sight-unseen!  The intent of the session was to show more than solving a problem, but show attendees how some of the top challenge leaders approach and think about problems. Would you like to try it yourself? See below!   THE CREW   Challenge Suppose you have 3 ordinary dice (6 sides with the numbers 1-6). You roll all 3 dice and compute the score like so: Multiply the largest number by the second largest number. Then add the remaining number. Given this unique method of scoring, which is the most likely score? ... View more

The link to last week’s exercise (exercise #45) is HERE   I love to share real world use cases as exercises.  This week’s exercise comes from a customer that had data coming from in a legacy system and needed to transform the date field for a new system.  It is a straightforward exercise but shows how easily Alteryx can apply business logic to most any data transformation problem.   Use case: The Input contains dates formatted as year, month and day. In this case, the first character determines if the year should begin with 19 or 20.   If the first character is 0 then the year starts with 19, and when the first character is 1 the year starts with 20.  The remainder of the date following the 0 or 1 is the remaining year digits followed by month followed by day.   Objective: Please convert these strings into date formatted field. ... View more

A solution to last week’s challenge can be found here.  Source: https://www.dailymail.co.uk/news/article-4965690/Humpback-whale-breaches-Sydney-Harbour-sunset.html   Every year whales around the world migrate from their feeding grounds to their breeding grounds. Some species travel an outstanding 12,000 miles round trip!   Use the data sets below to analyze migration movements for different whale species. The file Whale_Migration_Data contains a list of whales whose migration patterns have been tracked from 2001-2003, and the total kilometers each whale swam on each day of their migration. The file Whale_Pods contains a list of whale ids and pod ids, which indicates the pod each whale belongs to. The file Whale_Species contains information about the whale species of each pod.   Find the total number of kilometers each pod swam for migration for each year, then find the average number of kilometers each whale in that pod swam (total kilometers / number of whales in the pod). Then, find the pod with the highest average kilometers swam per whale for each species for each year. ... View more

A solution to last week’s challenge can be found here.   Congratulations, class of 2026!   For many new college students, now is the time to pay tuition for college, and sometimes their college decision is based on financial data. This dataset contains information about private and public colleges in the US, where these institutions often offer different tuition for  in-state and out-of-state students.   Using the provided data: - Create a list of 4-year colleges by state that includes the total payment (tuition plus room and board) in 2020 for private colleges and public colleges for in-state and out-of-state students. - Find the top 10 schools that give the most significant discounts for in-state students. ... View more