Learning Spatial Analytics from the Love Doctor

by Andy Kriebel

I’m the luckiest person on the planet. Not only am I getting to teach the next generation of Tableau Zens and Alteryx Aces, but I get to attend the Data School as a student myself. In particular, I’m soaking up all I can about Alteryx. Monday, the Love Doctor (a.k.a. Chris Love), taught an intro session on spatial analytics with Alteryx. He’s quite an amazing coach and has a great way of explaining concepts to get you to the “aha!” moment so much more quickly.

We covered four topics:

  1. Manually creating a simple polygon with points
  2. Creating polygons based on UK postcode sectors
  3. Creating polygons of UK postcode areas, which required some grouping of the data from exercise 2
  4. Building custom trade areas

For the last exercise, I decided to go a step farther and create four different trade areas and allow the user to selection the option they want to view in Tableau. Here’s my Alteryx workflow (click on the image for a larger view):

Trade Areas

And here’s the Tableau viz. Notice how I include the centroid of each trade area as a + mark. That little trick was done with a dual-axis. Click on the image to go to the interactive version and to see the output from all four exercises.

Trade Areas

My overall impression of spatial analytics in Alteryx? One word: simple. Alteryx makes it’s incredibly easy to create just about any spatial data set you can imagine. I can’t wait to see what the Love Doctor has in store for us in the advanced spatial analytics class!

Avatar

Andy Kriebel

Dashboard Week Day 5 - Eastern Bering Sea Crab Distribution

1 mins read

Fri 27 Nov 2020

Dashboard Week Day 4 - California Fire Incidents

1 mins read

Wed 25 Nov 2020

Dashboard Week Day 3 - Historical Tornado Tracks

1 mins read

Wed 25 Nov 2020

Dashboard Week Day 2 - The Change in Forest Cover

1 mins read

Tue 24 Nov 2020