Data Warehousing

Catalog description

This course focuses on fundamental principles and applications of data warehousing. Topics covered include data warehouse planning, design, and implementation. MIS 447 Data Warehousing (3) This course focuses on fundamental principles and applications of data warehousing. Issues related to data warehouse planning, design, and implementation are also covered in this course. Through case studies in various business domains, course exercises and projects, students will learn practical dimensional modeling techniques, extract/transformation/load (ETL) logic, ETL design considerations, and report generation. Essentially, students will learn how to align multiple sources of data through data warehousing architectures for deriving valuable business insights through subsequent business intelligence operations. The course begins by reviewing basic database modeling principles, and then introduces dimensional modeling in the context of the various data warehousing architectures (e.g., Kimball, Corporate Information Factory, hybrid architectures). Key concepts related to data warehousing including dimensional table characteristics, fact table characteristics and granularity, types of dimensions, types of fact tables, dimension attribute hierarchies, consolidated fact tables, slowly changing dimension techniques, and multivalued dimensions and weighting factors are covered in the course. Also, key advanced database management techniques such as views, procedures, and triggers will be introduced. Building on these core concepts, the course also covers related concepts including the role of online analytical processing (OLAP) and packaged analytic solutions, enterprise data warehouse business architecture and matrix, data warehousing lifecycle, ETL subsystems and tasks, ETL system planning, ETL design and development process and tasks, and data modeling best practices for big data. Case studies from various business domains and processes are included throughout the course. Examples of these domains include retail sales, order management, procurement, accounting, healthcare, insurance, transportation, and telecommunication. The case studies are used to illustrate the concepts as well as provide a context for hands-on exercises. Through course assignments and group projects, students have an opportunity to gain hands-on experience with data warehouse design, development, and prototype implementation.