HCI 455 - Database and Data Warehouse Concepts in Healthcare Informatics

5 CR

This course offers the student an understanding of what a data warehouse is, who uses it, and why. The student will gain a basic understanding of different data warehouse architectures. We compare and contrast various schema models (how data is arranged), identifying which is best suited for different healthcare data consumers and their data analysis needs. There is a quarter-long project where the students will immerse themselves in some of the primary tools used for managing a healthcare data warehouse. Utilizing both theory and hands-on experience, students practice querying disparate healthcare databases to populate a data warehouse.

Prerequisite(s): HCI 320 or instructor permission

Course Outcomes
Compare and contrast the benefits and use cases of a Database, Data Warehouse, and Data Mart and how these are used by healthcare organizations.

Describe the different stakeholder groups involved in healthcare Data Warehouses and what kind of requirements they may need.

Apply appropriate strategies to analyze what data is needed to meet clinical requirements and criteria

Find out when this course is offered