data integration

Extract, Transform and Load (ETL) Development

Discover How to Develop an Effective ETL Process to Populate Data Warehouses from Source Systems

Course Information

$1,495

Cost *

TBD

Date

Designing and developing the ETL process for a data warehouse is the most critical, effort-intensive aspect of data warehouse projects.

In this 2-day Extract, Transform and Load (ETL) course, learn and explore the techniques that result in accurate, complete and easily accessible data — the keys to successful implementation.

Ideal For:

Solution architects, database administrators, database and integration developers and anyone involved in the movement and consolidation of large quantities of data.

TR – Business Intelligence – ETL Development


Really enjoyed this course. Learned a lot! Instructor was knowledgeable and maintained a good pace.

Prerequisites:

Working knowledge of SQL and data access technologies.

Learning Objectives & Approach:

This course is taught through a combination of lecture and hands-on labs using the Microsoft® BI stack.

Upon completion, participants will have a clear understanding of how to design and implement an ETL process that ensures the quality and integrity of a data warehouse.

Key Topics

Understanding the ETL Process

  • Overview: Overcoming common challenges of  ETL implementation
  • Data cleansing and transformation
  • ETL system components

Designing and constructing the ETL process

  • Mapping source data to the dimensional model
  • The phases of the ETL process
  • Incremental vs. full loads of the data warehouse
  • Handling changes in the data, and what do to if it arrives late
  • Processing incomplete or incorrect data
  • Controlling and monitoring the ETL process
  • Ensuring data quality and integrity

Other ETL Considerations

  • Real-time and near real-time considerations
  • Change Data Capture (CDC) techniques

Registration

Extract, Transform and Load (ETL) Development

  • 8:30am - 4:30pm

Courses are also offered privately to teams and organizations looking for more immersive training.

Mentoring services are also available to reinforce or advance learned principles and practices.

Contact us for more information.

* Cost is per participant in Canadian dollars plus GST

You May Like These Other Courses

Improve or master Business Intelligence and Data Management by enrolling in any of our public or private courses. Contact us for further information, and/or to learn about private training options.

Contact us
Arrow to the top