top of page

Mobile Dashboard - High Duration TTC Delays

Last Update: March 6th, 2020.​

Tableau Dashboard

1) Project Goal

Project Goal
  • Design and create a mobile-optimized dashboard that tracks high-duration ( > 30 minutes) TTC delays.

2) Data Source & Preparation

Data Preparation

Data Sources

Data Preparation

  • Since the data was spread out over multiple Excel files covering multiple months/years, the files were first checked to determine whether the data structure was consistent for each one.

  • Then, the Python glob and Pandas libraries were used to go through each file and combine them into a single data source file.

  • Finally, the data was then imported into Tableau for visualization.

bottom of page