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
- A report as a PDF, ready to print or send
- Interactive charts and maps
- An Excel workbook with every figure behind the report
How a report is made
- Gather the data: the right public datasets for the question, for the area chosen
- Work out the figures: calculated from the records themselves, not estimated
- Draw charts and maps
- Write the report: findings in plain words, each figure with its source
- Audit: a separate check of the numbers, the method and the conclusions
Reports it is built for
- How have vehicle thefts and break-ins changed in each community since 2021, with recommendations
- Where are 311 requests taking longest to close, and which kinds
- A briefing on a community before a town hall or council meeting
- Growth and new housing against services in a ward
- Your own question, described in plain words, with the visuals you want
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.
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.
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 ScientistData 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.