ISM-5150 Tableau Activity Version 1.0
Tableau Police Killings 2013-2020+
In this exercise you are playing the role of an analyst at one of the major news organizations in the United States.
Today there was another police killing/shooting and your boss needs detailed information on police killing from 2013 through 2020. This MUST be accurate as it will be used by the news reporters in their articles/news casts. Retractions are not acceptable!
Instructions: Just like you did in the Tableau Lab example this week, use the data file, “Killings by Police.xlsx” (found along with this assignment in Canvas) to answer the following questions.
10 Questions, 10 points each
Exercise #1
Using “for lines” chart, what state shows the highest number of police killings? What was the amount?
Hint: Drag “2013-2020 Police Killings (Count)” to Rows, drag “Date of Incident” to Columns. You now have a screen that looks like this:
Something isn’t right! Why is there a big drop-off in 2021? If you look at the data in the Excel file, you’ll see that there are only a few months of data in 2021, and since you’re being asked for data from 2013 through 2020, you need to filter out 2021.
Hover over YEAR (Date….) in the columns area. On the right side, click the dropdown arrow, go to filter and uncheck 2021. Apply and say OK. You will now see you line chart more level and 2021 is gone.
But we’re looking for states, so drag States to Columns. Note the chart changes to a bar chart automatically. Click the
button to change the orientation, then click the sort button to sort from high to low.
If you’re showing individual years, drag State on top of “Date of Incident”.
If you now drag “2013-2020 Police Killings (Count)” to the Label box, you’ll get the values for each state.
Put your answer here. What was the Amount? ________________
Show your work with a screen shot here:
Exercise #2
Using a pie chart, show how many males AND females died in this time-period. Be sure to label your chart with the sex and the number that died. How many females died during this time-period?
1. Place your answer here. ___________________
2. Place your screen shot here.
Exercise #3
There were various ways that people were killed. No doubt, gunshot was the #1 cause. Using a horizontal bar chart, how many died by beating? (Note, there are 2 lines of beating, add them together).
Place your ANSWER here: ______________
Place your screen shot here.
Exercise #4
Using a Treemap, what city in Florida had the most deaths? What was the amount?
Place your answer here ___________________________
Place a screen shot here.
Exercise #5
Using a packed bubble chart, display in color and with labels show the Armed/Unarmed status of the victims. How many were shown as “Unarmed”?
Place your answer here ___________________________
Place a screen shot here.
Exercise #6
Using a line chart, what year saw the most use of body cameras? How many were used that year?
Place your answer here ___________________________
Place a screen shot here.
Exercise #7
Using any chart, what year saw the least off duty killings? How many were there that year?
Place your answer here ___________________________
Place a screen shot here.
Exercise #8
Using any chart, of all the “Initial Reported Reason for Encounter”, what was the SECOND most deadly encounter? HINT: Domestic Disturbance was number one.
What was the SECOND most deadly encounter, and what was the amount?
Place your answer here ___________________________
Place a screen shot here.
Exercise #9
Using a packed bubble chart, how many were killed while fleeing?
Place your answer here ___________________________
Place a screen shot here.
Exercise #10
Using a bar chart, show how many were killed by race. How many Asian’s were killed during this time-period?
Place your answer here ___________________________
Place a screen shot here.
©2021 Dr. Ed Lindoo Nova Southeastern University
image4.png
image1.png
image2.png
image3.png