YYC-Wander

In my journey through the urban landscape

Home → Public Health Analytics → Acute Substance Deaths — Overview

Acute Substance Deaths — Overview (Calgary 2016–2025)

City-wide analysis of acute substance-related deaths since 2016 — quarterly and monthly trends by substance type, with seasonality and policy context to highlight turning points.

Tech Stack: Power BI SQL/ETL Oracle
Focus: Mortality Trends Substance Types Seasonality

Acute Substance Deaths — Overview

Data Updated On Oct, 2025

Context: Shows mortality levels, turning points, and relative shares by substance group (e.g., opioids, methamphetamine, alcohol). Use filters to compare “Any Substance” with specific categories and to examine changes across time.

📌 Interpretation Tips

  • Quarterly lines show the overall trajectory of mortality; short-term spikes can reflect reporting cycles or one-off events.
  • Compare “Any Substance” with individual types (opioids, methamphetamine, alcohol, etc.) to identify which groups drive most of the change.
  • Overlay policy periods or known public health interventions when interpreting turning points in the trend.