YYC-Wander

In my journey through the urban landscape

HomeCrime & Disorder Insights → Calgary Crime — Community Trends

Calgary Crime — Community Trends | Calgary (2017–2024)

Community-level patterns to inform local prevention and resource allocation — interactive filters by police area, neighbourhood, offence category, and time.

Tech Stack: Power BI SQL/ETL Oracle
Focus: Community Safety Hotspots Time Series

Community Crime Dashboard

Data Updated On Oct, 2025

Context: Track trends by community and offence type to spot hotspots, seasonality, and changes that may guide prevention efforts and deployment across Calgary neighbourhoods.

>

📌 Interpretation Tips

  • Compare communities within the same police area first to avoid cross-area bias.
  • Use the category treemap to see which offences dominate each community and how that mix changes over time.
  • Watch for abrupt changes around policy or seasonal events (e.g., holidays, school breaks) to contextualize spikes.