Analytics & Business Intelligence

2008 Data-into-Action Award Recipients

Cultural Change Yields Business Intelligence Payoffs

Business Intelligence innovators were honored at the 2nd annual Business Intelligence Data-into-Action Awards. The Advisors on Information Management Strategy (AIMS) and Michigan Administrative Information Services (MAIS) presented cash awards of $11,000 to three teams who devised methods of using information to improve planning and business processes at U-M.


M-Reports Team

M-Reports TeamM-Reports is a Web-based reporting system that delivers management reports in a customizable, intuitive user interface. The infrastructure can not only be used to deliver new content, but can also integrate with existing data sources.

M-Reports was one of the first projects on campus to use Microsoft .NET technology and the Microsoft Business Intelligence toolset to create a dimensional model of data. This OLAP technology allows for instant data retrieval – a vast improvement from the 20 minutes it used to take to run a single report.

The tool’s drill-to-detail functionality eliminates the need to run subsequent reports in order to examine details for anomalies and outliers.

The M-Reports team was awarded $4,500 for its contributions. Members include: Chris Allan, Tom Amerman, Joe Bauer, Pattie Boettger, Mary Byrkit, Cassandra Carson, Karen Dannemiller, Lori Deromidi, Radha Dhandapani, Lisa Emery, Nathan Eriksen, Shane Fortune, Kathy Gillespie, John Gohsman, Debbie Gowan, Brent Haase, Lisa Harris, David Holzschuh, Tara Horton, Erin Kassa, Deb Komorowski, Mike Lawson, Mary Locey, Barry MacDougall, Thom Madden, Debbie Mero, Holly Nielsen, Ruby Nugent, Lisa Poulson, Carolyn Rockafellow, Holly Rose, Steve Schlecht, Michael Sheppard, Carrie Shumaker, Aaron Stark, Denise Stegall, Ann Tuttle, Jeff Wixon and Brian Wlosinski


Patient Safety Indicator Case Review System Design & Development Team

Patient Safety Indicator Case Review System Design & Development TeamThe Patient Safety Indicator Case Review System (PSI-CRS) utilizes readily available hospital data to identify patients who experience an adverse event that may have otherwise gone unreported. The system helps University of Michigan Health System (UMHS) use the information to take corrective action and prevent future patient safety events.

Aside from improving the quality of patient care, PSI-CRS can also assist in preparing for federal initiatives in identifying and reducing Medicare reimbursement for inpatients with hospital-acquired complications.

PSI-CRS utilizes data sources that are readily available to other hospitals, and could potentially be developed commercially and licensed to acute care hospitals nationwide.

The PSI-CRS team was awarded $4,500 for its contributions. Members include: Vinita Bahl, Mary Kay Cotter, Louisa Griffes, Gwen Blackford, Elaine Commiskey, Maureen Thompson, Susan Anderson, Adrian Weyhing and Terry Walsworth. 


LSA Management Information Systems Team

LSA Management Information Systems TeamThe College of Literature, Science, and the Arts (LSA) developed the Key Performance Indicators (KPI) web-based information system to aid in management decision-making.  The system is used by the College in preparation of budget materials.

The KPI system draws data from the M-Pathways system (student, finance and HR modules), CRAS tables and other institutional data sources to provide a simple set of indicators and ratios. This can be done either longitudinally for a single department or for multiple departments for a single year.

This project contributes to budgeting and decision-making at a time when wise use of resources is crucial. The easy accessibility of this data has already lead to cultural changes in LSA and improved the way the College views its resources.

The team of Nick Hadwick and Rob Wilke was recognized for their contribution with a $1,000 award.



Honorable Mentions

Medical School Administration – Office of Space Management

Medical School Administration - Office of Space ManagementThe Medical School leveraged Geographical Information Systems (GIS) technology to create a tool that quickly and efficiently manages 1.4 million square feet of occupied space. The tool merges data and graphics to help determine how to best utilize limited space and how to allocate space costs to individual units.

The tool’s text data is pulled directly from the M-Pathways space database and is updated monthly. As a result of the effort, the Medical School can now view any floor of the building and quickly produce a map with up-to-date information

The ArcGIS tool has helped improve the Medical School’s organizational planning and decision-making processes. It also highlights capacity and space utilization issues, aids in auditing and greatly improves data quality.

Team members include: Julianne Orlyk Walsh, Bennett Stallone and Sucheta Kulkarni.


Benefits Office

Dawn Parsons, lead Clinical Pharmacist for the U-M Prescription Drug Plan, produced nationally-recognized drug management programs and internal high-quality claim/financial/trend analysis, resulting in $60 million in savings.

Her work includes partnering with the Health System Medical Outcomes Program to develop two major physician intervention medication switch programs that capitalized on preferred generic prescriptions. By providing data sets, Dawn helped identify which physicians had patients who could switch their medication to a lower cost generic.

Dawn also creates monthly charts, graphs, and detailed utilization and cost data to provide key information to the U-M Pharmacy Benefits Advisory Committee. This assists in the determining U-M drug formulary, co-pay tier level, and other management programs for specific drugs.

Related Information