HCTM 455 Data Warehousing in Healthcare • 5 Cr.
Presents students with best practices for ETL (extract, transform and load) and data warehousing in healthcare. Utilizing both theory and hands on experience, students practice querying disparate healthcare databases to populate a data warehouse. The importance of organizational data governance will also be introduced. Prerequisite: Acceptance into the program, and completion of HCTM 320 and 450 with a C or above, or permission of instructor.
After completing this class, students should be able to:
- Analyze the processes used to extract data from disparate databases followed by data transformation and loading into formats for analysis.
- Select appropriate methods to query a database.
- Categorize different levels of granularity for data and data warehouses.
- Differentiate between primitive and derived data.
- Compare and contrast the organizational roles of a production database versus a data warehouse.
- Differentiate between fact and dimension tables within a data warehouse.
- Outline the role of different stakeholders in the formation of a data warehouse.
- Examine the role a data dictionary plays in data validity and reliability.
- Appraise the importance of data governance within a healthcare organization.
- Devise a set of best practices for the data governance function.
- Differentiate the privileges and permissions needed for a data warehouse versus a production system.
- Winter 2017 (current quarter)