An application of Spatial Tools in Alteryx

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!

Author:
Simona Loffredo
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2024 The Information Lab