Skip to Content
Author's profile photo Former Member

Data Geek Challenge

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

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Jitendra Kansal
      Jitendra Kansal

      Hi Kelly,

      may i know for which city (in which country) this analysis has been done?



      Author's profile photo Former Member
      Former Member

      Kelly & Rasshmi,

      Thanks for the great post!

      In addition to Jitendra's question above, would you be able to also include where you got the data from?

      Thanks, and good analysis!