Alteryx Academy

This week we are going to take a little breather before we dive into some SANTALYTICS next week. Just to get a little warm up going we are going to generate some secret Santa pairings (thanks to @Carlithian for the Challenge idea)! For our beginning users, try to generate pairs of people so nobody is picked twice or picks themselves! For a little more spice, we added the field 'scroogieness', which is certainly a word I didn't just make up just now. OK - it's more of a reflection of the character crabby and miserly 'Scrooge' in a Christmas Carol pre-visitation of three-spirits. The higher the 'scroogieness' is on a scale of 1-10 the more curmudgeonly the person. Try to create unique pairings where 'net scroogieness' does not exceed 13.   ... 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

A solution to last week's Challenge can be found here!    A big thanks to those of you that joined us last week at Inspire for the Weekly Challenge session!  It was so much fun solving with you all!    This week, we're identifying the most popular baby names that were registered between the years of 1880 and 2017.  Given the provided dataset, determine the most popular names for Males and Females for each available year.  The column "Field_1" contains three concatenated values: the name, the associated gender (Male or Female) and the number of occurrences that the name appeared in birth records.   The column "FileName" contains the name of the file in which the record is found; the data was read in from a zip file that contained text files for each year (1880-2017) of records.      ... View more

Last week's solution can be found here!   This week's challenge is around assigning the right income tax rate to each salary. Your goal is to count the number of people associated with each tax rate.   How many feel at tax time.   In our starting workflow, you'll find three datasets: 1) A grid of 100 employees from 26 companies. Before everyone gets worried, yes, I randomly generate this salary data and it is not representative of the population! Do note that each salary has a 'I' or 'J" representing whether this salary will be filed jointly or individually 2) A list of the company names 3) A tax table with the income rates. Notice that there is not a range in the tax table. You must infer the range based on when the next tax rate starts.   Easy Path: 1) Solve this problem as is.   Hard Path: 1) Do not use: Join, Crosstab, Transpose, Multi-field Formula, or Multi-Row Formula ... View more

A solution to Challenge #137 has been posted HERE!   Aside from completing a Weekly Challenge, there's nothing more thrilling than World Series baseball!  This weeks' challenge asks you to analyze data on previous World Series match-ups.  Use the provided data to determine each team's number of World Series appearances, list the years in which each team won the World Series, and calculate each team's winning percentage based on their World Series appearances.    The play by play...       ... View more