law enforcement analytics milwaukee county sheriff’s office captain brian barkow...
TRANSCRIPT
![Page 1: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/1.jpg)
Law Enforcement AnalyticsMilwaukee County Sheriff’s Office
Captain Brian [email protected] Law Enforcement Analytics Division (L.E.A.D.)Milwaukee County Sheriff’s OfficeMilwaukee, Wisconsin
![Page 2: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/2.jpg)
Captain Brian M. Barkow Biography
Captain Brian Barkow was appointed to the Milwaukee County Sheriff's Office in September of 1997. He was promoted to the rank of Sergeant in August of 2006. In March of 2009, Sheriff David A. Clarke Jr., promoted him to the rank of Captain.
Currently, Captain Barkow commands the Law Enforcement Analytics Division (L.E.A.D.), which provides tactical, operational, and strategic analysis for the agency. L.E.A.D., a highly innovative division, utilizes the nationally recognized COMPSTAT model in analyzing data, crime trends, and tracking resource and performance accountability in all Sheriff’s Office operations by utilizing state of the art business intelligence software.
In March 2009, Captain Barkow was assigned to the Criminal Investigations Division where he oversaw the operations of the General Investigations Unit, Special Investigations Unit, Background Investigations Unit, Drug Enforcement Unit, and all agency Task Force assignments.
In 2004, Captain Barkow earned a Bachelor of Science degree in Computer Engineering from the University of Wisconsin-Milwaukee. Captain Barkow is a 2008 graduate from the Future Milwaukee Leadership Training program at Marquette University. Captain Barkow is a recent graduate of the National Institute of Justice Law Enforcement Technology Institute. Captain Barkow serves on several committees in Milwaukee County that promote the technical advancement of the criminal justice system and is a current member of the Professional Crime Analysts committee at the University of Wisconsin – Milwaukee.
![Page 3: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/3.jpg)
Speaking Points
• Why Analytics??
• Current Implementation: A.R.M.E.D. powered by Information Builders’ Law Enforcement Analytics System - CompStat and Business Intelligence Dashboards
• Future Initiatives
![Page 4: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/4.jpg)
“Profiting from your most important business asset”
– Thomas C. Redman – author of Data Driven
Migration to “Intelligence-Led” policingProactive rather than reactive
Visualization of Incidents, Patterns, and Trends.
Management of Resources Evidence based tactics and strategies Interagency Data and Intelligence sharing
“Best Practices”
![Page 5: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/5.jpg)
Increased ProductivityAutomate CompStat Reporting ProcessCommand Staff resources focus on
analyzing operations
Efficiency and AgilityInformation Alerts and Triggers Enable enterprise wide information access
Reduce Decision-Making Cycles Quickly recognize important trendsDecisions based on current and credible
informationProvide actionable information
![Page 6: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/6.jpg)
Return on Investment-Case Studies
Improved Data Models
Informed Decision Making
Increased Productivity and
EfficienciesCost Savings $$$$$$$
Data preparation Civil Process Mapping Officer Assaults
![Page 7: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/7.jpg)
Speaking Points
• Why Analytics??
• Current Implementation: A.R.M.E.D. powered by Information Builders’ Law Enforcement Analytics System - CompStat and Business Intelligence Dashboards
• Future Initiatives
![Page 8: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/8.jpg)
Analyze Data
Review Findings
Mobilize Resources
Evaluate Performance
Document Results
© 8/1/2011
![Page 9: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/9.jpg)
Organizational Challenges Budget Constraints Limited resources; unlimited issues Data silos or “islands”
Inter-agency and intra-agency Disparate Data Sources
Hard and Soft DataHome Grown and Ad Hoc
Operational Inefficiencies Outmoded and Redundant Operations/Systems Data Integrity and Governance
![Page 10: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/10.jpg)
Data Silos
Patrol Services
Court Services RMSJails CAD Budget/
FinanceScheduling
Investigative Services
Inter-agency
Intra-agency
![Page 11: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/11.jpg)
Milwaukee County Sheriff’s Office (MCSO) Data Sources
Hard Data – Data that is available in an MCSO Data Base
Soft Data– Data not available in an MSCO data Base– Typically tracked on paper
Copyright 2007, Information Builders. Slide 11
Paper Templates
Typed into Excel Re-Typed and/or Linked into Excel
Hand Written
Data Collection Templates
Data Aggregation
Re-Typed and/or Linked into Excel
Templates
COMPSTAT
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
![Page 12: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/12.jpg)
Disparate ‘Hard’ Data Sources
“CJIS” Criminal Information Application Phoenix Records Management System Positron Computer Aided Dispatch Airport Dispatch (Access Data Base) Badger Tracks Ceridian Payroll Transit Data BRASS Jail Activity Tracker Staff Management Excel Spreadsheets A variety of Division controlled SQL and Access
structures
![Page 13: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/13.jpg)
Home Grown “Soft” Data Sources Daily Activity Sheets Log Sheets Shift Summaries Risk Management Total Personnel Time Analysis Complaints (IA) Overtime Analysis Etc.
![Page 14: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/14.jpg)
Organizational Approach
Simplify
Standardize
Centralize
Data Cleansing and Interrogation
Data Systems Data-mart
Reporting Dynamic Data Entry App
Data Entry Real time reporting
![Page 15: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/15.jpg)
Current Implementation• CompStat Reporting System• Interactive Mapping of Incidents, Calls for
Service and Civil Process activities• Dashboard with KPI’s & drill-downs• Data Analysis and Operational Dashboard
Phased Deployment
23
2
1
3 Future Phase 3 Predictive Analytics Inter Agency Information
Exchange
1
Start
Future Phase 2 Ad-Hoc reporting Triggers and Alerts Custom Operational Reports
Using wave investment planning to roll out in phases
![Page 16: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/16.jpg)
Law Enforcement Analytics Centralized reporting & performance
management solution with CompStat based reportsKey Performance Indicators (KPI) reportsManagement and Operational Dashboards with drill-
downsIntegration for data connectivityInteractive Mapping CapabilitiesData MiningEnterprise Information Search
Information exchange with other agencies and jurisdictions
![Page 17: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/17.jpg)
MCSO CompStat Dashboard
![Page 18: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/18.jpg)
All CompStat Reports Have Drill Downs into WebFOCUS Active Reports
![Page 19: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/19.jpg)
Active ReportsGenerate Graphs and Reports Which Can Be Emailed
![Page 20: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/20.jpg)
Performance Indicators Report
![Page 21: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/21.jpg)
Performance Indicators - Pay TypesShowing Active Report With Pie ChartReports output into HTML, Excel, PDF or Active Report
![Page 22: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/22.jpg)
Overtime and Off Time ReportsWith graphic indicators
![Page 23: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/23.jpg)
Risk Management Report
![Page 24: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/24.jpg)
Incident Calls For Service Interactive Mapping
![Page 25: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/25.jpg)
Drill Down From Map to Incident Report in RMS
![Page 26: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/26.jpg)
Dynamic Data Entry ApplicationCreating forms online
![Page 27: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/27.jpg)
Dynamic Data Entry ApplicationCreating forms online
![Page 28: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/28.jpg)
![Page 29: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/29.jpg)
![Page 30: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/30.jpg)
Access to Phoenix from the Dashboard
![Page 31: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/31.jpg)
Data AnalysisIncidents from the RMS system for the last 7 days
![Page 32: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/32.jpg)
Speaking Points
• Why Analytics??
• Current Implementation: A.R.M.E.D. powered by Information Builders’ Law Enforcement Analytics System - CompStat and Business Intelligence Dashboards
• Future Initiatives
![Page 33: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/33.jpg)
Future Initiatives
Predictive Analytics Structured Ad-Hoc reporting Triggers and Alerts Custom Operational Reports Inter Agency Information Exchange
![Page 34: Law Enforcement Analytics Milwaukee County Sheriff’s Office Captain Brian Barkow Brian.Barkow@milwcnty.com Law Enforcement Analytics Division (L.E.A.D.)](https://reader035.vdocuments.us/reader035/viewer/2022062500/56649cb65503460f9497b291/html5/thumbnails/34.jpg)
Questions?
Brian Barkow, Captain
Milwaukee County Sheriff’s Office
Police Services Bureau
Law Enforcement Analytics Division
Analyze Data
Review Findings
Mobilize Resources
Evaluate Performance
Document Results
© 8/1/2011