BACK TO PORTFOLIO

03 / PORTFOLIO / PROJECT_01

Toronto Rent Heatmap Lab

A city-data workflow that turns official rental data into an interactive view of rent pressure across Toronto.

STATUSDEPLOYED / VERIFIEDEVIDENCELive map · Tested pipeline · CI
01 / CHALLENGE

What needed to be solved

Public rental information is fragmented across tables and geographic boundaries, making neighbourhood-level comparison difficult for a nontechnical viewer.

02 / SOLUTION

How I approached it

A reproducible pipeline connects official data, Python ETL, a SQL warehouse model, validation tests, and an interactive regional heatmap.

03 / OUTCOME

What exists now

A working live map, documented update path, Power BI-ready outputs, automated tests, and continuous integration.

TECHNICAL SYSTEM

PYTHONSQLETLPOWER BI