Pentaho(PDI) Fundamentals and DWH Concepts

This Pentaho(PDI) course covers the Pentaho fundamentals and Data Warehouse Concepts

Brief Introduction:

What you’ll learn

  • Learn the Basic Overview of Data Warehouse.
  • Learn the difference between Job and Transformation in Pentaho.
  • Learn the different Transformation Steps in Pentaho.
  • See the difference between Parameter and Variable..
  • Learn how to pass a variable and Parameter to Transformation Step.
  • Learn the different types of Joins used in Pentaho.
  • Learn how to apply If else Conditions in Pentaho.
  • Lookup Steps in Pentaho.

Course Content

  • Overview of Data Warehousing –> 5 lectures • 36min.
  • Overview of Dimensional Modeling –> 3 lectures • 28min.
  • Pentaho Data Integration Input and Output Steps –> 6 lectures • 1hr 12min.
  • Pentaho Data Integration Transformation Steps –> 7 lectures • 1hr 4min.
  • Pentaho Data Integration Flow Transformation Steps –> 3 lectures • 26min.
  • Pentaho Data Integration Join Steps –> 5 lectures • 33min.
  • Pentaho Data Integration Transformation Steps Advanced Level –> 4 lectures • 23min.
  • Web Services –> 2 lectures • 15min.
  • SCD & CDC Implementation in Pentaho –> 6 lectures • 1hr 9min.
  • Pentaho Data Integration Jobs –> 4 lectures • 49min.
  • Metadata ETL Injection Step Example –> 2 lectures • 23min.

Pentaho(PDI) Fundamentals and DWH Concepts


Brief Introduction:

Pentaho Data Integration (PDI) provides the Extract, Transform, and Load (ETL) capabilities.Through this process,data is captured,transformed and stored in a uniform format.

Some of the features of Pentaho data integration tool are mentioned below.

  • Data migration between different databases and applications.
  • Huge volume of data can be loaded from different heterogeneous sources.
  • Data Cleansing with steps ranging from very simple to very complex transformations.

Components of Pentaho:

Below are the components of Penatho data integration tool.

  • Spoon.bat—-It is User Interface used to create Jobs and Transformation.
  • Pan.Bat——It is used to run transformation from the command line.
  • Kitchen.Bat—It is used to run Jobs from the command line.
  • Carte.Bat—-Execute your Jobs and Transformation on Web Server.
  • Encr.Bat——Helps you to generate encrypted passwords.

Career Perspective:

If you want to pursue a career as an ETL developer,you should definitely consider taking this course.Most importantly,If you learn one ETL tool whether it’s Pentaho or Informatica,learning other ETL tools won’t be difficult.Also,the demand of ETL developer is keep on increasing as the data size is increasing.

After this Course:

Once you are done with the course,you will have maximum knowledge of all the transformation steps that are required to clean the data.Furthermore,you can apply all the attained knowledge in the industry.


Have a Great Learning..!!!

Get Tutorial