1 / 21

BI Analysis Project May 6, 2013

BI Analysis Project May 6, 2013. Group E: Yao Zhang Shih- hua Chen Teng Ma. Overview. Data . What data to collect? Percentage of total police staff on active crime duty the average and total street time per police officer Distribution of crime duty officers by area

lonato
Download Presentation

BI Analysis Project May 6, 2013

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BI Analysis ProjectMay 6, 2013 Group E: Yao Zhang Shih-hua Chen Teng Ma

  2. Overview

  3. Data • What data to collect? • Percentage of total police staff on active crime duty • the average and total street time per police officer • Distribution of crime duty officers by area • Average time to complete a crime report • Percentage of officers who attend regular firearms practice and the percent who fail the annual fire arms qualification test • Crime rate by district and by crime • Case resolution rate • And more • Data quality MATTERS！ • Cleaning up data to get rid of duplications i.e. multiple 911 calls regarding the same incident • Using uniformed rules on terminologies to retain consistency Source 12

  4. Flow Chart of Investigation & what role BIplays BI Tools CAD Cleaning ETL data mining Analysis Report No JMS Yes Court

  5. WebFOCUS Platform-City of Irving overtime 60% gunshot incidents 80% JMS CAD Courts RMS Category of Calls Auto theft Rubbery Homicide Burglary complain City Database WebFOCUS Platform ex. Aggregation of crime Category of crimes Police distribution… Daily crime summary Graphic reports (d-map) Suspects have been interviewed or apprehended? KPIs Detectives, etc. Supervisors & Chief Officers Actions should be taken Source 10

  6. BI in Social Network Facebook Movement Communication Dislike and favorites Uploaded information Shared information twitter NLP? RIOT database IAT? foursquare gawalla analyze FBI NLP: neutral language process IAT: image authentication techniques Source 11

  7. Image Authentication Technologies Metadata Analysis Source 8

  8. RFID and Firearms Control Source 9

  9. 911 Dispatcher Interface Functions • Incident information to find relations with prior incident happened in the same place • E911 interface to display caller ID and location • Location verification – Geofile • Information files • Unit display of available units such as K-9 and SWAT teams. • Incident dispatch – to connect incident(s) with units. • Incident display i.e. Priority code • Timestamping • Special features • Report generation Source 3

  10. Source 1, 4

  11. 911 Dispatcher Dashboard Sign In Tool View Help Exit • Current Active Calls • #0003 on 5/3/13 at 15:53 314-464-0221 Unpark • #0002 on 5/3/13 at 15:52 314-555-0011 134 Lewis St. Line 6 • #0001 on 5/3/13 at 14:25 314-772-3215 Dispatched Line 3 • #0004 on 5/3/13 at 14:13 Disconnected Redial • #0005 on 5/3/13 at 13:22 314-297-5555 Dispatched • #0006 on 5/3/13 at 12:09 314-050-5166 Ended • #0007 on 5/3/13 at 11:27 314-257-5641 Ended • #0008 on 5/3/13 at 10:47 314-543-2594 Ended • #0009 on 5/3/13 at 10:29 314-564-5674 Dispatched • #0010 on 5/3/13 at 09:12 Disconnected Redial Dispatch Units Hold Transfer End Call - + + - + - - + - Preston Broadus 314-555-0011 1234 Lewis St. St. Louis, MO 63102 District 4 Webcam 10 + - District4 Connect Dispatch 1 Mile 1.2 Miles 0.8 Mile 2.5 Miles Idle

  12. Police Chief Dashboard Sign In Tool View Help Exit Scorecard Organized Crime Key Person Relationship More Crime Types Show Patrol Vehicles Show Other Units Show Related Incidents Other Mapping Options Full Screen

  13. Sample Scorecard Average Time Needed to Arrest the Homicide Suspect by Patrol Division (in days) Central North South North Central South

  14. KPIs: • Number of Homicide by District • Number of Patrol Officer • Number of Officers on Active Case Number of homicide in 2011 Source 5,6

  15. KPIs: • St. Louis City Homicide • Homicide Clearance Rate Source 5, 6

  16. KPIs: • Number of Homicide • Homicide Rate • Population Source 5, 6

  17. KPIs • Percentage of total patrol officers by patrol division • Percentage of total police staff on active crime duty • Percentage of officers who attend continuing training • Percentage of officers who attend regular training & pass the exam • Percentage of total homicide by patrol division Source 5

  18. KPIs: • Average time needed for the police to completing a report by control division

  19. Suggestions • Pay great attention to data quality! Cross examination can reduce error in data. • Construct a data network and data warehouse. Apply data warehousing models such as OLAP or Star Schema to store data. Doing so will promote easy access of data by multiple users. • Using a dynamic dashboard to deliver data to end users. • Data flows DO NOT end at end users. Any new inputs will go through the data life cycle again until properly stored. • Always keep an open mind for new technologies.

  20. Work Cited The Security Dialogue. (March 9, 2013) INTERVIEW: Guardly Offers Insight Into Indoor Positioning System and The Future Of Emergency Dispatchhttp://blog.thesecuritydialogue.org/2013/03/interview-guardly-offers-insight-into.html Dispatch Magazine On-line. Computer-Aided Dispatch Software Resources. http://www.911dispatch.com/info/cad/ Dispatch Magazine On-line. (September 30, 2011) Graphic Design Firm Tackles Dispatching Interfaces. http://www.911dispatch.com/2011/09/30/graphic-design-firm-tackles-dispatching-interfaces/ Baumgardt, J.. (2009). Case Study: 911 Dispatcher Interface Demo. IdentityMine. http://www.identitymine.com/forward/2009/08/case-study-911-dispatcher-interface-demo/ St. Louis Metropolitan Police. Crime Statistics 1982-2012. http://www.slmpd.org/crime_stats.shtml St. Louis Metropolitan Police Public Information. Annual Reports 1999-2011. http://www.slmpd.org/press_room.shtml Mansurov, N. (2010). How to remove EXIF Data. http://photographylife.com/how-to-delete-exif-data Forensic Science Communication. (April 2008). Best Practices for Image Authentication. Scientific Working Group on Imaging Technology (SWGIT). Vol. 2. http://www.fbi.gov/about-us/lab/forensic-science-communications/fsc/april2008/index.htm/standards/2008_04_standards02.htm SkyRFIDInc. (n.d.) RFID Weapons Management. http://www.skyrfid.com/RFID_Weapons_Management.php WebFocus. (n.d.) Customer Profile – City of Irvine, CA. https://www.informationbuilders.com/sites/www.informationbuilders.com/files/pdf/applications/city_irving.pdf The Guardian. (2013). How Raytheon software tracks you online – video. http://www.guardian.co.uk/world/video/2013/feb/10/raytheon-software-tracks-online-video Chinn, D. (n.d.)Key Performance Indicators for the Police. http://www.ehow.co.uk/info_8055974_key-performance-indicators-police.html

More Related