1. Getting the data ready in an Excel spreadsheet
I’m basing this data on a list from Wikipedia. It’s an article listing the busiest air routes in Australia by passenger traffic.
Below is the data that I’ve added and edited. I’m only interested in passengers from 2017.
I’ve listed each Route twice, with each instance having a different Path. This will be important for connecting the two cities in Tableau.
So for example, Adelaide – Brisbane is listed twice. Once with Path = 1 and City = Adelaide, and again with Path = 2 and City = Brisbane.
You can download the Excel file at this link: https://michaelhoweely.com/wp-content/uploads/2019/12/Australia-Flight-Routes-data-.xlsx
2. Adding the data to Tableau
Open up Tableau (in this example we will be using Tableau Public) and click to connect to a Microsoft Excel file.
Select the relevant Excel file, and then upload it. Your data should look something like this.
We can now move on to building our visualization of flight paths.
3. Adding the dimensions and measures to a sheet
With our data added, if we open up Sheet 1 we should see the data separated into Dimensions and Measures as shown below.
We can start off by dragging Country onto our Sheet.
Next, drag Route, 2017 Passengers, and City onto the sheet. Add City twice as shown below.
4. Choosing how the dimensions and measures are displayed
To create our Flight Path Map in Tableau, we need to adjust how the dimensions and measures are displayed.
Let’s first click on Size and adjust to make the circles bigger.
Then change the first City’s setting from detail to Colour.
Finally, change the display setting from Automatic to Line, as shown below.
The colours of each city blend into each other, which is a cool feature.
The next step is to change the setting of SUM(2017 Passengers) from Detail to Size. This now changes the visualization to show the number of passengers going out of each city.
5. Adding a City filter to our workbook
The final step is adding an option to filter by City to our Map.
We can now filter our filter routes by including and excluding the various cities. In the example below, on the left we have all cities selected, while on the right we have only included Adelaide, Melbourne and Sydney.
6. Saving and displaying on Tableau Public
I’m using a Tableau Public account, so I’ll be saving this visualization workbook to there. Click File and then Save to Tableau Public.
You’ll then need to sign in to your Tableau account.
Then decide on a name for the Workbook
It should save and open up the file in Tableau Public.
To embed on a website, we can click to share and then copy and paste the embed code.
7. Viewing the final Flight Path Map in Tableau
Now our visualization is ready to be shared and embedded online!
I hope you have enjoyed this first post about Tableau on my blog!
Additional Tableau Resources
I learnt how to make this type of map by watching this video from SuperDataScience on YouTube a few years ago. It’s a great video that uses a different data set than mine, so would recommend watching!
My Other Blog posts
If you’d like to check out other blog posts about digital analytics, take a look at some of my other articles.