About This Project
Introduction
Let's start with a confession: I've been in Canada for years and still only have my G1 license.
As someone who relies entirely on public transit, I've spent countless hours waiting for buses that either never show up or arrive so late they might as well be a different route entirely.
That frustration standing in the cold, watching estimated arrival times tick up like a cruel joke is what inspired this project.
What started as a personal quest to understand why the 16-McCowan Bus is perpetually late evolved into a comprehensive analysis of Toronto's entire transit system.
This web app is my attempt to bring transparency to TTC performance, helping fellow transit users make informed decisions and maybe, just maybe, arrive at their destinations on time.
Project Story
This project began in 2023 as simple curiosity about TTC delays, starting with a basic
Tableau dashboard.
In 2024, I expanded it into a comprehensive
Power BI semantic data model,
merging multiple datasets for deeper analysis. The project evolved further with a
Streamlit app for forecasting and trend analysis,
and GIS work to map routes geographically. In May 2025, I shared insights in a
Medium article,
and the current web app was inspired by projects like the
Toronto Parking Analysis.
Contact
References & Data Sources
This project would not be possible without the open data provided by these organizations:
TTC Open Data Portal
Historical delay data, route information, and schedule data
City of Toronto Open Data
Geographic data, neighborhood boundaries, and infrastructure information