In Class: Caselet, University Health

Data Analytics Made Accessible Anil K Maheshwari 2018. Amazon: https://www.amazon.com/dp/B00K2I2JL8/

Caselet: University Health Syste BI in Healthcare Indiana University Health (IUH), a large academic health care system, decided to build an enterprise data warehouse (EDW) to foster a genuinely data-driven management culture. IUH hired a data warehousing vendor to develop an EDW which also integrates with their Electronic Health Records (EHR) system. They loaded 14 billion rows of data into the EDW-fully 10 years of clinical data from across IUH's network. Clinical events, patient encounters, lab and radiology, and other patient data were included, as were IUH's performance management, revenue cycle, and patient satisfaction data. They soon put in a new interactive dashboard using the EDW that provided IUH's leadership with the daily operational insights they need to solve the quality/cost equation. It offers visibility into key operational metrics and trends to easily track the performance measures critical to controlling costs and maintaining quality. The EDW can easily be used across IUH's departments to analyze, track and measure clinical, financial, and patient experience outcomes. (Source: healthcatalyst.com) Q1: What are the benefits of a single large comprehensive EDW? Q2: What kinds of data would be needed for an EDW for an airline company