Gun Violence Report – USA 2013 to 2018

Posted byRakesh PalPosted inreportTags:, , , , ,

By Rakesh Pal

Gun Violence Report – Excel fileDownload

I wanted to produce a report from a gun violence dataset i found online: https://github.com/jamesqo/gun-violence-data (Thank you to Jamesqo for creating the dataset)

The dataset contains over 260k of gun violence incidents in the USA, from 2013 to 2018. I wanted to analysis and present the data, asking the following questions –

Metrics:

  1. How many deaths and injuries occured per state?
  2. How many mass shootings occured?
  3. Which age group accounted for the most suspects/victims?
  4. Which type of weapon was most commonly used and by which age group?
  5. What percentage of weapons were stolen?
  6. And so on…

Our Goals:

  1. Load, clean, and modify the dataset
  2. Build Dimension Tables / Create Relationships
  3. Create DAX formulas
  4. Make use of PivotTables, PivotCharts, Data Slicers, Conditional Formatting, Colour Scales, to present our data.
  5. Create Visualisations that are clear and easy to understand.

Metrics by State

Metrics by State

Filtering the data to California. We can observe how this state differs from the average state in the USA.

Participant Type by Age Group

Which age groups were the most common per State for Suspects and Victims?

Gun Type Metrics

Various Gun Type Metrics

Please download the Excel file to see more Metrics.

I don’t currently have time to create a detailed write up of how the Report works, though i plan to do so in the future.

Leave a comment