1 / 17

Saint Louis Police Department BI Implementation Proposal

Saint Louis Police Department BI Implementation Proposal. Ben Shailesh Spencer Will. Overview. Why provide BI solutions for STLPD? To help prevent and solve crimes Provide solutions to… Store and manage data Analyze data Present data (dashboards) Then, they can act on that data

ellema
Download Presentation

Saint Louis Police Department BI Implementation Proposal

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. Saint Louis Police Department BI Implementation Proposal Ben Shailesh Spencer Will

  2. Overview • Why provide BI solutions for STLPD? • To help prevent and solve crimes • Provide solutions to… • Store and manage data • Analyze data • Present data (dashboards) • Then, they can act on that data • Help make more effective decisions and save resources, where possible

  3. Decisions Supported By BI • Number of Patrolmen per Police District -fluctuates as crime increases in any one of the 9 districts. • Patrol Routes within each Police District • General Placement of Police Officers within each district. • Increase funds Allocation based on districts with the most crime. • Increase funds for youth group efforts to fight drug and gang activity

  4. Suggested Data to be Maintained • Types of crime per area • Crime by Gang or Non Gang affiliation, if gang affiliated which gain committed crime • Demographics about individual crime perpetrators and the victims • 911 call/dispatching data • Linking FBI data to local crime data for more accurate predictions • Social networking data • Police patrols and arrests • Weather forecasting

  5. Kinds of Analytics to Provide • Crime patterns/trends • Location of crimes • Predictive analysis for proactive policing, costs, staffing, crime predictions • Equipment/training costs per unit and the projected reduction in crime for the patrol area gained by this

  6. Dashboards • Patrol Dashboard • EIS Dashboard for Chief of Police or other police department executive decision makers • Same system with different login in access depending on the individual accessing the system

  7. Patrol Dashboard

  8. Patrol Dashboard • Hotspot Map • Drill Down Capability for detailed info • On Hover over – • Neighborhood info appears • Real Time Updating of map data

  9. On Drill Down Actual Crime Data Appears

  10. Ability of Patrol Officers and Chief of Police to Leave Notes

  11. Executive Dashboard

  12. Executive Dashboard

  13. Executive Dashboard

  14. Executive Dashboard

  15. Cost Considerations • St. Louis Police Department under fiscal pressure due to rising pension costs • Operating budget decreased by $10 million between 2012 and 2013 • According to Program Budget 650-02 (Chief of Police division, which includes IT) the budget for FY2013 was $12.5m, up from $10.6 in FY2012

  16. Cost Considerations (cont'd) Based on these numbers, we set an upfront budget of $60k, with an annual budget of $10k for enhancements/maintenance - 80 hours * $100/hr -> research - 150 hours * $100/hr -> data mining - 200 hours * $100/hr -> programming - $5,000 -> hosting/equipment - $12,000 -> reserve for add'l costs

  17. Questions • Questions? Ask Will

More Related