Skip Navigation

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.

  • Details
  • $795
  • January 10, 2022 to March 06, 2022
  • Delivery Mode: Online
  • Reg#: 00234
  • ID/Units: I&C SCI X425.32  (2.50)
    ( Section 1 )
  • Quarter: WINTER 2022

Instructor


Timothy O. Carrington, Ed.D., MSIA, CSP, CSD, CSM is the director of technology and infrastructure for a government contractor. He has worked in the Information Technology industry for two decades, specializing in web application development, database design and architecture, business intelligence, data warehousing, and information assurance. His passion for leadership and innovation has enabled Tim to propel organizations toward technological advances, building distributed teams, and producing world-class applications and solutions. Tim has taught in higher education for more than seven years and is a dedicated lifelong learner.

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
Book - ISBN: 9781118530801
Ralph Kimball, Margy Ross, 3 ed, Wiley

Meeting Schedule

EventDateDayStart TimeEnd TimeLocationRoom
START01/10/2022Monday------Online (Access Begins)---
END03/06/2022Sunday------Online (Access Ends)---