For the Data Geek Challenge, we collected crime data from 2008-2013 from a selected city with a population of approximately 600,000. The data included metrics such as type of crime, number of occurrences, and date. A screenshot of this data is included below.
Our first visualization was a stacked column chart showing number of different crimes by month. The data showed that total crime decreased in the winter months.
Next, we wanted to compare the frequency of crimes based on seasonality. To do this, we created 2 pie charts, each of which was filtered by either the summer or winter months. Screenshots of these visualizations are included below.
Through observing the similarities between these two pie charts, we determined that although overall crime decreases during the winter months, the frequency of particular types of crimes doesn’t significantly change during different types of the year. Using SAP Lumira, we were able to track this trend and other hidden relationships embedded within the data.
Kelly and Rasshmi