SLIDE 1 Putting It All Together: Improving Management Decisions Through The Use of Analytics
Court Solutions Conference Baltimore, Maryland September 10, 2008 Presented by Bob Wessels
SLIDE 2
WWW.CCL.HCTX.NET
SLIDE 3
SLIDE 4
SLIDE 5
SLIDE 6 Axioms of Caseflow Management
- Early and continuous control reduces backlog
- Every case on the docket for a day and purpose
certain
- Immediacy of trial disposes of cases
- A court with time available will dispose of more
cases than will a court continuously in trial
- What people count influences human behavior
Ernest Friesen, ICM June, 1975
SLIDE 7
- What people count influences human
behavior
- For it to affect human behavior, it has to
be measured, compared and shared
SLIDE 8
- You can’t manage a caseload until you can manage
an individual case
- Achieving higher levels of performance begins with
understanding and measuring your performance today
- Higher performance is achieved by creating a culture
that embraces analytics
SLIDE 9
Change
Data Information Knowledge Education Change
SLIDE 10 View of System in 3 Parts
Intake Adjudication Compliance
Arrest to First Appearance First Appearance to Sentencing Sentencing to Completion
SLIDE 11 What do we manage?
- Cases/Events/Settings
- Jail Population/Incarcerated Defendants
- Bonding, Pre Trial Services
- Person Status and Offenders with Special Needs
- Attorney Performance and Fees
1 of 2
SLIDE 12 What do we manage?
- Non Arrest Cases/Open Warrants
- Collections and Capias Pro Fines
- Community Supervision and Compliance with Conditions
- Special Caseloads – DWI, Mental Health
2 of 2
SLIDE 13
A Single Version of the Truth
SLIDE 14 Evolution of Court Management Information
1976
- JIMS
- Lists
- Forms
- Mgt. Reports
- Events & Jail
Status
1986
1990
Navigate”
1995
extracts
2007
Intelligence
reporting
SLIDE 15
Lists & Management Reports
SLIDE 16
Forms
SLIDE 17
Original Cases Pending Graphic
SLIDE 18 Domain Model for Court Business Intelligence
Business Activity Measures Key Performance Indicators
Financial Analysis
Decision Support
Trend Analysis “What if” Analysis Capacity Planning Program Evaluations Exception Reporting Data Quality Impact Studies
SLIDE 19 Data Availability
19
Data Mart / Star-Schema Cube / Analytics
1 2 3
Transformation
Data 3 Data 1 Data 2
Detail Data / Staging Area
Cube Building
GP PM CM FACT DIM DIM
SLIDE 20 System Overview
TECHNOLOGY: SQL Server 2005 Reporting Services Analysis Services Web Portal written in .Net
SLIDE 21
Cases/Events/Settings
SLIDE 22 Court Performance Metrics
Business Activity Measures (BAMs)
- Active Cases Pending
- Incoming Cases by Filing Instrument
- Incoming Cases by Offense Category
- New Filings Year to Date
- Disposed Cases by Offense Category
- Activity Summary for Judgments
1 of 2
SLIDE 23 Court Performance Metrics
Key Performance Indicators (KPIs)
- Age of Caseload
- Clearance Rate
- Time to Disposition
- Settings to Disposition
2 of 2
SLIDE 24 Docket/Calendar Information for Each Case and Person
- Style
- Filing Date
- Offense
- Bond Amount
- _____ Days Old
- Number of Settings
- R/S Requested by ____
- Felony Pending/Court/Setting
Date
- Race/Sex/DOB
- Pre Trial Interview Y/N
- Defense Attorney Name & Phone #
- Mental Health Flag
- Bonding Co. & Phone #
- Days in Jail – This Case
- Days in Jail – Total
Intake
Adjudication
Compliance
SLIDE 25
Judge's Docket (JIMS 096)
SLIDE 26
Calendar Summary (081)
SLIDE 27
Calendar Summary (JIMS 081)
SLIDE 28
Age of Case (JIMS 184)
SLIDE 29 Master Event Log (JIMS 168)
Event identification and measures
between events
SLIDE 30
Jail Population/Incarcerated Defendants
SLIDE 31
Prisoner Index (JIMS 518)
SLIDE 32
Prisoner Index (JIMS 518)
SLIDE 33 100 200 300 400 500 600 700 800 900 1000 8/19/2002 8/18/2003 8/16/2004 8/15/2005 8/21/2006 8/20/2007 8/20/2008
Detainees with Misdemeanor Charges Only Detainees with Both Misdemeanor and Felony Charges Total Detainees with Cases in the CCL
Pretrial Detention and Defendants with Misdemeanor Cases
SLIDE 34
Attorney Performance and Fees
SLIDE 35
Attorney Report (JIMS 123)
SLIDE 36
Attorney Fee Report
SLIDE 37
Special Caseloads: DWI
SLIDE 38
Future Cases: Distribution by Age of DWI Defendant
SLIDE 39
Future Cases: Probation vs. Conviction 16% 10%
SLIDE 40
Court Business Intelligence Screenshots
SLIDE 41
SLIDE 42 Find all DWI cases set for trial in CCL #1
Offense Category Defendant Status & Setting Reason
SLIDE 43 “Smart Docket” displays Age of Case and Number of Settings in red when a case exceeds the court’s goal for Time to Disposition (90%/90 days).
SLIDE 44
SLIDE 45
SLIDE 46
SLIDE 47
SLIDE 48
SLIDE 49
SLIDE 50
SLIDE 51
SLIDE 52
SLIDE 53
SLIDE 54
SLIDE 55 Key Elements of Effective Courts
- Focused
- Flexible
- Friendly
- Fast
- Fiscally and Financially
Responsible
- Fact Anchored
- Future Oriented
- Flat Structured
- First Time Quality
All High Performing Organizations Will Have These Things in Common Ron Stupak ‐ NACM Mid Year, 1996
SLIDE 56 Key Elements of Effective Courts
- Leadership
- Goals
- Information
- Communications
- Caseflow Management
Policies
- Commitment
- Staff Involvement
- Education and Training
- Mechanisms for
Accountability
Inventory Control Courts that Succeed – Hewitt, Gallas & Mahoney, 1990
SLIDE 57 Hallmarks of Courts of the Future
Bob Wessels 2005
- Develop Leadership
- Use Information
- Create Knowledge
- Manage Change
- Monitor
- Evaluate
- Refine
SLIDE 58
Additional Reading
Competing On Analytics ‐ The New Science of Winning, John Davenport and Jeanne B. Harris, Harvard Business School Press, 2007 Super Crunchers – Why Thinking by the Numbers Is The New Smart Way To Be Smart, Ian Ayres, Bantam, 2007