Learn

The solution to last week's challenge can be found HERE.    Determine the items of clothing that have the highest average rating. In your analysis, include 1) only items of clothing that have at least 10 positive feedback reviews and 2) the five highest rated clothing items from each class.   The original data and its metadata can be found here.        ... View more

A solution to last week's challenge can be found here. "Sweet Pets" by Gallery Sweet Spot is marked under CC PDM 1.0. To view the terms, visit https://creativecommons.org/publicdomain/mark/1.0/ Find My Pet US is a platform that helps animal owners find their lost pets in animal shelters in the United States. Find My Pet US wants to expand its business. A data analyst hired by the company is researching various scenarios.   One of the scenarios investigated by the data Analyst includes the following two conditions: • Pet owners who are offering a reward equal and over $2,700, and; • Pet owners living within 500 miles from the shelter where the pet is.   The dataset “Pet_info” contains information about the pets. The dataset “Animal_Rewards” lists the rewards associated with the animal ID. The dataset “Owner_Info” provides information about the owners.   Use the datasets to find out which animal owners to target based on the two conditions of this scenario. ... View more

The idea of the challenge is simple, but it could be a little trick to execute!   Provided are a set of coordinates. With this set of triangles, you must create triangles. Each triangular spatial object must have exactly 3 non-collinear points. With this data set, you should create 516 unique triangles! How many of the 516 can you get?     This week's challenge was contributed by @CharlieS !     ... 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 was brought to us by one of our own Community members and Weekly Challenge gurus: @NicoleJohnson. Nicole devised this challenge for her user group whilst looking for a challenge that would exercise many of the commonly used tools in Alteryx. If you ever have a challenge that you would like to be featured, please DM me!   As we all know, the housing market these days is going a bit crazy... we'd like to capture some census data on the value of new privately owned housing units in various metropolitan areas to see where the top 10 markets are YTD as of end of April (data lags about 2 months behind). Our objective for this challenge is to capture Census data from the following URL: https://www.census.gov/construction/bps/txt/t3yv201704.txt We will then need to parse the data into the columns identified in text input #2, then sort to find the top 10 new housing markets based on value.   BONUS: Build an app that will allow you to choose whether you want to look at value (the "v" in "t3yv" in the URL above) or units (which would look like "t3yu"), specify the through-date (year & month designated at the end of the txt file name, in the example above as "201704"), and which column you want to sort by (Total, 1 Unit, 2 Units, etc.)   This location will be one of the top performing markets ... View more