Dashboard week Day 2 started with new data from Ayelavan.

It was very interesting data and has a personal connection to all us – it was about Sydney trains –  our lifeline.

The data set has details of all the trains for next 1 month. Beyond anyone’s guess, Sydney trains are going to make more than one million stops over next one month.

We started the task with joining all the files to prepare a clean and meaningful data for analysis.


One small but critical step which we should go through before every data analysis is to review the current data type of all the fields. The same was applied for this data set and data types corrected to numbers from string wherever applicable. Here is my Dashboard which is about Sydney trains routes for next one month. There are more than 380 stations with around 830 platforms.

For more details, please follow the link below:










Babita Dalal
Author: Babita Dalal