Leo Miranda lmiranda
  • Toronto, ON - Canada
  • Joined on 2025-07-31
lmiranda closed issue personal-projects/personal-portfolio#67 2026-01-17 16:25:12 +00:00
Create additional figure factories for dashboard charts
lmiranda closed issue personal-projects/personal-portfolio#65 2026-01-17 16:22:41 +00:00
Create data loading pipeline script
lmiranda closed issue personal-projects/personal-portfolio#66 2026-01-17 16:20:23 +00:00
Rebuild dashboard.py with 5-tab structure
lmiranda closed issue personal-projects/personal-portfolio#64 2026-01-17 16:15:43 +00:00
Complete census profile parser for Toronto Open Data
lmiranda commented on issue personal-projects/personal-portfolio#64 2026-01-17 16:15:16 +00:00
Complete census profile parser for Toronto Open Data

Implementation Complete

Implemented get_census_profiles() in toronto_open_data.py:

Changes:

  1. Added CENSUS_INDICATOR_MAPPING class constant to map census indicators to…
lmiranda opened issue personal-projects/personal-portfolio#70 2026-01-17 16:09:23 +00:00
End-to-end integration testing and documentation
lmiranda opened issue personal-projects/personal-portfolio#69 2026-01-17 16:09:01 +00:00
Create data service layer connecting dbt marts to dashboard
lmiranda opened issue personal-projects/personal-portfolio#68 2026-01-17 16:08:41 +00:00
Implement dashboard callbacks for interactivity
lmiranda opened issue personal-projects/personal-portfolio#67 2026-01-17 16:08:19 +00:00
Create additional figure factories for dashboard charts
lmiranda opened issue personal-projects/personal-portfolio#66 2026-01-17 16:08:00 +00:00
Rebuild dashboard.py with 5-tab structure
lmiranda opened issue personal-projects/personal-portfolio#65 2026-01-17 16:07:39 +00:00
Create data loading pipeline script
lmiranda opened issue personal-projects/personal-portfolio#64 2026-01-17 16:07:22 +00:00
Complete census profile parser for Toronto Open Data
lmiranda pushed to development at personal-projects/personal-portfolio 2026-01-16 16:55:12 +00:00
3054441630 docs: Add local lessons learned backup system
b6d210ec6b feat: Implement Phase 4 dbt model restructuring
053acf6436 feat: Implement Phase 3 neighbourhood data model
Compare 3 commits »
lmiranda closed issue personal-projects/personal-portfolio#63 2026-01-16 16:39:04 +00:00
Update dbt sources and schema documentation
lmiranda closed issue personal-projects/personal-portfolio#62 2026-01-16 16:39:01 +00:00
Create mart dbt models for dashboard tabs
lmiranda closed issue personal-projects/personal-portfolio#61 2026-01-16 16:38:58 +00:00
Create intermediate dbt models for neighbourhood data
lmiranda closed issue personal-projects/personal-portfolio#60 2026-01-16 16:38:56 +00:00
Create staging dbt models for Toronto neighbourhood tables
lmiranda commented on issue personal-projects/personal-portfolio#63 2026-01-16 16:38:45 +00:00
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…
lmiranda commented on issue personal-projects/personal-portfolio#62 2026-01-16 16:38:41 +00:00
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 -…
lmiranda commented on issue personal-projects/personal-portfolio#61 2026-01-16 16:38:35 +00:00
Create intermediate dbt models for neighbourhood data

Completed

All 5 intermediate models created:

  • int_neighbourhood__demographics.sql - Combined census with income quintiles
  • int_neighbourhood__housing.sql - Housing indicators +…