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
  • $820
  • September 27, 2021 to November 21, 2021
  • Delivery Mode: Online
  • Reg#: 00127
  • ID/Units: I&C SCI X425.32  (2.50)
    ( Section 1 )
  • Quarter: FALL 2021

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.

No textbooks are required for this course.

Meeting Schedule

EventDateDayStart TimeEnd TimeLocationRoom
START09/27/2021Monday------Online (Access Begins)---
END11/21/2021Sunday------Online (Access Ends)---