An application of Spatial Tools in Alteryx

by Simona Loffredo

For the last client project we had, my task was to build an Infographic (for internal purposes) to let the Business understand where the orders come from by Region.

The best visual way to provide this information is through a map!

The dataset I had contained the detail by postcode and areacode (in the UK) for each order, so I needed to work a bit in Alteryx in order to have a map in Tableau! Below the two workflows I have built.

alteryx wf

 

1.WORKFLOW TO ASSIGN LATITUDE&LONGITUDE AND THE REGION TO POSTCODES

STEP 1

First of all, I need to assign Latitude and Longitude for each postcode: I build an Alteryx Workflow with the dataset and I join it by Areacode with another dataset containing latitude and longitude by postcode.

step1

STEP 2

Then, I use the “Create Points” tool in order to transform latitude and longitude into spatial points.

step2

STEP 3

Input a shapefile containing England Regions and use a “Spatial Match” tool in order to match the spatial points created in step 2 into the regions.

step3

You can then create an output to use in Tableau as your dataset! But what about the map?

 

2.WORKFLOW TO GENERATE A MAP FOR TABLEAU

STEP 4

The workflow below is build using a Macro called “Tableau Polygon” that is very useful because it generates a map that Tableau can read!

step4

Here is the map!

map

Now, just blend the two datasets in Tableau by the common field “Region” and build the visualization!

Hope you find it useful.

A presto!

 

PS:Thanks Ben for helping!

Avatar

Simona Loffredo

When use what? - PART 6 - Rank_Unique can solve your problems!

2 mins read

Thu 17 Mar 2016

A smart way to investigate your data in Alteryx

4 mins read

Fri 04 Mar 2016

Filtering with multiple datasources - Part 2

2 mins read

Sat 27 Feb 2016

Filtering with multiple datasources - Part 1

2 mins read

Fri 26 Feb 2016