Alteryx Academy

Here at Alteryx we know the importance of growing our experience at solving data and business problems. Almost weekly (~40+ times a year) we share an Alteryx challenge with our internal Alteryx users and then we all develop our own solutions.  Later we review our solutions in small groups.  Since many Alteryx users have expressed an interest in having us share these exercises, we have created this new section of the Community. The intent is to share and exercise about once a week on Monday. Some of the exercises will be easy and some you will find more challenging.  The goal is to expose everyone to more of the things Alteryx can do and hopefully everyone will take away an idea or two on how to approach different challenges.  The following week we will post a new challenge as well as an example solution to the previous week's challenge.  We hope you enjoy the exercises. Exercise #1 Join to Range: A company in Australia has source data which is made up of a series of postal codes (eg. 2000, 2001, 2002 etc.) amongst some other data fields. They have a separate reference table which contains postcode ranges (eg. 2000 to 2002) which they would like to use to match/filter their main data. Each Customer Record needs to be joined to the Lookup table based on a Postal Area Ranged region. Then finally summarize the customer data by Region, Sales Rep, and Responder, then a count of customers.   Check and see what the result should look like by looking at the data labeled 'Output'.  Your mission is to take the input files and blend them so your result matches the output shown.  Good luck!   UPDATE 11/16/2015: I have posted a solution to challenge #1 from last week.  It is a good example to show the usefulness of the generate rows tool.  Please keep in mind that this is just one solution using Alteryx to solve the problem, there can be many other solutions and approaches to the problem.  Hopefully you had fun and learned something new in the process. ... View more

  Hello 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 this great challenge! Job hunting today takes a lot of time and effort. You are not only sifting through hundreds of job postings but also crafting tailored resumes, writing cover letters, following up with recruiters, and networking to land the perfect role. Once the offers start coming in, how do you decide which job is truly the best? Your challenge is to compare multiple job offers based on the costs you will have to commute to work. You have two datasets: Job Details Text Input: Job details from six companies you received offers from. Constants Text Input: Information about fuel prices, car maintenance costs, miles per gallon, and your home location.   Your tasks are the following:   Calculate your annual fuel cost and vehicle maintenance cost for each job. Consider the following for this calculation: Travel time to office Daily fuel cost Vehicle maintenance cost How many days you will be in the office   Calculate your annual travel time (coming to and from work).   Need a refresher? Review the following lessons in Academy to gear up: Diving Into Expressions Creating Spatial Objects   Good luck! The Academy Team   Download Start File   Download Solution File ... View more

  Hello Community members,   A solution to last week’s challenge can be found here.    This week’s challenge was submitted by Talia Sanders (@tsand22) . Thank you, Talia, for this great challenge!   In Part 1 of this challenge, you calculated the cost of school supplies for one child in each grade of elementary school (from kindergarten [K] to sixth grade).   In this week’s challenge, you will analyze data related to school enrollment by grade level in the state of Indiana, and use the cost of school supplies results from Part 1 to answer two questions: What is the total cost of school supplies for all students for each grade (kindergarten to grade 6)? To achieve this, calculate the total number of students in each grade, and then the total cost of school supplies by grade. What is the total cost of school supplies for all students in kindergarten to grade 6? Hints: Some schools serve multiple grade levels (for example, K to 8 or 5 to 12). Be sure to include any schools that have students in grades K to 6. Include all types of schools (traditional, private, charter, etc.). There are two datasets provided for this challenge: Enrollment Data Text Input: Data for school enrollment in the state of Indiana, such as school name, number of students in each grade, and total number of students in each school. Full Cost of School Supplies Text Input: Cost of school supplies for each grade (K to 6).   Need a refresher? Review the following lessons in Academy to gear up: Filtering Data Joining Data   Ready to take this challenge? Good luck!   The Academy Team   Download Start File   Download Solution File     Data Source: https://www.in.gov/doe/it/data-center-and-reports/ File: School Enrollment by Grade Level - (Updated - SY 2023-2024)   Update with challenge 472 link ... View more

  Hello Community members,   A solution to last week’s challenge can be found here.    This week’s challenge was submitted by Talia Sanders (@tsand22) . Thank you, Talia, for this incredible challenge!   Every year, parents and guardians need to purchase school supplies for their children at the beginning of the school year. This is a major cost that many families struggle to budget for.   In Part 1 of this challenge, your objective is to calculate the cost of school supplies for one child in each grade of elementary school (from kindergarten to sixth grade).   There are two datasets provided: School Supply List Text Input: A list of school supplies separated by grade. Cost of School Supplies Text Input: The cost of each unit from a list of school supplies.   Need a refresher? Review the following lessons in Academy to gear up: Changing Data Layouts Sorting Data   Ready? Good luck! The Academy Team   Download Start File   Download Solution File   Data Source: https://www.in.gov/doe/it/data-center-and-reports/ ... View more

  Hello Community members,   A solution to last week’s challenge can be found here.   This week’s challenge was submitted by Patrick Digan (@patrick_digan) . Thank you, Patrick, for submitting this great challenge!   In this challenge, you will explore an important part of the financial system: bank failures. Specifically, you will be working with data provided by the Federal Deposit InsuranceCorporation (FDIC) on the 569 banks that have failed from 2000 to August 2024. The FDIC was established in the 1930s to step in and help with bank failures.   The two datasets provided contain the following information: banklist.csv: A list of failed banks that includes information on the city and state where the bank was established, the certification number, whoacquired the failed bank, the closing date, and funds. institutions (select data).csv: A dataset with details on each bank’s establishment date (INSDATE) and certification number (CERT). Your task is to calculate the number of days from a bank’s establishment to the day it closed. Then, determine which bank failed in the shortest number of days between its establishment and closing.   Ready to uncover which bank had the shortest lifespan? Let’s get started.   Need a refresher? Review the following lessons in Academy to gear up: Joining Data Diving into Expressions Good luck!   The Academy Team   Download Start File   Download Solution File   Sources: https://www.fdic.gov/resources/resolutions/bank-failures/failed-bank-list/index.html https://banks.data.fdic.gov/docs/#/History/getHistory ... View more