Alteryx Academy

We hope you enjoyed last week's challenge.   For the sixth challenge  lets look at some of the geospatial capabilities in Alteryx.   The challenge  for week 6 will focus on analyzing distance traveled by sales reps. Sales reps are travelling all over the US. The data contained in the workflow details the travel paths for 7 Reps to 7 different cities. The travel route is detailed as well. The objective of this challenge  is to determine which Rep has logged the most miles. Please include the route traveled as a spatial object in the output.   We have listed this as an intermediate challenge  since not everyone is familiar with the Spatial tools.  As always, we love to hear your comments. We hope you are having fun with the challenges ! ... View more

Congratulations on completing Exercise 4!    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

We hope you enjoyed last week's challenge. For the fifth challenge  let’s look at building an analytic application. An HR department has a defined hierarchy for job identification across the organization. Depending on the job, the position within the hierarchy can change.   The goal is to create an analytical application that allows a HR rep to enter a position # (in this example, 33333) and return all records where the position is found within the hierarchy system.   We have listed this as an intermediate challenge  since parameterizing a workflow and converting it to an application is slightly more advanced however the workflow to answer the question should be beginner level. As always, we love to hear your comments. We hope you are having fun with the challenges !   UPDATE 12/14/2015: The Solution has been uploaded. ... View more

A solution to last week's challenge can be found here.    If you’ve ever attempted to troubleshoot someone else’s workflow, you know that it can be challenging. Do you see where this is headed?   For this week’s challenge, someone was clever enough to create a workflow that generates a chart representing the nationalities of team members for the 7 top teams in the German Bundesliga. They also included some statistics about the top 3 goal contributors on each team. The workflow is in place but isn’t working. Can you Configure It Out? ... 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