Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Situation: The St. Paul police department in Minneapolis, U.S.A, came to the limelight since the killing of George Floyd back in May of 2020 that

Situation: The St. Paul police department in Minneapolis, U.S.A, came to the limelight since the killing of George Floyd back in May of 2020 that sparked the #BLM (Black Lives Matter) movement in the US and around the world against police brutality. The data provided shows police arrests made from the years 2001 - 2016. Since February has been designated as Black History month, your boss has asked your team to investigate this data that has been discovered from the St. Paul's police department. He wants to know whether there was any systemic racism in the police force against people of color (non-white). Based on your understanding of Tableau Software and Data Visualization for data-driven decision making, provide a clear picture to the board members on what is going on in this department. Your team need to present to the board and do a demo with Tableau to highlight your findings.

Requirements: Use the data provided to build charts and dashboards for a visual presentation of the incidents and police stops in that department. Use ONLY data from 2009 - 2016 for your analysis. Clean the spreadsheet before processing by removing all records from 2001 through 2008, and those that don't have data on Race of Driver field. Transform the fields in Tableau to your liking for easy reading and presentation of data. Demonstrate critical thinking, highlight any trends, and present this data in a clear Dashboard to the board members of your company using sophisticated graphs and filters. Use at least 6 different charts/graphs for your presentation including Area Charts, and Maps. Submit a PowerPoint Presentation of your report, and Tableau file. Presentation Requirements: All team members must present. The maximum length of the presentation is 15 minutes. Reserve 3 minutes for Q&A. The presentation may be recorded during the demonstration. Presentation must include: o Introduction o Agenda o Content o Conclusion on your findings o Must provide a demo of the findings using Tableau Software

Step by Step Solution

3.32 Rating (158 Votes )

There are 3 Steps involved in it

Step: 1

Data Analysis Steps 1 Data Cleaning Open the dataset containing police arrest data from 2001 to 2016 in St Paul Filter out records from 2001 to 2008 Remove rows where Race of Driver data is missing 2 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Marketing An Introduction

Authors: Gary Armstrong, Philip Kotler

15th Edition

0137476450, 978-0137476459

More Books

Students also viewed these Law questions

Question

2. Darwins notes in biology.

Answered: 1 week ago

Question

Calculate the purchase price of each of the $1000 face value bonds

Answered: 1 week ago