Data Warehouse/Bus Intelligence

Catalog description

This course introduces the principles and procedures related to the design and management of data warehouse (DW) and business intelligence (BI) systems. The DW is the central data repository that is used for decision-support. BI refers to the analytical applications that users can interact with in making sense of the data. The course focuses on the data warehousing process including requirement collection, data warehouse architectures, dimensional modeling, extracting, transforming, and loading strategies, and creation of data marts. The course also uses data warehousing as a platform for BI applications, such as reporting, dashboards and online analytical processing (OLAP). By completing this course, students should understand the technologies used for decision-support and possess valuable analytical skills.