Creating Isochrones using Alteryx & Tableau (Part 2)

by Chris Hutchinson
on May 25, 2020

In Part 1 we showed how to create isochrone shapefiles in Alteryx, using some of the TravelTime macros. In this post we will walk through how to visualise these isochrones in Tableau. For this you will need access to a TravelTime API key.

The first step is to convert the shapefile into a format that Tableau can connect to. The shapefile created in Alteryx is actually four separate files, as you can see here:

Tableau-isochrone-output

To allow Tableau to connect to these, we simply put them into a new folder, and compress (zip) it:

Tableau-isochrone-files

Now we can open Tableau and connect to a Spatial file:

Tableau-isochrone-spatial

Select the zipped folder containing the shapefile and open it. Tableau will automatically load the isochrones into a table, with one line per isochrone.

Tableau-isochrone-zip

Now that the data is loaded into Tableau, the next step is to create new worksheet.

Tableau-isochrone-sheet

Drag the Geometry measure into the marks card. A COLLECT calculation will be run automatically, and the result will look something like this:

Tableau-isochrone

We now have our isochrones displayed on the map, but we’d like to be able to distinguish more easily between the 15 and 30 minute shapes. To do this we need to format the Query_Isoc column (Tip - if you’ve renamed your fields at any point, this is the field containing the travel times in seconds – in this case 900s and 1800s).

Firstly we create a calculated field to convert the number into minutes (divide by 60):

Tableau-isochrone-create

Tableau-isochrone-valid

Next we convert this new ‘Minutes travel’ measure into a Dimension and then drag the new dimension into Colour on the marks card.

We can now easily distinguish between the two 15 minute isochrones and the 30 minute ones:

Tableau-isochrone-TravelTime

Creating Isochrones is just one of the functionalities of the TravelTime macros for Alteryx. They can also be used for calculating large journey time matrices, A to B routing, geocoding, and more.

To find out more about how these macros can help you make better business decisions with your data, please get in touch here.

Related

Creating Isochrones using Alteryx & Tableau (Part 1)

Tutorial of how to prepare isochrone data using Alteryx to visualise using Tableau. Useful for site selection, network analysis or field management.

Chris Hutchinson May 25, 2020
READ

TravelTime Spatial Analysis Alteryx Macros

The TravelTime suite of macros takes spatial analysis to the next level, enriching Alteryx data with directions, travel cost and journey time information. Geocoding, isochrones, distance matrix & more.

Chris Hutchinson Apr 10, 2020
READ

The Telegraph use TravelTime to highlight access to hospitals across the UK

The Telegraph used TravelTime analysis to identify how many people in the UK do not have access to a coronavirus test centre within 1 hour drive times. Explore the case study.

Louisa Bainbridge May 7, 2020
READ

Find smart city technology examples to help you innovate

Learn about smart city technology. See how different cities use smart city technology to improve the efficiency of the city and the services it provides.

Evelina Bezubec Aug 1, 2019
READ

3 ways to use business location analysis

Use business location analysis tools to support business decision making. Visualize staff commute times and create a travel time matrix for office relocation.

Niharika Sisodia Oct 9, 2018
READ

Find the best delivery mapping software for your business

Discover the best delivery mapping software features. Increase the efficiency and productivity of your business. Improve customer service and cut costs.

Niharika Sisodia Sep 20, 2018
READ