YYC-Wander

In my journey through the urban landscape

Home → Civic & Social Analytics → CBE School Enrolment

CBE School Enrolment (Calgary 2019–2024)

Filter by year (2019–Now), quadrant (N/NW/NE/SW/SE/Unique), school and level (Elementary, Junior, Senior). The map shows school locations with bubble size proportional to total enrolment; the line chart tracks annual trends, with a white dotted line as a context-aware Average Baseline.

Tech Stack: Power BI SQL/ETL Oracle Power Query
Focus: Education CBE School Enrolment Quadrant

Dashboard

Data refresh: Oct, 2025

What you’re seeing: a bubble map of school locations sized by total enrolment, and a year-over-year trend chart. Use the level toggles to focus on Elementary, Junior, or Senior schools and compare patterns across quadrants.

How to read & interact

  • Map: bubble area ∝ ENROLMENT_CNT; pan/zoom or lasso-select to focus on an area.
  • Trend lines: the white dotted line is the Average Baseline within the current filter context.
  • Filters: year slider, multi-select quadrant, school dropdown, and level checkboxes (Elementary/Junior/Senior).