Alteryx Academy

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. Did you make any New Year's resolutions? Do you think you will stick to them? Every year, people around the world start their new year by setting resolutions aimed at improving their lives. Using the following dataset with information from a survey of 1,075 adults conducted from November 28 through December 4, 2018, by The Marist Poll, find the answer to these questions: 1. What were the top 3 New Year's resolutions for 2019? 2. What percentage of fitness-related resolutions (exercising more, losing weight, eating healthier and improving health) were made by suburban men and women? 3. Which group of people were most likely to keep their resolutions in 2018? Source: http://maristpoll.marist.edu/wp-content/uploads/2018/12/NPR_PBS-NewsHour_Marist-Poll_USA-NOS-and-Tables_New-Years-Resolutions_1812061019-1.pdf#page=3 ... View more

A solution to last week’s challenge can be found here.  Source: https://snaped.fns.usda.gov/seasonal-produce-guide/mushrooms   This week's challenge focuses on a dataset describing mushrooms which has been encoded. In the 23 columns describing each mushroom observed, the values are represented by a single character. Use the Attribute Info table to replace the coded information with the values they represent. ... View more

We hope you enjoyed last week's challenge . The solution has been posted here. For the second challenge lets look at removing characters and splitting data into columns based on delimiters.   Many products will export textual data with delimiters such as quotes. This is done so that strings can contain delimiters or control characters within them. Having more than one type of delimiter can be hard for ETL programs to interpret.  In the input text file, there are two different delimiters (double quotes, single quotes) and they surround different data types.   Use Alteryx to strip out the delimiters as superfluous and format the data as represented in the output.   You may notice that we have started classifying the exercises into beginner, Intermediate and advanced.  This classification is used by Alteryx internally to sequence exercises as users advance.    Update 11/23/2015: The solution has been uploaded. ... View more

The link to last week’s challenge is HERE.   This week’s exercise is another example of how Alteryx can take poorly formatted data such as transactional log files and turn it into usable data.   Use Case:  A customer has some data that comes with key product information stored at the top of the file.  Each data column contains three lines of header information per product (product, market and type).  The customer wants this information to be shown in rows for each product.   Objective:  Reformat the input data to match the output example .   ... View more