Abstract

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.

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.