I had an Tableau session last week and I came across possibility of creating hub and spoke in Tableau. I am aware of its been discussed earlier as well in multiple blogs and Tableau public but here I am sharing my experience with Hub and Spoke.
For the matter of this visualization, I extracted all the arrival data to Mumbai airport for 19th Feb from Mumbai Airport arrival website and created excel file in below format:
Each origin and destination had to duplicated into multiple records. For Example:
Flight|Origin|PathID|ArrivalTime|…
6E 189|Delhi |Delhi – Mumbai|00:40|…
6E 189|Mumbai |Delhi – Mumbai|00:40|…
Next step was to import the data into Tableau and do the necessary data manipulation for cleaner data.
- Add origin to detail tab under marks section, this will enable latitude and longitude in the sheet
- Drag path id column into color pallette.
- select the number of records and put into size tab
This will create following route map (hub & Spoke model) as per below image:
Then I created couple of other sheets on the basis of on-time performance and delay types for different airlines flight arriving at Mumbai Airport and created the final dashboard showing all the details.
Let me know your feedback on the dashboard