MPH provides custom analytics solutions to solve complex management and policy questions. Our solutions drive investment and help our partners achieve greater outcomes for Hoosiers.
Problem: Indiana has a seen a growing number of crashes since 2011. Of these crashes, fatalities due to motor vehicle crashes were up 7.5% from 2014 to 2015.
Solution: A predictive mapping tool was developed by MPH for the Indiana State Police to forecast crashes based on weather, traffic, road conditions, time of day and census data. The tool will assist law enforcement agencies in directing resources to anticipated needs and will reduce response time for first responders.
Impact: Proactive policing approaches will be targeted towards a reduction in crashes and fatalities. A reduction of 1 percent of all crashes could result in savings of $35M per year to the Indiana economy, while protecting Hoosier lives and wellbeing.
Problem: The State of Indiana has the highest number of pharmacy losses in the entire nation, a loss that translates into both financial and public safety injury.
Solution: The Management Performance Hub (MPH) coordinated the data cleanup of the Professional Licensing Agency’s (PLA) pharmacy loss datasets into one comprehensive dataset, so data can be viewed longitudinally by decision makers. MPH also developed several requested analyses and visualizations for PLA that identify pharmacy loss trends.
Impact: Visualizing their data will enable PLA to identify pharmacies or communities that need quick, targeted intervention. The stories that the data reveals will also be of use to leaders working to address policy questions surrounding pharmacy loss prevention.
Problem: Indiana law enforcement agencies do not have access to a central data repository for state-wide crime data and are unable to view crime statistics in real-time. The lack of access to real time data limits law enforcement from quickly identifying patterns of crime and puts the safety and well-being of Hoosier law enforcement and communities at risk.
Solution: Together, the Indiana State Police (ISP) and Management Performance Hub (MPH) are partnering to develop a crime reporting database and data analytics tools that will enable law enforcement departments to not only have real-time insight into their own areas, but also share data between law enforcement agencies to address patterns of crime occurring across jurisdictions.
Impact: These services will expand safety across the state of Indiana by ensuring that all local and state law enforcement entities will have the tools needed to address crime more proactively in their communities. Second, law enforcement agencies will be empowered to be leaders for data informed criminal justice policies.
Problem: Because the drug landscape in Indiana changes so quickly, practitioners and policymakers must have access to real-time insight into this landscape to holistically and appropriately address addiction and the supply/demand of drugs.
Solution: To achieve this, MPH coordinated disparate data sources from several agencies and Marion County to create a comprehensive analytical view statewide for use by the Governor’s Drug Task Force.
Impact: The state-wide visualization tool has been used to determine the location of new opioid treatment centers and to inform the disbursement of Naloxone (the opioid overdose reversal/blocking drug). By targeting appropriate communities with their needed resources, Hoosier lives are being saved and their addictions are being addressed.
Problem: Housing and rehabilitating offenders is expensive. Returning offenders as productive members of society positively affects the individual, communities and government resources.
Solution: Through advanced analytics, differences in the effectiveness of programs/services and the probability of repeat criminal activity for highly specific subpopulations was tested.
Impact: This information can be used to improve decision-making, program effectiveness, and efficiency both during and post-incarceration. Insight can be used to inform caseworkers on the suite of programs and services likely to be most effective to rehabilitate offenders based on his or her unique needs. Resources can be focused on subpopulations of released offenders with higher probabilities of recidivating. As recidivism risk decreases over time, resources can be more effectively reallocated.
Problem: Indiana historically has had a high infant mortality rate.
Solution: A data analytics project between multiple agencies aimed at reducing the infant mortality rate in Indiana by identifying previously not fully understood factors affecting the infant mortality rate and providing methods to address these factors.
Impact: Information from this project will be used by the Department of Health in its efforts to reduce the infant mortality rate. This research and analysis was also presented to the General Assembly as it enacted legislation to address infant mortality in the 2015 legislative session.
In addition to the direct benefits of this project, several indirect benefits to the state resulted. These include the development of the foundational data repository on which several other projects done by MPH have been built—significantly reducing project delivery timelines and cost, a scalable record linkage solution that has been used on 3 projects since, a robust data security framework, and overall improvement in the state’s data quality—unlocking value from the data by enabling analysis that was never possible before.
Problem: The Indiana State Department of Health does not have access to accurate, readily-available health-related data for programs and initiatives aimed at reducing the state’s obesity rate, which is 7th highest in the country.
Solution: In partnership with the Indiana Biosciences Research Institute, the MPH performed a data discovery analysis on current data sets collected by state and external not-for-profit organizations.
Impact: The outcome of this project has formed relationships with external partners to drive higher quality data sets to ISDH programs, which will ensure ease of future analysis and improved operational decision-making.
Problem: Indiana’s lack of ability to answer key questions about the education to workforce pipeline.
Solution: The Education and Workforce Development database (EWD) is a large-scale data matching and warehouse initiative combining data sets to answer key questions about the education to workforce pipeline. MPH has facilitated the development of the data warehouse that will allow stakeholders, such as education professionals, employers, policymakers, students, community leaders, and the public to use data to provide data and information previously not available.
Impact: EWD will ultimately allow stakeholders to conduct analysis of effectiveness of programs and allocation of resources tied to long-term outcomes.
This project is also exemplary of the efficiency gained through an enterprise approach to data analytics. Significant efficiencies were gained in completion of the project through the use of already completed MPH computing environment and security framework, record linkage solution, and data sourcing jobs and software.
Problem: Inability to identify emerging statewide trends in key metrics related to child safety, well-being, and permanency.
Solution: MPH is building an analytics server that will allow the Department of Child Services (DCS) Management personnel to quickly access strategic operational metrics. DCS is in the process of shifting from weekly and monthly scheduled reports to near real-time operational dashboards by utilizing business intelligence and analytics tools made available through MPH for managerial decision-making.
Impact: Through improved business processes and procedures, DCS is able to make adjustments in operations, policy, and practice to improve service delivery to children and families.
Problem: State government is large and headcount is difficult to manage comprehensively.
Solution: A dashboard tool was developed by MPH to show the state employee headcount for the purpose of data informed management.
Impact: This tool was used in the management of headcount by the administration over the past year. While direct cost savings was not the immediate goal of our headcount initiative, the state reduces its financial risk by managing headcount.
Problem: The State Personnel Department (SPD) Human Resource Directors need easily-accessible personnel information to assist agency partners in managing their employment trends.
Solution: Utilizing the MPH’s high-powered analytics infrastructure, MPH leveraged a previously-developed headcount dashboard. This allows SPD to calculate and evaluate a more accurate turnover value with the ability to quickly filter the data to glean comparative insights. The business intelligence tool provides calculations based on multiple logical equations, so users can quickly analyze the turnover rate in a variety of ways over time (statewide, by agency, and job classification) to easily establish comparative benchmarks for recent performance.
Impact: Human Resource Directors will have the capability to view turnover-related data historically, in real-time, and even forecasted into the future. HR personnel can highlight and analyze trends in the data to create data-informed policies and procedures designed to improve employee retention in state government, and counsel agencies towards more targeted and effective hiring efforts based on the needs identified through these trends.
Problem: Managing enterprise wide spending is often difficult and unwieldy.
Solution: SPEED is a tool developed by MPH to help State Budget Agency (SBA) manage agency spending throughout the year. This is a web application that can be accessed on a secure, State-owned URL.
The basic function for this application is to compare actual spending to plan spending. SBA uses this tool on a monthly basis to see if agencies are over or under spending according to their proposed plan.
Impact: This application has enabled SBA to more accurately and timely manage agency spending and make adjustments in near real time instead of at year end.
Problem: Fraud costs states significant money each year and often puts citizens’ identity at risk.
Solution: MPH is facilitating a cross-agency fraud system that leverages technology and data science techniques that will provide significant cost savings for the state.
Impact: Creating an identity management platform to combat fraudsters and potential fraudsters will allow agencies to capture more individual and business fraud and protect ID theft victims more effectively.
The tool will also reduce the need for outside vendors to manage identity data for the state and will provide cost avoidance for agencies looking to introduce or expand identity management, leveraging the State’s investment in MPH to reduce spending while identifying new cases of fraud across UI, social services and tax.