Samriti
Project lead
- • Led the project and repository at github.com/Samriti5959/gta-housing-affordability
- • Owned the schedule and merged team findings across pipeline steps
← Back to work
Data & Analytics
In progress
GTA Housing Affordability
How affordable is renting across Greater Toronto Area municipalities — comparing CMHC rent data against census household income, city by city
Project collaborators
Rebal
Data analyst
- • Contributed to team analysis and pipeline deliverables
Business question
How affordable is renting in different Greater Toronto Area municipalities when rent is compared to local household income?
Executive summary
Compares CMHC average rents against StatCan median household income at the municipality level instead of treating the GTA as one number.
Key findings
-
Affordability varies sharply by municipality; city-level (CSD) data reveals differences that CMA-wide averages hide.
Impact
Potential
Supports municipal-level housing affordability comparisons; formal measured outcomes depend on dashboard completion and stakeholder use.
How this approach can help a business
Helps frame where rent-to-income pressure is highest across GTA cities such as Brampton, Mississauga, Toronto, Oakville, and Markham.
My role on the team
Worked with Samriti (project lead) and Rebal on the team pipeline — data extraction, cleaning and joining rent and income datasets, SQL KPI analysis, and dashboard preparation in Microsoft Fabric and Power BI.
Python · SQL · Microsoft Fabric · Power BI · CMHC data · Statistics Canada
Overview
GTA Housing Affordability — A collaborative team project led by Samriti, asking how affordable renting is across Greater Toronto Area municipalities. I worked on this with Samriti and Rebal — it is not my solo project. The repo lives under Samriti's GitHub.
Instead of using one metro-wide figure, the project compares CMHC Rental Market Survey rents against Statistics Canada median household income at the census subdivision (city) level. The final deliverable is a Power BI dashboard.
Key features
- City-level comparison — Brampton, Mississauga, Toronto, Oakville, Markham, and other GTA municipalities
- Dual data sources — CMHC average rent by bedroom type joined to StatCan 2021 Census median household income
- Structured pipeline — get data → extract to Fabric → clean and join → SQL analysis → Power BI dashboard
- Documented caveats — time gap between census income and latest rent survey, purpose-built rentals only, household vs. individual income
Data sources
| Dataset | Source | Geography | |---------|--------|-----------| | Rent | CMHC Housing Market Information Portal | Census subdivision / CMHC zone | | Income | Statistics Canada 2021 Census via WDS API | Census subdivision |
Technical focus
Microsoft Fabric Lakehouse extraction, PySpark and Dataflow Gen2 for cleaning and joins, SQL for business questions and KPIs, and Power BI for the dashboard. Municipality matching uses StatCan SGC codes where name labels differ between CMHC and StatCan.
Status
Active work in progress — step 1 (data collection) is complete; Fabric loading, cleaning, analysis, and dashboard are underway. See Samriti's GitHub repository for pipeline folders and schedule.