BUSIT 110 Data Warehouse I • 5 Cr.
Introduces the concepts associated with the development of a data warehouse. Students apply the "Extract, Clean, Conform, and Deliver" process to organizational data and build the dimension and fact tables required in a data warehouse. Current server tools are used in hands-on exercises. Prerequisite: BUSIT 105 with a C- or better.
After completing this class, students should be able to:
- Define the role of Data Warehousing in an organization
- Identify issues with extracting data from heterogeneous data sources
- Describe accepted methodologies to clean and conform organizational data
- Design dimension tables with various schemas
- Design fact tables that satisfy the requirements of Key Performance Indicators
- Design a development plan for implementing a Data Warehouse