Pentaho(PDI) Fundamentals and DWH Concepts

Pentaho(PDI) Fundamentals and DWH Concepts, available at $54.99, has an average rating of 3.9, with 49 lectures, based on 258 reviews, and has 2103 subscribers.

You will learn about 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 This course is ideal for individuals who are Professionals who want to learn new ETL tool to enhance their career. or Students who want to have a career in the field of Data warehouse/ETL developer It is particularly useful for Professionals who want to learn new ETL tool to enhance their career. or Students who want to have a career in the field of Data warehouse/ETL developer.

Enroll now: Pentaho(PDI) Fundamentals and DWH Concepts

Summary

Title: Pentaho(PDI) Fundamentals and DWH Concepts

Price: $54.99

Average Rating: 3.9

Number of Lectures: 49

Number of Published Lectures: 47

Number of Curriculum Items: 49

Number of Published Curriculum Objects: 47

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Professionals who want to learn new ETL tool to enhance their career.
Students who want to have a career in the field of Data warehouse/ETL developer

Target Audiences

Professionals who want to learn new ETL tool to enhance their career.
Students who want to have a career in the field of Data warehouse/ETL developer

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.

Cheers..!!

Have a Great Learning..!!!

Course Curriculum

Chapter 1: Overview of Data Warehousing

Lecture 1: Overview of OLTP

Lecture 2: Data Warehousing Concepts

Lecture 3: Benefits and Limitations of Data Warehouse

Lecture 4: ETL in Data Warehousing

Lecture 5: ETL vs ELT

Chapter 2: Overview of Dimensional Modeling

Lecture 1: Dimensional Modeling Overview

Lecture 2: Star Schema,Snowflake Schema and Galaxy Schema

Lecture 3: Dimensional Modeling Design Steps

Chapter 3: Pentaho Data Integration Input and Output Steps

Lecture 1: Pentaho Data Integration Tool Installation Guide

Lecture 2: Install Mysql and Connect to Pentaho

Lecture 3: Pentaho Data Integration Components

Lecture 4: PDI Input and Output Steps Part 01

Lecture 5: PDI Input and Output Steps Part 02

Lecture 6: PDI Input and Output Steps Part 03

Chapter 4: Pentaho Data Integration Transformation Steps

Lecture 1: Transformation Steps Part-01

Lecture 2: Transformation Steps Part-02

Lecture 3: Transformation Steps Part-03

Lecture 4: Transformation Steps Part-04

Lecture 5: Transformation Steps Part-05

Lecture 6: Transformation Steps Part-06

Lecture 7: Transformation Steps Part-07

Chapter 5: Pentaho Data Integration Flow Transformation Steps

Lecture 1: Flow Transformation Steps Part-01

Lecture 2: Flow Transformation Steps Part-02

Lecture 3: Flow Transformation Steps Part-03

Chapter 6: Pentaho Data Integration Join Steps

Lecture 1: Inner Join

Lecture 2: Cartesian Product

Lecture 3: Outer Joins

Lecture 4: Pentaho Joins Steps Part-01

Lecture 5: Pentaho Joins Steps Part-02

Chapter 7: Pentaho Data Integration Transformation Steps Advanced Level

Lecture 1: Stream Lookup Step in Pentaho

Lecture 2: Database Lookup Step in Pentaho

Lecture 3: Database Join Step in Pentaho

Lecture 4: Data Validation Step in Pentaho

Chapter 8: Web Services

Lecture 1: Consuming REST Service in Pentaho

Lecture 2: Consuming SOAP Service in Pentaho

Chapter 9: SCD & CDC Implementation in Pentaho

Lecture 1: Slowly Changing Dimensions

Lecture 2: SCD Type 1 Implementation

Lecture 3: SCD Type 2 Implementation

Lecture 4: Change Data Capture(CDC) Implementation

Lecture 5: Change Data Capture – Method 2 Part-01

Lecture 6: Change Data Capture – Method 2 Part-02

Chapter 10: Pentaho Data Integration Jobs

Lecture 1: Overview of Jobs in Pentaho

Lecture 2: Job Steps Part-02

Lecture 3: Parameters and Variables in Pentaho

Lecture 4: Parameter within Scope

Chapter 11: Metadata ETL Injection Step Example

Lecture 1: Pentaho Metadata Injection Part-01

Lecture 2: Pentaho Metadata Injection Part-02

Instructors

Saad Qureshi
Computer Scientist || Freelancer || Programmer

Rating Distribution

1 stars: 4 votes
2 stars: 12 votes
3 stars: 53 votes
4 stars: 100 votes
5 stars: 89 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu