Data Warehousing

Catalog description

Introduction to fundamental concepts of data warehouse, its major characteristics and physical architecture. Concepts including MOLAP, ROLAP, Star Schema, snowflake schema, and parallel computing are illustrated using real world applications. Also examines issues related to building, utilizing and maintaining a data warehouse. Software packages such as R and PERL are used to practice cleaning, validating, converting and integrating data from a variety of sources. Popular data warehouse solutions (e.g. Oracle and Teradata) are compared. Enrollment Requirement(s): Completion of MBA Core.