Analyzing Crime in Boston (Pre and Post COVID-19) Using SAP Data Warehouse Cloud and Analytics Cloud
Last week, I wrote a blog to understand the spread of COVID-19 in Boston and the overall effectiveness of their preventative treatments to help curb the spread. Based on this analysis, my natural next question was to understand the social impact of our shelter-in-place orders. This lead me to wanting to analyze the impact that COVID-19 is having on crime rates. The City of Boston publishes all of their crime data and mass.gov publishes all of their COVID-19 data.
For this analysis, I used both SAP Data Warehouse Cloud and SAP Analytics Cloud to see where the data would take me. For those of you not familiar, SAP Data Warehouse Cloud is SAP’s newest enterprise class cloud Data Warehousing solution. It allows you to easily connect, join, and wrangle data together and SAP Analytics Cloud, which is nicely integrated into Data Warehouse Cloud, allows you to ask-and-answer any question in this newly procured data set.
Using SAP Data Warehouse Cloud, I was able to easily combine this crime data with my COVID-19 data model that I had created last week. Starting from the easiest-to-hardest questions, here’s what I found…
How many police “incidents” occurred in Boston?
The data set includes all incidents from 2016 and beyond. If you look at the average number of police incidents, you can see that 2020 has a sharp decrease from previous years. 13.5% decrease, to be exact.
If we drill down by month, we can see a sharp dip in March, April, and May – compared to the same periods in prior years.
And if we wanted to see a longer month-over-month trend, we can easily see that while there’s a lot of seasonality to crime incidents, the last three months have been true outliers.
And finally, if we super-impose the number of new COVID-19 cases with the total number of incidents, we can see an interesting trend, in that these lowering crime rates coincided with the rise of COVID-19 cases.
Where and When are these incidents occurring?
Not surprisingly, we can see the same downwards trends across all police districts…
Across all days…
And all times.
So, at an aggregate level, our shelter-in-place orders have dramatically lowered our crime rates. But have they?
Where Has Crime Gone Up?
Below are three charts. The one on the left shows the average number of daily incidents over the past 4 years. The one in the middle shows the average number of daily incidents since March 1st. And the one on the right shows the incidents that have increased the most.
Another way to visualize the data is the following. What’s most disturbing is that the incidents that have increased the most (aside from medical assistance) are all assault and disputes related incidents – that pop off the screen.
What Data Variables Lead to Violent Crimes?
The last interesting nugget is that I wanted to use some augmented analytics capabilities to understand which variables lead to higher and more violent crimes – to make our analysis and our conclusions more relevant. Using SAP’s advanced analytics capabilities, I ran a classification algorithm to see which variables (or columns in our data set) were most likely to lead to these types of crimes. In the visual below, we can see that the reporting area, time of day, and street are the three most important variables.
recommending to analyze.
What does this mean?
Data is everywhere and all around us. But without analytics, data is just data. Turning data into analytics with tools like SAP Data Warehouse Cloud and SAP Analytics Cloud helps arms you with actionable information to make better and more informed decisions. For the City of Boston, it can provide a more meaningful way to publicize and to provide transparency into all of the good work that these brave men and women are doing to serve the public.
Want to learn more?
Use the comments sections to ask questions and learn more…