Monday, 23 January 2017
Crime and weather a curious insight
I had a few days between projects, so spent the time getting a bit more familiar with Power Query. I have used crime data to animate a Thermal Map in Power Maps before Here. But I was playing around with Azure Data Market to access the freely available data sets, one of which was the UK Met office weather data to look at animating weather using Power Map. Then i had a bit of a brain wave, I had two data sets, that matched time and space and had a look to see if the weather affected crime. The above graph indicates that the number of Anti Social Behaviour incidents follows the temperature. This isn't a deep statistical analysis, just a quick eyeball of the flow of the graphs but it is suggestive that something is going on for 2012 at least.
Subscribe to:
Post Comments (Atom)
-
SSIS normally has out of the box most things you need to get the job done, however sometime a client comes along with a data source that re...
-
Millions, millions of dead people are voting! said Trump. Well for starters, they aren't voting, despite the claims, however they will b...
-
I’ve been doing a bit of work for a global company who are SAP based. They use the BW solution and they are moving to the SAP HANA data...

No comments:
Post a Comment