Title of Your Presentation

Download Report

Transcript Title of Your Presentation

Innovative Business Intelligence for Government

Kevin Mergruen Vice President, Public Sector

Information Sharing For Government Enterprise Integration and Business Intelligence

ENTERPRISE INTEGRATION BUSINESS INTELLIGENCE MANAGEMENT RMS

• Executive Portals • Global Operations View • Performance Metrics • Financial Analysis

FEDERAL GOVERNMENT Police Fund Accounting Legacy Custom Apps Data Warehouse External Data

Aggregates all disparate data for centralized reporting

Finance Public Safety Human Resources ANALYSTS EMPLOYEES IT

Crime Analysis Better information sharing across departments… Budget Office Improved operational efficiencies… • Payroll Processing • Operations • HR Reporting • Financial Reporting • Development • Maintenance • System Administration • User Support

Higher citizen service levels…

A L L CITIZENS

• ARRA Reports • Bioterrorism • Port Security • Public Safety • Health Alerts • Human Services • Funds Analysis • Integrated Justice • Financial Reports • Crime Statistics • Quality of Life Applications

Information Builders Government Solutions       Financial Management and Reporting Health & Human Services Operational Reporting EBT Fraud Detection Child Welfare Compliance Reporting Law Enforcement Analytics Integrated Justice / Fusion Information Center  Police, Courts, Corrections, etc.     Health Information Exchange ARRA Fund Manager  Federal Stimulus Fund Reporting  Offender Management System Reporting  NCOMS Open Source Solution Government Health Insurance Analytics and Reporting K-12 Student Performance Management  Research Based Intervention Solution for Individual Student Improvement Copyright 2007, Information Builders. Slide 3 Copyright 2007, Information Builders. Slide 3

Information Builders Solutions Tailored For Any Size Government Organization

NYC DataShare:

Deployed an integrated justice system improving how police, prosecutors, courts, and other criminal justice agencies communicate and share information.

Louisiana Dept of Social Services:

Developed a public domain application to identify and reduce food stamp fraud to ensure that taxpayer money is not being misappropriated.

Oklahoma Dept of Health & Human Services:

First state to achieve SACWIS federal compliancy ensuring children are moving into permanent guardianship from foster care.

Charlotte-Mecklenburg:

Deployed an intelligence-led predictive policing solution for their 1,750 officer department. Police officers can view a predictive dashboard right from their squad car.

Maryland Dept of Transportation:

Deployed a financial management information system to ensure contract compliancy for the MBE community.

Pennsylvania State Police:

First state to deploy a Uniform Crime Reporting (UCR) public website helping police fight crime and giving citizens access to crime statistics across the state.

California Dept of Health Services:

Over 5,000 budget analysts can now do real time analysis of the DHS budget vs. waiting 2 weeks after a month end close.

Columbus City Schools:

Deployed the All School Improvement Plan which provides proactive research-based intervention to improve student performance and graduation rates.

Innovative Business Intelligence in Public Sector Why?

 Revenue shortfall means we must do more with less  Identify new economic development opportunities    Need proactive analytics to understand and manage deficit Meet compliancy requirements for federal funded programs Costs continue to rise across the board – Medicaid, education, transportation, etc.    Improve operational efficiencies Identify Waste, Fraud & Abuse before payments are made Transparency & Accountability requirements for both internal & external public reporting   Alignment with initiatives from your elected officials Citizen demand for services continues to rise Copyright 2007, Information Builders. Slide 5

Government Innovation Challenges Lack of Information Consistency

Public Sector Innovation Management Affects All Levels of the Organization

Information Technology Finance & Administration Analyst ANALYST Governor / Mayor Chief of Staff Health & Human Services Analyst Public Safety Analyst Human Services Transportation Analyst PARTNERS / PUBLIC CITIZENS SUPPLIER FEDERAL SERVICE CUSTOMERS

Innovation Strategies Performance and Motivation

 Focus on stakeholders  Employees   Contractors Regulated entities  Business Benefits  Revenue generation   Cost savings Reduced fraud   Increase Employee Productivity Key Technologies  Business Intelligence Applications    Portals, Enterprise Search & Mobile Predictive Analytics Performance Management  Supply/Value Chain Optimization Innovation Automation Motivation Copyright 2007, Information Builders. Slide 8 Copyright 2007, Information Builders. Slide 8

Enabling a Culture of Innovation



Communication

  Dashboards Strategy Maps    Robust alerting Collaboration Publishing 

Alignment

 Operational & Strategic closed loops     Visual Cause/Effect tools Aligned projects/initiatives Cascaded Scorecards Pooled Metrics and Benchmarks 

Analytics

Customer Experience: Columbus City Schools

Achieving Academic Excellence Challenges

   Only 55% of students were graduating from high school Limited amount of time to affect change within a school year Turning data into useful information to identify improvement needs  Need for real-time course correction with evidence-based strategies that are known to work  Deploying an effective planning process for improving school performance across all levels of the organization Copyright 2007, Information Builders. Slide 11

Data-Driven Decision-Making in Columbus City Schools

 Develop a repeatable model for providing compliance data to improve student performance  Establish compliance-based information framework  Establish ability to project year-end State and Federal performance results  Develop and implement in partnership between Nationwide and Columbus City Schools Copyright 2007, Information Builders. Slide 12

Building Scorecard

Individual Student Trend Report

Customer Experience: Charlotte Mecklenburg Police Department

Meet Our Customer Charlotte-Mecklenburg Police Department

“Information Builders’ dashboard and predictive analytics software will allow staff at every level of the police department to deal with facts in real time. We’ll be better equipped to optimally assign officers to response areas with the highest likelihood of criminal activity, resulting in reduced crime and lower operating costs.” Rodney Monroe Police Chief Charlotte-Mecklenburg Police Depatment Copyright 2009, Information Builders. Slide 22 Copyright 2007, Information Builders. Slide 22

CMPD

BI Dashboards & Predictive Crime Analytics Background Information  Estimated Population: 777,827  Land Area: 438 square miles  1725 Sworn Officers  500 Non-sworn personnel Copyright 2007, Information Builders. Slide 23

CMPD

Predictive Dashboard Created predictive dashboard for the following major crime categories: Commercial Robbery Personal Robbery Aggravated Assault Residential Burglary Commercial Burglary Auto Theft Larceny from Auto Copyright 2007, Information Builders. Slide 30

Predictive Dashboard (Continued) Used WebFOCUS RSTAT to build the seven predictive models based on a series of inputs: Historical geographic crime patterns Recent criminal activity (within past 24-48 hours) Day of week and time of day Weather conditions Moon Phases Recent call for service activity School holidays Special Events Copyright 2007, Information Builders. Slide 31

Customer Experience: LA County Auditor Controller

LA County Background

 Established February 18, 1850  One of the nation’s largest counties with 4,084 square miles  Has the largest population of any county in the USA  Approximately 27% of California’s residents live here  Board of Supervisors is the governing body  LA County would have the 19 th largest economy in the world if it were a nation Copyright 2007, Information Builders. Slide 44

LA County Auditor Controller Profile

 Provides financial leadership and advocacy for financial integrity and accountability for all County business. Responsibilities include:   Establishing County fiscal and internal control policies Operating eCAPS for integrated accounting & disbursing system   Administering the County payroll Conduct audits and fraud investigations of departments, employees and contractors Copyright 2007, Information Builders. Slide 45

LA County Auditor Controller Challenges

 Supports reporting and analytics for the human resources and payroll aspects of a 100,000+ employee population  Need to help all departments better manage their contracts and expenditures   Identify waste, fraud, and abuse across departments Move away from Excel spreadsheets to do contract management   Excel was cumbersome & error prone Multiple versions of the truth  Initial roll out to 5,000 users in the Auditor Controller’s office prior to full County deployment  Graphical dashboard to capture user’s attention

LA County Auditor Controller Contract Management Dashboard

 Business Intelligence Application that provides every department’s top executives with:     Visibility into which vendors were awarded a contract How much is the contract budget Current spending against that contract Better monitoring of contract activities Countywide  Enables improved cost controls in today’s difficult economic environment Copyright 2007, Information Builders. Slide 47

Dashboard Demo Overview

Summary

Information Builders in Public Sector Summary

  Leverage standards for information exchange Enable collaboration across departments while leveraging existing technology investments   Make more informed decisions when balancing budgets Reduce bureaucracy, fraud, abuse, and improve efficiency  Gain more favorable funding from the state or federal government  Provide higher service levels to your constituents Copyright 2007, Information Builders. Slide 50

Information Builders in Public Sector Enabling Innovative Government!

Right information, right people, right time!