YYC-Wander

In my journey through the urban landscape

Home → Housing Market Insights → Avg Household Size

Avg Household Size | Calgary (1964–2025)

Based on annual residents (P_RESIDENTS) and dwellings (P_DWELLINGS), this dashboard tracks Calgary’s average household size over time and highlights structural turning points where population growth runs ahead of housing supply.

Tech Stack: Power BI SQL/ETL Oracle
Focus: Household Size Population Dwellings

Avg Household Size — Long-Term Trend (1964–2025)

Data refresh: Oct, 2025

Method: Avg Household Size = P_RESIDENTS / P_DWELLINGS. The chart also shows population and dwelling curves so you can see when people grow faster than homes — a signal that average household size is likely to rise and housing pressure is building.

📌 Context

  • From the late 1960s to the mid-1990s, average household size declined steadily as families became smaller and single-person households grew.
  • Since around 2020, the metric has turned upward, likely linked to strong immigration, higher housing costs, and more shared living arrangements.
  • Compare P_RESIDENTS and P_DWELLINGS: when population growth outpaces housing growth, Avg Household Size tends to rise, signalling tighter housing conditions.