View Schedule

What you will learn:

At the end of this course students will go through the basis of a BI System Architecture.
After learning what an ETL is and which are its objectives, participants will go through the different phases of an ETL and they will be qualified to discuss about SDE and SIL mappings design and every single thing related to the Metadata concept.

Course Description:

The goals of the ETL Design training course are:

• To understand the different phases of an ETL process.
• To provide the techniques to design an ETL.
• To discuss the challenges to be faced during an ETL and provide design solutions to each of them to prevent any issue.
• To introduce metadata and effective metadata management.

Target Audience:

• BI Consultants – understand the specifics of each ETL block and component, and get the tools to overcome the technical difficulties to be found in each of them
• IT Project Managers – get an idea of the cost involved in an ETL design to better estimate and manage your BI project

Topics Covered:

• Architecture of a BI system
• Definition and Objectives of an ETL
• Extract
• Clean
• Conform
• Deliver
• Metadata management: business, mapping & workflow definition, execution

Pre-requisites:

Basic dimensional modeling knowledge is needed to enroll this course. 

Languages

ETL design is offered in English and Spanish (training material is only available in English).

View Schedule