Situation: The St. Paul police department in Minneapolis, U.S.A, came to the limelight since the killing of
Question:
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
Expert Answer:
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 ... View the full answer
