Calgary Insight

Data Scientist: full analysis reports on Calgary and any ward

Data Scientist writes complete, sourced reports from live public data: every figure worked out from the data itself, with charts, maps, findings, recommendations and an action plan. A second step, the report auditor, checks the figures and the reasoning before you read it.

What you get

How a report is made

  1. Gather the data: the right public datasets for the question, for the area chosen
  2. Work out the figures: calculated from the records themselves, not estimated
  3. Draw charts and maps
  4. Write the report: findings in plain words, each figure with its source
  5. Audit: a separate check of the numbers, the method and the conclusions

Reports it is built for

Sample study: Who Calgary’s 311 Hears

Two years of 311 requests across 195 communities show the City closes requests equally fast everywhere, but hears about 23% fewer infrastructure reports where more residents don’t speak English, even comparing like with like. The study sets out the findings, Ward 5 adjusted for growth, twelve recommendations and its limits.

Read the study in brief →

Sample report: Calgary’s ageing sewers, and how long sewer pipes last around the world

Made by the Data Scientist from the City’s open data on all 368,085 public sanitary service connections: how old they are, what they are made of, how that compares with service lives used by utilities in Canada, Australia, the UK and Germany, where back-ups happen most, and what renewal would take. The full 18-page report, as published, with its charts, map and workbook.

Read the report →

Sample: Ward 5 in brief

Ward 5 has 148,122 residents by the City’s estimate. It had 33,015 311 requests in Nov 2025 to Oct 2026, 198 per 1,000 a year, and 4,731 requests are still marked open, 3,965 of them for over 90 days. Police recorded 2,496 crimes, 17.0 per 1,000 residents (up 15.5% on the year before). Communities with the most open requests:

A full report adds trends since 2021, maps by community, comparisons with Calgary, findings, recommendations and an action plan, as a PDF with an Excel workbook of every figure.

Who it is for

Ward offices and City staff, community associations, journalists, non-profits and researchers. Reports take about 3 to 8 minutes.

How to use it

Data Scientist is on the dashboard under Ask the data. Making reports needs an approved account: sign in with Google, or use the passcode you were given. To ask for access or a report, write to hello@calgaryinsight.ca.

Open Data Scientist

Data Genie: quick answers · Ward 5 · All wards · All communities

Where the figures come from

311 requests: The City of Calgary, 311 Service Requests open data (data.calgary.ca, iahh-g8bj), the last 12 complete months against the 12 before. Crime: Calgary Police Service, community crime statistics, the latest 12 months the police have published. Residents: City's total, shared by actual growth, with the 2021 Census count beside it. New homes and permits: City of Calgary building and development permit open data. Rates per 1,000 residents a year use residents in the middle of each period.