What needed to be solved
Public rental information is fragmented across tables and geographic boundaries, making neighbourhood-level comparison difficult for a nontechnical viewer.
03 / PORTFOLIO / PROJECT_01
A city-data workflow that turns official rental data into an interactive view of rent pressure across Toronto.
Public rental information is fragmented across tables and geographic boundaries, making neighbourhood-level comparison difficult for a nontechnical viewer.
A reproducible pipeline connects official data, Python ETL, a SQL warehouse model, validation tests, and an interactive regional heatmap.
A working live map, documented update path, Power BI-ready outputs, automated tests, and continuous integration.
TECHNICAL SYSTEM