Alteryx Academy

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

A solution to last week's challenge can be found here!    Using the data provided in the start file, create an ordered list of the provided unofficial holidays.       GIPHY  Get ready for Answer the Phone like Buddy the Elf Day on December 18!  ... View more

A solution to last week's challenge can be found here.  Source: https://blogs.cdc.gov/publichealthmatters/2020/05/pet-week/   This week's challenge takes a look at pet ownership in the United States, specifically ownership of dogs and cats. There are two input files this week, one containing information on pet ownership in the US and the other containing states as shapefiles.   Use these input data files to create a pdf containing: 1) a thematic map displaying the density of pet ownership by state and 2) a bar chart for the 10 states with the highest percentage of households with pets (including the percentage of cat and dog owners for those states). ... View more

A solution to last week's challenge can be found here.  Source: https://en.wikipedia.org/wiki/Goaltender_mask   This Friday will be another Friday the 13th. Whether or not you consider yourself to be superstitious, odds are you're familiar with this dreaded calendar configuration.   But just how common are these occurrences? For this week's challenge, construct a workflow that provides a count of the number of Friday the 13ths for each year since 1900.   Bonus: Are there any years that don't have a Friday the 13th? ... View more

  Hello Community Members, A solution to last week’s challenge can be found here.    This challenge was submitted by Yash Thakkar. We appreciate your contribution @yash_thakkar!    Some months mark pivotal moments for students and job seekers worldwide, especially when exploring the H-1B job market. The H-1B visa program allows US employers to temporarily hire foreign workers in specialty occupations requiring a combination of highly specialized knowledge and a bachelor's degree or higher in a relevant field, or its equivalent.   The dataset provided includes fiscal year 2024 data on employers who have submitted petitions to employ H-1B workers.   Your tasks are: Identify the top 10 companies that submitted the most H-1B petitions in 2024. Determine the top 10 industries with the highest demand (number of total petitions submitted) for H-1B workers in 2024. Hints: Exclude companies with missing industry data (Industry (NAICS) Code). Focus only on approved petitions as follows: Initial Approval (first-time H-1B employment) Continuing Approval (extensions or changes for existing H-1B employees) Happy solving!   Sources: https://www.uscis.gov/tools/reports-and-studies/h-1b-employer-data-hub https://www.uscis.gov/tools/reports-and-studies/h-1b-employer-data-hub/understanding-our-h-1b-employer-data-hub   The Academy Team ... View more