Case study on data warehouse

User Generated

cvaxl0101

Programming

Wilmington University

Description

Week 6 - Week 6 –Data Warehouse Case Study Review

Indiana University Health – A Cerner data warehouse in 90 days - Case Study

http://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


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:

Resources:

  • Websites:

Unformatted Attachment Preview

Indiana University Health – A Cerner data warehouse in 90 days - Case Study http://www.healthcatalyst.com/success_stories/how-to-deliver-healthcare-EDW-in-90days/?utm_medium=cpc&utm_campaign=Data+Warehouse&utm_source=bing&utm_term=+data%20+warehousing% 20+case%20+study&utm_content=3542719787 Name: your name 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.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...

Similar Content

Related Tags