Molding transactional data into decision making information in the medical industry: the case of Laberman General Hospital

摘要

This case is about constructing a data warehouse model for a hospital. The Chief Executive Officer (CEO) at Laberman General Hospital is facing a combination of business analysis and information sharing issues. The hospital is experiencing diminishing profitability and market share. Hospital management cannot analyze the problems and make effective decisions because of their inability to combine data from independent business functions. As a condition of her contract renewal and continued operation of the hospital, the Board of Directors has given the (CEO) one year to reverse these trends. The CEO has decided to focus, among other areas, on marketing. She needs a combination of data from the patient, pharmacy, radiology, and pathology databases. The Chief Information Officer (CIO) has 90 days to ascertain the information needed by the CEO's Executive Staff, and to build a data warehouse solution. The case describes strategic marketing decisions in the hospital industry, building the data warehouse logical model, and matching database queries to decisions being made by executive level management.