Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
Here is the new weekly challenge. The link to the solution for last challenge is HERE. For this challenge let’s look at ranking records when multiple records can have the same rank. The objective is to determine the top 5 ranking based on the count, however since there are multiple rows with same count (similar to a round of golf) multiple people can be in the same place (Rank) if they have the same score.
We have listed this as a beginner challenge and I expect it will go very quickly for many of you. Let us know what you think, we are looking forward to hearing your feedback.
UPDATE 1/25/2016
The solution has been uploaded.
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
Ellen Wiegand, a Senior Sales Engineer at Alteryx, brought us this brilliant challenge idea. We are truly grateful for your contribution, Ellen!
Considering the importance of renewable energy and to celebrate Earth Day, let's work on a challenge regarding sustainable energy! We have a dataset that provides detailed information about wind towers in the United States and its territories. The text input file contains the latitude and longitude coordinates for Alteryx headquarters in Irvine, California.
Looking only at wind towers with an Attribute Confidence of 3 and Projects with more than one wind tower, complete the following tasks. (Note: The Column Descriptors tool container in the workflow file contains the definitions of the values in the input dataset.)
What is the name of the project closest to the Irvine office (CA)?
How far away from the office is it?
Hint: The provided dataset is a flat file. To facilitate the data extraction, use the JSON Parse tool in the Developer tab of Designer.
Need a refresher? Review these lessons in Academy to gear up:
Parsing JSON
Creating Spatial Objects
Changing Data Layouts
Sources:
https://evwhs.digitalglobe.com
http://www.google.com/earth/download/ge/
http://datagateway.nrcs.usda.gov/
Good luck!
... View more
Aggregate Consumer Purchases:
For this week’s exercise we will look at customer purchase behavior to decide if we should offer a “Meal Deal” that would add a side and drink to a purchase of pizza or a burger. The incoming data is larger than usual for these exercises so I have packaged the workflow as an Alteryx Package. The link to the solution for last challenge #7 is HERE.
This week’s Objective:
In order to decide if we should start including a new "Meal Deal" on our menu we want to study the potential impact on recent transactions. Please identify the number and percentage of orders since July 1, 2013 which include the following categories of food: Pizza OR Burger along with a Side and Drink.
Summary of Data:
Point of Sale data includes the ticket level information, and the lookup table categorizes items into higher level food categories.
Hint:
Don't forget to join to the lookup table and filter by date.
As always we look forward to your feedback and suggestions!
UPDATE 01/18/2016:
The solution has been uploaded.
UPDATE 12/28/2016:
The challenge, text and solution have been updated.
... View more
The link to the solution for last challenge #37 is HERE.
One of the powers of Alteryx is to be able to batch processes without the need to write scripts of use complicated code. A single output tool can be configured to generate many output files.
Use Case: A company needs to blend data from three sources and generate an output file for each product - region combination, a total of 15 output files.
Objective: Create a cross join between the Product Group, Region Reference and Data tables to produce 15 unique CSV Data files. Please note that only 1 output tool should be leveraged in your solution.
Thanks to all that are playing along!
... View more
Welcome to 2016 we hope you are enjoying these challenges. The link to the solution for last challenge #6 is here. For the seventh challenge let’s look at downloading data with an API and parsing that data from JSON into a usable format.
The data we will use comes from Quandl. The Quandl site offers access to several million financial, economic and social datasets. Data is indexed from multiple sources allowing users to find and download in various formats. All Quandl's data are accessible via an API.
For this example the response from these APIs is JSON. Our user is trying to get aggregated Annual Outbound Tourism Statistics for the US dating back to 1995. The Text Input contains the URL for the API request. Your goal is to parse the response.
Hint: After parsing the JSON, you will need to further identify the patterns within the data to effectively stage into a table for analytics.
Note: The data in the API is subject to change. When trying to match the output, the effort should be focused on achieving an identically structured dataset.
We have listed this as an advanced challenge since configuring the download tool and parsing functions are more advanced topics. We are looking forward to hearing your feedback.
UPDATE 1/11/2016: the solution to this exercise can be found below.
UPDATE 4/10/2019: Previous API link expired. Exercise updated to new API.
... View more