The Calgary Crime Statistics Dashboard – updated

The Calgary Police Commission released its 2015 citizen survey results, in which they conclude that the Calgary police is highly valued and do an excellent job (see report here). As I have a lot of respect for the “(wo)men in blue” and the job they do I can relate to many findings in the report, but there was also a finding that struck me as odd: “One-half of Calgarians feel that crime has stayed the same over the last twelve months“. Of course this survey is about perception and not facts and numbers, and one cannot expect that all surveyed people are highly aware of their city’s crime statistics. But as someone in the middle of doing some analysis and visualization of those datasets, I wanted to share the crime statistics in a visual and easily consumable way. The dashboard unfortunately shows that crime incidents have strongly increased in 2015, with almost 16,000 crime incidents in 2015 until July (so seven months) compared to just under 19,000 incidents in 2014 (full year).

The dashboard is available on Tableau Public here (or click image below). As the embedding of Tableau Public dashboards in WordPress blogpost leaves a lot of room for improvement at this point the dashboard is not available in this post.

Calgary Crime Statistics Dashboard header

Before drawing any conclusions please have a look at the dashboard and read the Introduction and The data section.

Calgary Crime Statistics data visualized

Calgary provides police reports on the city crime statistics, but they are not easily consumed. With Tableau Public I have tried to provide insight in these statistics in the following dashboard.
Calgary Crime Statistics Dashboard

Although Tableau Public has an embedding function, WordPress doesn’t appear to like it as the result was appalling. So for now, viewing the dashboard works best by going through Tableau website itself, linked above.

It shows general crime trends, details per community, year and category,
CrimeIncidentMap
the crime-to-population ratio for communities,
Crime population ratio
and allows users to compare up to three communities:
Comparing crime between communities

I am happy that the city makes this data available, but I would hope they did so in a more readable and usable format. I hope this dashboard will help exposing this data to the people in Calgary.

Automate the boring stuff with Python

Automate the boring stuff with Python is an online book (it can also be purchased here or at Amazon) that explains Python at a beginner’s level for practical use.

There are also videos available by the author, that cover the books content: on Youtube you can find the first 15 or so, but all of them are available through Udemy.com. And the good part is, those are now available for free with coupon code BORING_FOR_FREE, I believe until October 2oth or so.

So if you are new to Python (or like me have used it eons ago and need a big refresh) and want to get to know it and learn how to use for practical tasks, this might be the book for you. And all it takes is an internet connection and for the videos you will have to create a Udemy account.

I just wanted to state I am not affiliated to the book, not do I even know the author. But when someone provides good content for free I believe it is worth sharing.

[Automate the boring stuff with Python]