Pentaho for ETL & Data Integration Masterclass - PDI 9
4.5 /5- Offered byUDEMY
Pentaho for ETL & Data Integration Masterclass - PDI 9 at UDEMY Overview
Duration | 10 hours |
Total fee | ₹449 |
Mode of learning | Online |
Credential | Certificate |
Pentaho for ETL & Data Integration Masterclass - PDI 9 at UDEMY Highlights
- Earn a certificate of completion from Udemy
- Learn from 2 downloadable resources & 3 articles
- Get full lifetime access of the course material
- Comes with 30 days money back guarantee
Pentaho for ETL & Data Integration Masterclass - PDI 9 at UDEMY Course details
- For Students who want to have a career in the field of Data warehouse/ETL developer
- For ETL developers and data process automation developers
- For Business managers who want to understand the entire ETL process and become capable of implementing it
- Understanding of the entire data integration process using PDI
- Extracting data from all popular data sources including Excel, JSON, Zipped files, TXT files and even cloud storage
- Cleaning the data using Pentaho Data Integration
- Applying business rules on the data in PDI
- Different types of Data transformations
- Loading the data into different formats
- Managing SQL database using PDI
- Metadata Injection - a powerful tool offered by PDI
- Understanding of the concepts of data marts and data warehouse
- The ETL (extract, transform, load) process is the most popular method of collecting data from multiple sources and loading it into a centralized data warehouse
- The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade
- We have experience in teaching and implementing Pentaho ETL, Pentaho Data Integration (PDI) for data mining and data analysis purposes
- By the end of this course, your confidence in using Pentaho ETL and Pentaho Data Integration (PDI) will soar
- You'll have a thorough understanding of how to use Pentaho for ETL and Pentaho Data Integration (PDI) techniques for study or as a career opportunity
Pentaho for ETL & Data Integration Masterclass - PDI 9 at UDEMY Curriculum
Introduction
Welcome to the course
Pentaho Data Integration (PDI) Installation and Setup
Setting up environment and installing PDI
This is a milestone!
Opening Spoon - The Graphical UI
A simple ETL Demonstration
The example problem statement
Demonstration of a PDI transformation
Demonstration of a PDI Job
Basic Concepts - Theory for foundational understanding
What is ETL?
Data Warehouse, Ops Database and Data mart
Inmon vs Kimball Architecture
ETL vs ELT
The ETL process: The practical part begins here
Data and the ETL process
Data Extraction: Extracting tabular data
Manually entering data into PDI
Inputting Data from a TXT (text) file
Input from multiple CSV files at the same time
Inputting Data from an Excel file
Extracting Data from Zipped files
Data Extraction: Extracting nontabular data
Extracting from XML
Extracting from JSON
Pentaho for ETL & Data Integration Masterclass - PDI 9 at UDEMY Entry Requirements
- Prerequisite: Basic understanding of the data storage concepts will be helpful
- Not mentioned
Other courses offered by UDEMY
Student Forum
Anything you would want to ask experts?
ManagementBusiness AnalyticsBusiness Intelligence ToolsPentaho for ETL & Data Integration Masterclass - PDI 9