MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Advanced Integration Services

Course Summary

This course teaches how to work with Integration Services packages in the context of a data warehouse development project to perform extract, transform, and load operations.

  • +

    Course Syllabus

    Data Warehousing Packages, Part I
    - 57m 46s

    —Introduction 1m 17s
    —Introduction to Data Warehousing 4m 32s
    —Dimensional Modeling 5m 41s
    —Data Profiling 2m 5s
    —Demo: Data Profiling 8m 22s
    —ETL Design Patterns 2m 58s
    —Extract Package 3m 57s
    —Demo: Extracting to Staging Tables 12m 4s
    —Load Patterns 1m 50s
    —Fact Extract for Ongoing Load 3m 16s
    —Demo: Extracting Records Since Last Load 7m 58s
    —Summary 3m 46s
    Data Warehousing Packages, Part II
    - 49m 34s

    —Introduction 0m 51s
    —Slowly Changing Dimensions 2m 52s
    —Dimension Load Patterns: Type 0, Type 1, and Type 2 4m 42s
    —Dimension Load Package 0m 54s
    —Demo: Transforming and Loading Data for Type 0 7m 25s
    —Demo: Loading Data with the Slowly Changing Dimension Wizard 13m 34s
    —Fact Table Design Patterns 1m 39s
    —Demo: Performing ETL for a Fact Table 6m 33s
    —Demo: Selecting Data for Ongoing Fact Table Load 1m 41s
    —Analysis Services Objects 0m 52s
    —Demo: Using the Analysis Services Task 4m 22s
    —Demo: Orchestrating the ETL Process 2m 38s
    —Summary 1m 31s
    Data Cleansing
    - 1h 13m
    Package Performance
    - 38m 45s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url