Alteryx Academy

A solution to last week's challenge can be found here.    For this week's challenge, we will use Designer to solve/prove a classic verbal arithmetic problem. In this case, each letter in the equation "SEND + MORE = MONEY" will have a unique value between 0 and 9. Your job is to find the solution that makes the equation true. ... View more

The link to last week’s challenge (challenge #27) is HERE     Use Case:  A company has to process financial data for their visualization tool.  Today this is a manual process in Excel.   Objective:  Build a process in Alteryx that automates the formatting of the daily data feed.   Note: This data comes in daily and is always in the exact same format.     ... View more

The link to last week’s challenge ( challenge #24) is HERE.   As we have said before, restructuring poorly formatted data is one of the most common Alteryx use cases.  This week’s challenge is another real world example of a data problem faced by one of our customers.   Use Case: A credit card company’s customer Data is structured so that each row of data contains the merchants each customer has visited in a given week. The credit card company is wanting to understand the correlation of merchants visited by customer. For example: if a customer visit 7-11 what other stores do they have a high propensity to visit?   Objective:  Restructure the data into rows that pair merchants together by customer. ... View more

Congratulations on completing Exercise 2!    When you are ready to submit your solution, click "Reply" to this post and upload your workflow.   You may also download and review the attached solution. ... View more

For those of you following along, thank you, you can find the solution to last week’s challenge ( challenge #23) is HERE.    This week’s challenge will use the predictive time series tool called ARIMA.  If you don’t have the predictive tools you can find the installer at http://downloads.alteryx.com/downloads.html look for the link to “Predictive tools only”.   The predictive tools in Alteryx execute the analytics in an open source application called ‘R’, the advantage of using Alteryx vs. R is that Alteryx provides a straight-forward user interface and eliminates the need to program directly in the R language.  If you want to read more about what is happening under the hood, here is a link to the Wiki on ARIMA. https://en.wikipedia.org/wiki/Autoregressive_integrated_moving_average   The use case:  A retailer would like to forecast how many units of a particular product will be purchased from their locations based on a historical trend.   The source data contains weekly data for 2012 and 2013 details how many units have been moved. Some of the data, however, is populated with NULL values. For the NULL values, please assign the monthly average. If the monthly average is also NULL, assign the annual average.   Objective:  Forecast the number of units that will be sold in the six weeks following the available data. Have fun! ... View more