ETL – ETL DESIGN

DURATION:

2 Day Course

 

COURSE GOALS:

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 that are faced during an ETL and provide design solutions to each one of them.
  • 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. 

 

PRE-REQUISITES:

Basic dimensional modelling knowledge is needed to enrol this course. 

 

LANGUAGES:

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

 

TOPICS COVERED:

Architecture of a BI system 

 

Definition and Objectives of an ETL 

 

Extract 

  • Definition. 
  • Logical Data Map. 
  • Data Profiling. 
  • Data Analysis. 

 

Clean 

  • Data Cleaning. 
  • Data Quality. 
  • Deliverables. 

 

Conform 

  • Standardize. 
  • Match & Deduplication. 
  • Surviving. 

 

Deliver 

  • Dimension Tables. 
  • Slowly Changing Dimensions. 
  • Fact Tables. 
  • Aggregations. 

 

Operations 

  • ETL Performance. 

 

Metadata management 

  • Business. 
  • Mapping & workflow definition. 
  • Execution. 

 

Real-Time ETL Systems 

  • Partition. 

 

OBI Apps 

SDE & SIL Design. 

 

ETL Best Practices 

RELATED COURSES:

Informatica PowerCenter – Developer

Oracle data integrator

REQUEST MORE INFORMATION

For further information about this course, please fill out the form below.