Analytics & Business Intelligence

2009 BI Award Winners

Medical School Office of Space Management

Medical School Office of Space Management

The Medical School pulls existing data from different sources (space and financial tables) into a single tool that calculates space productivity based on a clearly defined metric. M-Space displays the information in a flexible format, allowing users many choices within the application, as well as the ability to download for further analysis.

Before the concept of BI was introduced at the Medical School, there was no space policy, criteria for measuring space utilization, or benchmark for comparison – nothing concrete on which to base decisions. The increasing cost of facilities operations and maintenance, as well as fierce competition for research space, led to the direct management of space allocation and for quantifying space productivity.

M-Space Productivity reports and the ArcGIS mapping tool are available to all Medical School departments and administrators. By defining a space policy, creating metrics, and making management information clearly visible to stakeholders, the School has built trust and put data into action to manage space fairly. The School has seen a 4.18% annual overall increase in space productivity, faster response time for space requests, increased data integrity, and unprecedented cooperation from department chairs.

Award Presentation Video

 

Benefits Office Integrated Data Warehouse Team

Benefits Office Integrated Data Warehouse Team

The implementation team and their selected vendor created an integrated healthcare data warehouse that combines UM benefits eligibility data, paid medical claims, health assessment data, and health/wellness program participation. The warehouse will allow UM to take a holistic, independent, employer-based view of the population; which will greatly increase the University’s ability to be financial stewards of an approximate $300 million dollar annual healthcare system.

In addition, the data warehouse will be used to support the President’s Michigan Healthy Community (MHealthy) Initiatives which promote health and wellbeing, and improve the quality of life and productivity for employees.

The procurement of the warehouse and its related tools include:

  • Data warehouse that de-identifies, aggregates, and standardizes many healthcare data sources
  • Data privacy and protection
  • Pre-formatted, automatically updated standard reporting
  • Thousands of standard reports and predefined measures
  • Executive dashboard reports
  • Robust set of industry  norms/benchmarks; ability to create custom benchmarks
  • Enhanced ability to perform analysis in a timely manner

Award Presentation Video

 

Law School M-Reports: Admissions & Aid

Benefits Office Integrated Data Warehouse Team

The Law School and Michigan Administrative Information Services (MAIS) worked together to create a pilot M-Reports dashboard for the Admissions Office. Previously, admissions and merit aid tracking was an extremely manual process involving timely report generation and distribution, and repetition of tasks. The M-Reports dashboard positions data in a way that streamlines the processes and enables users to immediately see what once took time and manipulation to create.

The dashboard calculates numerous metrics critical to the admissions process and displays them in varying levels of detail, including graphically. The project is unique in terms of its analytical scope. There are previously nonexistent aspects for tracking the characteristics of the incoming class, as well as budget tracking and “after the fact” analysis of the aid strategy’s efficacy.

A Phase II of this project involves a higher level of autonomy for the Law School. This test program potentially increases authority on projects to individual units.

Award Presentation Video

 

Honorable Mention

School of Nursing Pressure Ulcer Workgroup

School of Nursing Pressure Ulcer Workgroup

In 2005, the Center for Medicare & Medicaid Services changed its policy so that hospitals no longer receive additional compensation to care for patients who acquire pressure ulcers while under their care. This prompted the University of Michigan Health System (UMHS) to review the data it uses to assess risk, prevention, and management of pressure ulcers.

A daily automated feedback system was developed to supply UMHS clinicians with vital information regarding ulcer risk, status, and intervention. The reports, which are delivered to clinicians via email at 5 a.m., aggregate pertinent data to provide an actionable summary. The clinicians use the report to keep tabs on their patients, determine the need for interventions, charge nurses, and support decision making.

Patients with pressure ulcers tend to experience longer lengths of stay and may require outpatient care. The data gathered from the automated feedback system can be mined for cost effectiveness analysis, and to determine whether it contributed to reduced length of stay, ulcer rates, or severity.

Award Presentation Video