Analytics & Business Intelligence

2007 BI Award Recipients

At the first Business Intelligence Community of Experts (BICE) kick off event held March 13, 2007, the Advisors on Information Management Strategy and Michigan Administrative Information Services awarded prizes to colleagues who have demonstrated innovative uses of data to support decisions.

University Record Article


M-DASH TeamM-Dash team members include: Tony Chan, Vince Chmielewski, Matt Comstock, Karen Dannemiller, Michael Frickman, Jennifer Gillespie, Lorrie Harvey, Mary Hill, Will Jaynes, Deb Komorowski, Michelle Leung, Bruce Meier, Brett Miller, Dave Mohr, Gary Nichols, Patti Nurse, Heather Offhaus, Peggi Pfeffer, Bennett Stallone, Gus Teschke, Robin Wagner and Marilyn Warner.

M-Dash, short for Michigan-Dashboard, pulls together a wide variety of statistical data about the Medical School and turns it into easy-to-understand and useful charts, graphs and projections. It can be used to evaluate productivity of faculty members and departments, which can be helpful when trying to forecast future needs, such as when a new research building may be required. M-Dash received national attention last year in Academic Medicine and Business Week. Locally, it was featured in the Ann Arbor Business Review. "This tool developed by the Medical School provides the basis for intelligent business decisions," says Bill Elger, executive director for administration and chief financial officer of the Medical School. "The development team deserves this recognition for its outstanding work."

The M-Dash team was awarded $7,000 for the significant impact members have had on the Medical School.

Shelly Crundwell of The College of Engineering

Shelly Crundwell of The College of EngineeringShelly Crundwell, College of Engineering (CoE) created a tool for scholarship matching that combines enterprise and engineering data to match student qualifications for scholarships with donor stipulations, automating the matching of more than 600 scholarships. "It often took several days for this to be accomplished. It allows us to run our scholarship matching program for all students at once, which saves time and reduces the need for reshuffling matches down the line," Crundwell says. Many of the engineering features were incorporated into a new ITS application being implemented by LSA and the Ross School of Business and may be useful to other schools and colleges as well.

"The system proactively aids in the identification of students eligibility for scholarships and ensures donor funds are being used as intended, and better leverages the resources available for student support. It really has strengthened our stewardship of donor funds," says Marcella Brighton, director of financial management and planning for CoE.

Crundwell was awarded $1,000 for sharing her solution.

Pharmacy Services in the University of Michigans Health System

Pharmacy ServicesPharmacy Services recently became eligible for a federal program called the 340B Program, which allows institutions that provide for a disproportionate share of the indigent or poor patients to purchase drugs at a significant savings. However, complex government rules made it too difficult to take full advantage of the program. "By designing a new system that examines overall drug usage, identifies the percentage eligible for discount and then interacts with the wholesaler to determine the appropriate pricing, we were able to save over $10 million a year," said James Stevenson, director of Pharmacy Services. "In the past these systems were spreadsheet based. The team developed processes and software that integrates several systems, manages virtual inventory and coordinates drug purchases for a federal program." As an example of how data can be used to improve decision making.

The team of Michael McGregory, Alice Schuman and Larry Ligeski was recognized for their contribution with a $3,000 award.

Related Information