Play Video
Preview this course

Pentaho Data Integration

Use Pentaho Data Integration tool for ETL & Data warehousing. Do ETL development using PDI 9.0 without coding background

0 / 5
Rating
0 +
Students
0 Hrs
Duration

[cl_product_price id=28322]

Price

Pentaho Data Integration

What you'll learn

Data Extraction

Extracting data from all popular data sources including Excel, JSON, Zipped files, TXT files and even cloud storage such as AWS S3

Data Cleaning and validation

Improve the quality of data received from several sources using in-built functions and apply business rules to ensure accuracy

Data manipulation

Transform the data to get more information and insights out of it using functions such as concatenation, aggregation, normalization etc.

Loading the Data into Data-mart

Understand the concept behind Data warehouse & Data marts and use PDI to load the tables into a Data-mart. Also covers Type 1 and Type 2 Slowly changing dimensions

PDI Jobs

Automate the ETL process and add ancillary features such as getting system information, sending emails, file and folder management using PDI jobs

Our Happy Students!

This course is very good. My fear was it will be difficult because I dont use SQL, but I could read a code a bit. But this course turned on the light and Im so happy to took it. Each part is very comprehensive and I downloaded pdf’s, so if I would forgot anything I just check it.

4.5/5

Zoltan Imre Fekete

I learned so much from this course. I love the teaching style of both teachers. Along with the course, there is a pdf format of most of the lectures which will help us to revise these concepts in the future. Anybody who is beginner can learn so much from this course.

5/5

Sanjeev Kumar

Well, if you are a beginner like me, then it’s a best course to have. You will given the exercise after every section which will help you to know, how the question is asked based on the topic you have covered so far, this will also help you to revise what you have learned before.

5/5

Abhishek kumar singh

Course Instructors

Abhishek Bansal

Co-Founder, Instructor

Ex-Airtel, FMS Delhi, IIT Roorkee
Worked as an Acquisition Process owner in a leading telecom company before moving on to learning and teaching technologies like Machine Learning and Artificial Intelligence.

Pukhraj Parikh

Co-Founder, Instructor

Ex-EXL, IIM Ahmedabad, IIT Roorkee
Worked as a Project manager in an Analytics consulting firm. Pukhraj has multiple years of experience working on analytics tools and software.

Course Completion Certificate​

Once you successfully complete the course, Start-Tech Academy will provide you with an industry-recognized course completion certificate

Still confused? Download the complete course syllabus

Course Content

Course Content

Introduction
Pentaho Data Integration (PDI) Installation and Setup
A Simple ETL Demonstration
Basic concepts – Theory for foundational understanding
The ETL process: The practical part begins here
DATA EXTRACTION: Extracting tabular data
DATA EXTRACTION: Extracting non-tabular data
Extracting from an SQL table
Storing and Retrieving Data from Cloud storage
Merging Data Streams
Data Cleansing
Data Validation
1 of 2

Leave a Reply