I&C SCI X425.32

Data Integration, Modeling, and ETL

A required course in the Business Intelligence & Date Warehousing Specialized Studies Program.

This course provides both introductory and advanced concepts and techniques for developing effective dimensional models, data integration, and the ETL process. Learn how to build a high performance dimensional data model. A good dimensional model and its physical database form the hub of a business intelligence data warehouse, serving as the target of the data integration and as the source of business intelligence data. Learn how to design dimensional models for extensibility, employ a proven dimensional design process, apply the process to several representative situations, and understand a variety of advanced dimensional modeling techniques. The Extract, Transform, and Load (ETL) process is typically the most time-consuming, misunderstood, and underestimated task in building a data warehouse and other data integration applications. The ETL process addresses and resolves the challenges of extracting data from disparate operational source systems, storing it in the data staging area, profiling data for errors, cleaning and transforming the data, and mass loading it into the target enterprise data warehouse, data marts, or operational systems. Prerequisite: Experience using a relational database (as a minimum, Microsoft Access or similar product) is highly desirable.

Icon
Course
Approximate Cost $820
Format Online
Duration 8 Weeks
Total Credits 2.5

WINTER 2024

1/15/2024 - 3/10/2024
Weeks 8
Delivery Online
Fee $820
Status Closed

SUMMER 2024

7/15/2024 - 9/8/2024
Weeks 8
Delivery Online
Fee $820
Status Open