YYC-Wander

In my journey through the urban landscape

Home → Civic & Social Analytics → CBE School Capacity & Utilization

CBE School Capacity & Utilization (2015–2024)(Calgary)

Filter by year, quadrant, school, and level. Compare Weighted Enrolment vs School Capacity, and see the resulting Utilization Rate (%) over time. The white dotted line in the trend chart is a context-aware Average Baseline for utilization.

Tech Stack: Power BI SQL/ETL Oracle Power Query
Focus: Education CBE Capacity Utilization

Dashboard

Data refresh: Oct, 2025

What you’re seeing: a map of schools and a time-series that tracks Weighted Enrolment, Capacity, and the Utilization Rate. Hover to view tooltips with per-school utilization percentages.

How to read & interact

  • Map: bubble area reflects school_capacity (or weighted enrolment depending on the active view).
  • Trend: the teal line is Utilization Rate (%, average across the filter context).
  • Use the year slider and quadrant toggles to focus on a region or time window.