Block a user
Create additional figure factories for dashboard charts
Create data loading pipeline script
Rebuild dashboard.py with 5-tab structure
Complete census profile parser for Toronto Open Data
Complete census profile parser for Toronto Open Data
Implementation Complete ✅
Implemented get_census_profiles() in toronto_open_data.py:
Changes:
- Added
CENSUS_INDICATOR_MAPPINGclass constant to map census indicators to…
End-to-end integration testing and documentation
Create data service layer connecting dbt marts to dashboard
Implement dashboard callbacks for interactivity
Create additional figure factories for dashboard charts
Rebuild dashboard.py with 5-tab structure
Create data loading pipeline script
Complete census profile parser for Toronto Open Data
Update dbt sources and schema documentation
Create mart dbt models for dashboard tabs
Create intermediate dbt models for neighbourhood data
Create staging dbt models for Toronto neighbourhood tables
Update dbt sources and schema documentation
Completed ✅
All documentation updated:
_sources.yml- Added 4 new source tables (fact_census, fact_crime, fact_amenities, bridge_cmhc_neighbourhood)_staging.yml- Documented all 5…
Create mart dbt models for dashboard tabs
Completed ✅
All 5 mart models created:
mart_neighbourhood_overview.sql- Composite livability score (safety 30%, affordability 40%, amenities 30%)mart_neighbourhood_housing.sql-…
Create intermediate dbt models for neighbourhood data
Completed ✅
All 5 intermediate models created:
int_neighbourhood__demographics.sql- Combined census with income quintilesint_neighbourhood__housing.sql- Housing indicators +…