Description
Week 6 - Week 6 –Data Warehouse Case Study Review
Indiana University Health – A Cerner data warehouse in 90 days - Case Study
Provide brief but complete answers. One page maximum (print preview to make sure it does not exceed one-two pages).
Q1: Describe the original data warehouse designed for Indiana University Health and its limitations. Please describe the new data warehouse and the differences between each?
Type your answer here.
Q2: Identify the major differences between a traditional data warehouse and a data mart? Explain the differences between the traditional data warehousing process compared to newly designed data warehouse in less than 90 days?
Type your answer here.
Q3: While this case study supports a specific data warehouse product, please locate another case study from another data warehousing software company and explain the data warehouse that was designed in that case study?
Type your answer here.
Attached Files:
- Week 6 - DW Case Study-IUA.doc (27.5 KB)
Resources:
- Websites:
- Data Mining: What is Data Mining? describes data mining. https://docs.oracle.com/cd/B28359_01/datamine.111/b28129/process.htm#CHDFJEJI
- Data Mining is an additioanl description of data mining. http://www.frandweb.net/jason/
- Indiana University Health is a 90 day data mining case study. https://www.healthcatalyst.com/success_stories/how-to-deliver-healthcare-EDW-in-90-days/?utm_medium=cpc&utm_campaign=Data+Warehouse&utm_source=bing&utm_term=+data%20+warehousing%20+case%20+study&utm_content=3542719787
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

Attached.
Running Head: Data Warehouse Case Study Review
Week 6 - Data Warehouse Case Study Review
{Student’s name}
{Professor’s name}
{Course title}
{Date}
Data Warehouse Case Study Review
Q1: Describe the original data warehouse designed for Indiana University Health and its
limitations. Please describe the new data warehouse and the differences between each?
The original data warehouse designed for Indiana University was traditional EDWs. It operated
on the early binding data warehouse architecture platform. This design and approach had some
limitations in that it took it was taking a lot of time to map data to complex data models i.e.
months and years. It was also prone to erro...
