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...
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
The link to last week’s challenge is HERE.
Wow, exercise #51 already. Can’t believe it has been nearly a year!
For this week I would like to investigate some of the geospatial tools available in Alteryx The spatial tools will allow you to calculate distances, create trade areas, find intersection of spatial objects, calculate sizes, etc.. Even if you don’t have the spatial data from Alteryx (the spatial data provides supporting data packages for geocoding, address standardization and calculations using the road network), most of the tools will still perform as long as you have the spatial references or objects already available in your input data.
Use Case: For regulatory purposes we have been asked to identify the all the counties within a 15-mile radius of each of our stores as well as identifying the percent of the county’s area that is overlapped (Coverage).
Objective:
Part 1) Calculate the percent overlap by individual store
Part 2) Calculate the percent of overlap by county for the entire store network
... View more
A solution to last week’s challenge can be found here.
This week's challenge was submitted by @wwatson - Thanks for your submission!
In this week's challenge, a farmer has 7 fields which are all bound by hedges. He provides you with a series of spatial points defining the corners of the fields.
He would like you to calculate the total area of the farm in Sq Km, the perimeter of the farm in Km, the area and perimeter of each field and the total length of the hedges on the farm.
... View more
A solution to last week’s challenge can be found here. "Women Shoe Store" by MyStockPhotos is marked with CC0 1.0
For this week's challenge, let’s do a bit of data preparation using shoe inventory data!
The following dataset contains a list of shoes with an ID, colors, and sizes available.
For this challenge, you want to clean the inventory data and reorganize the list to have: - A new ID number - The size - A comment stating how many colors are available, and - Three columns for color
Keep in mind that the names of the colors are separated by the sign /.
... View more
A solution to last week’s challenge can be found here. image source: https://en.wikipedia.org/wiki/States_of_Brazil
Did you know that Brazil is the largest country in South America? “Super legal!” you say to yourself em Português. Brazil is also an incredibly diverse country with many unique geographic regions. That’s why it’s a good idea to bring a map.
Unfortunately, the map I found is from 1920 and doesn’t show all 27 states (26 and the Federal District). Your task is to use the supplied data to update the map from the 22 existing states to include all 27.
Additionally, the capital moved from Rio de Janeiro to Brasilia in 1960, so the updated state of Rio de Janeiro should regain the land occupied by the Federal District in the 1920 map.
Boa Sorte!
... View more