PDI 10
Use Pentaho Data Integration tool for ETL & Data warehousing. Do ETL development using PDI 10 without coding background
Lo que serás capaz de hacer
What is ETL? 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. ETL is an essential component of data warehousing and analytics. Why Pentaho for ETL? Pentaho has phenomenal ETL, data analysis, metadata management and reporting capabilities. Pentaho is faster than other ETL tools (including Talend). Pentaho has a user-friendly GUI which is easier and takes less time to learn. Pentaho is great for beginners . Also, Pentaho Data Integration (PDI) is an important skill in data analytics field. How much can I earn? In the US, median salary of an ETL developer is $74,835 and in India average salary is Rs. 7,06,902 per year. Accenture, Tata Consultancy Services, Cognizant Technology Solutions, Capgemini, IBM, Infosys etc. are major recruiters for people skilled in ETL tools; Pentaho ETL is one of the most sought-after skills that recruiters look for. Demand for Pentaho Data Integration (PDI) techniques is increasing day after day. What makes us qualified to teach you? 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. We are also the creators of some of the most popular online courses - with over 150,000 enrollments and thousands of 5-star reviews like these ones: I had an awesome moment taking this course. It broaden my knowledge more on the power use of Excel as an analytical tools. Kudos to the instructor! - Sikiru Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand Our Promise Teaching our students is our job and we are committed to it. If you have any questions about the course content on Pentaho, ETL, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message. Download Practice files, take Quizzes, and complete Assignments With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts on Pentaho, ETL, Pentaho Data Integration, Pentaho ETL. Each section contains a practice assignment for you to practically implement your learning on Pentaho, ETL, Pentaho Data Integration, Pentaho ETL. Solution to Assignment is also shared so that you can review your performance. 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. Go ahead and click the enroll button, and I'll see you in lesson 1 of this Pentaho ETL course! Cheers Start-Tech Academy
- 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
Temario
UNIDAD 1 - Introduction · 2 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction
- Welcome to the course
- Course Resources
UNIDAD 2 - Pentaho Data Integration (PDI) Installation and Setup · 4 leccionesUNIDAD 2 - Pentaho Data Integration (PDI) Installation and Setup
UNIDAD 2 - Pentaho Data Integration (PDI) Installation and Setup
- Setting up environment and installing PDI
- This is a Milestone!
- Opening Spoon - The Graphical UI
- Quiz
UNIDAD 3 - A Simple ETL Demonstration · 4 leccionesUNIDAD 3 - A Simple ETL Demonstration
UNIDAD 3 - A Simple ETL Demonstration
- The Example Problem Statement
- Demonstration of a PDI transformation
- Demonstration of a PDI Job
- Quizzes
UNIDAD 4 - Basic concepts - Theory for foundational understanding · 6 leccionesUNIDAD 4 - Basic concepts - Theory for foundational understanding
UNIDAD 4 - Basic concepts - Theory for foundational understanding
- What is ETL?
- Check your understanding
- Data Warehouse, Ops Database and Data mart
- Inmon vs Kimball Architecture
- ETL vs ELT
- Quiz
UNIDAD 5 - The ETL process: The practical part begins here · 2 leccionesUNIDAD 5 - The ETL process: The practical part begins here
UNIDAD 5 - The ETL process: The practical part begins here
- Data and the ETL process
- Quiz
UNIDAD 6 - DATA EXTRACTION: Extracting tabular data · 6 leccionesUNIDAD 6 - DATA EXTRACTION: Extracting tabular data
UNIDAD 6 - 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
- Quizzes
UNIDAD 7 - DATA EXTRACTION: Extracting non-tabular data · 2 leccionesUNIDAD 7 - DATA EXTRACTION: Extracting non-tabular data
UNIDAD 7 - DATA EXTRACTION: Extracting non-tabular data
- Extracting from XML
- Extracting from JSON
UNIDAD 8 - Extracting from an SQL table · 4 leccionesUNIDAD 8 - Extracting from an SQL table
UNIDAD 8 - Extracting from an SQL table
- Plan for importing sales data
- Installing PostgreSQL and pgAdmin in your System
- Creating Sales table in SQL
- Extracting from an SQL table
UNIDAD 9 - Storing and Retrieving Data from Cloud storage · 2 leccionesUNIDAD 9 - Storing and Retrieving Data from Cloud storage
UNIDAD 9 - Storing and Retrieving Data from Cloud storage
- Storing Data on AWS S3
- Reading data from AWS S3
UNIDAD 10 - Merging Data Streams · 6 leccionesUNIDAD 10 - Merging Data Streams
UNIDAD 10 - Merging Data Streams
- Concepts: Merging Data Streams
- Sorted Merge Step - Merging customer data
- Merging product data
- Time to check your understanding
- Append data stream - merging sales data
- Time to check your understanding
UNIDAD 11 - Data Cleansing · 13 leccionesUNIDAD 11 - Data Cleansing
UNIDAD 11 - Data Cleansing
- Introduction to Data Cleansing
- Value Mapper Step
- Replace in String Step
- Time to check your understanding
- Fuzzy Match concepts
- Fuzzy Match Step in PDI
- Fuzzy Match Algorithms
- Time to check your understanding
- Formula Step and changing data format
- Common Data Cleaning Steps
- Quiz
- About the upcoming role play.
- Explaining Data Cleansing Techniques in an Interview Setting
UNIDAD 12 - Data Validation · 7 leccionesUNIDAD 12 - Data Validation
UNIDAD 12 - Data Validation
- Introduction to Data validation
- Data_validation 1 - String-to-Int and integer range validations
- Data validation 2 - Checking Reference Values using stream look-up
- Data validation 3 - Order date < shipping date using calculator step
- Common Data Validation steps
- Quiz
- Roleplay
UNIDAD 13 - Error Handling · 6 leccionesUNIDAD 13 - Error Handling
UNIDAD 13 - Error Handling
- Correcting the errors and merging with main stream
- Time to check your understanding
- Writing the errors to the log
- Time to check your understanding
- Writing the errors to a separate file
- Time to check your understanding
UNIDAD 14 - Transformation and Analytics steps · 5 leccionesUNIDAD 14 - Transformation and Analytics steps
UNIDAD 14 - Transformation and Analytics steps
- Concatenating Address Fields
- Data Aggregation using Group-by
- Normalization and Denormalization
- Number Range Step
- Quiz
UNIDAD 15 - PDI SQL Connection · 4 leccionesUNIDAD 15 - PDI SQL Connection
UNIDAD 15 - PDI SQL Connection
- Introduction to PDI - SQL connection
- Reading and filtering data from DB into PDI
- Updating and Inserting data into DB from PDI
- Deleting data from SQL DB using PDI
UNIDAD 16 - Conceptual understanding for Loading Data · 7 leccionesUNIDAD 16 - Conceptual understanding for Loading Data
UNIDAD 16 - Conceptual understanding for Loading Data
- Facts and Dimensions tables
- Time to check your understanding
- Surrogate Keys in Dimension tables
- Type 1 & 2 Slowly Changing Dimensions
- Time to check your understanding
- Schemas
- Quiz
UNIDAD 17 - Loading the data into a Data Mart · 4 leccionesUNIDAD 17 - Loading the data into a Data Mart
UNIDAD 17 - Loading the data into a Data Mart
- Creating tables in DB
- Loading Customer Data using combination lookup/ update step
- Loading product data using dimension lookup step
- Loading sales data after database lookup steps
UNIDAD 18 - Running Java and Javascript · 1 leccionesUNIDAD 18 - Running Java and Javascript
UNIDAD 18 - Running Java and Javascript
- Scripting Steps
UNIDAD 19 - PDI Jobs · 8 leccionesUNIDAD 19 - PDI Jobs
UNIDAD 19 - PDI Jobs
- PDI Jobs vs Transformation
- Controlling the flow of execution
- Setting variables using set variables step
- File and Folder Management
- Sending Email Step
- Abort Job Step
- Time to check your understanding
- AI Features in Pentaho (The Latest Updates You Must Know)
UNIDAD 20 - Scheduling a job for production environment · 1 leccionesUNIDAD 20 - Scheduling a job for production environment
UNIDAD 20 - Scheduling a job for production environment
- Running using command prompt and scheduling
UNIDAD 21 - Metadata injection · 1 leccionesUNIDAD 21 - Metadata injection
UNIDAD 21 - Metadata injection
- Metadata injection
UNIDAD 22 - Regex Notation · 1 leccionesUNIDAD 22 - Regex Notation
UNIDAD 22 - Regex Notation
- Regular Expressions for advanced String Matching
UNIDAD 23 - Congratulations and about your certificate · 6 leccionesUNIDAD 23 - Congratulations and about your certificate
UNIDAD 23 - Congratulations and about your certificate
- About the upcoming roleplay
- Practice Interview
- Alternative to Pentaho
- The final milestone!
- About your certificate
- Bonus Lecture
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
23 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
20 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Start-Tech Academy.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 23 unidades · 102 lecciones · 60 h
- 12 meses de acceso
- 20 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Start-Tech Academy; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
