Basics, Visualization Tutorials

Mumbai Local Railway Map in Tableau

About Tableau

Tableau is one of the most popular tools for data visualization. Here I am going to use tableau to plot the railway and metro network in Mumbai city. The objective of this article is to show step by step method to plot any type of network which can be Rail Network, Road network on the map using Tableau.
Various parameters such as station, traffic density and frequency can be plotted along with this proposed network map.

Dataset details

We need a data source in order to design this program in Tableau. Data set should have information as follow as
 Network Name
 Unique network ID
 Station Order
 Station Name
 Latitude and longitude coordinates for each station
 Traffic (Optional)

Please note that the traffic considered here is arranged in 5 levels, where 5 rates as highest traffic and 1 are lowest (May not relate with live data).
Excel file screenshot is provided in order to understand the type of data requires for the map. This data will provide you a better understanding of what is the basic requirement to plot the map on Tableau.

Dataset snapshot
Dataset required for building the map in Tableau

 The 1st column is “Network” which represents the name or type of that transport line
 The 2nd column is the “Network ID” in which we need to give number to station with respect to the corresponding line
 The 3rd column is “Station Order” which represents the sequence of stations in a single line.
 The 4th column is “Station Name”
 5th and 6th columns are simply the “Latitude and Longitude” of the station location.

Please note that the Station Order which is the sequence of the station should be with respect to the line (Check 8th row in the dataset).

Steps to build the map

Step 1: Connect tableau to the excel file where you have all your station data

Step 2: In the new worksheet drag longitude to the column shelf and the latitude to the roads shelf. Make sure that longitude and latitude are continuous measures and both are assigned the Geographic role.

Step 3: From dimensions category drag Network ID to ‘details’ on the marks card.

Step 4: Select the type in the drop-down menu as ‘line’

Step 5: From the dimensions, drag station order to the path on the marks card. Station Order should be aggregated as the sum. Also, change SUM (Station Order) field into the dimension.

step 5

Step 6: From dimensions drag down Network ID to the colors on the marks card.

step 6

Step 7: Now from measures again drag longitude in the column shelf and place it on the right side of the previous longitude. So now you can see that there are total 2 longitude fields in the column shelf. An identical map on both sides will get updated after this. Now go to marks card and click the bottom longitude tab, click on the mark type drop down and select ‘automatic‘.

Step 8: And you can see the updates on the map as follow.

step 8

Step 9: Go to 2nd longitude field in the column shelf and select the dual Axis option. The updated view looks like:

step 9

At this moment our Map is ready. To get the analytical view we can add Network and traffic in the filter. We can also write their names but due to space and size consideration, I have shown only south part of Mumbai which includes all the networks.

final plot

Tagged , , ,