You will be assessed a $25 late fee if you are enrolling one day after the course start date. You should work with the instructor to catch up on coursework.
Click OK if you still wish to enroll. Otherwise, click Cancel.
The course you selected is already in progress. You should work with the instructor to catch up on coursework.
Click OK if you still wish to enroll. Otherwise, click Cancel.
Data Integration, Modeling, and ETL
A required course in the Business Intelligence & Date Warehousing Specialized Studies Program.
Course Description
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.
Prerequisites: Experience using a relational database (as a minimum, Microsoft Access or similar product) is highly desirable.
Instructor
Textbook Information
Textbooks for your course may be purchased from any vendor or bookseller of your choice.
Required Textbook(s):
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeli 9781118530801
Meeting Schedule
Event Date Day Start Time End Time Location Room
START 06/26/2023 Monday --- --- Online (Access Begins) ---
END 08/20/2023 Sunday --- --- Online (Access Ends) ---