Pentaho BI & Data Integration Course - Master ETL & Data Warehousing

Unlock your potential in business intelligence and data integration with our expert-led training on Pentaho BI & Data Integration. This comprehensive program is designed to equip you with essential skills in ETL processes, real-time data scenarios, and advanced transformation techniques. Gain hands-on experience in connecting to big data sources and automating tasks while mastering best practices for performance optimization. Enroll now to transform your career with cutting-edge knowledge.

Face-to-Face Nov 11-13, 2026 9:00 AM - 5:00 PM Tasmeea Rahman
updated
intermediate
Pentaho BI & Data Integration
We price match

Public Pricing

MYR 5250

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 19500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 9000 ++

Features

3 days
24 modules
4 intakes
Full life-time access
English, Malay
Technical: 25 pax

Target Audience

students
engineers

Methodologies

lecture
slides
labs
q&A

Subsidies

HRDC Claimable logo

What you'll learn

  • Connect PDI to relational databases and big data sources like Hadoop.
  • Apply best practices for ETL process optimization and performance tuning.
  • Understand the components of the Pentaho BI Suite and their roles in business intelligence.
  • Implement real-time ETL solutions using streaming data.
  • Automate tasks using PDI job scheduling for efficient workflow management.
  • Design basic transformations and handle various data types within PDI.
  • Install and configure Pentaho Data Integration effectively.

Why should you attend?

This course provides a comprehensive exploration of the Pentaho Business Intelligence Suite and its Data Integration capabilities. Participants will begin with an introduction to the fundamental concepts of business intelligence and data integration, gaining insights into how these elements are crucial for modern data-driven decision-making. The course then delves into the components of the Pentaho suite, emphasizing the role of ETL (Extract, Transform, Load) processes in effective data integration. Learners will be guided through the installation and configuration of Pentaho and PDI (Pentaho Data Integration), ensuring they understand system requirements and can navigate the Pentaho User Console efficiently. The course also covers designing basic transformations, handling various data types, and working with multiple file formats, providing a solid foundation in managing and transforming data. Advanced topics include real-time data integration scenarios, complex transformation logic, error handling, and debugging techniques. Participants will explore connecting to big data sources like Hadoop and NoSQL databases, automating tasks with job scheduling, and understanding key data warehousing concepts such as dimensional modeling and fact tables. The course concludes with best practices for optimizing ETL processes and performance tuning. By the end of this training, participants will have developed a robust skill set in using Pentaho for comprehensive data integration solutions.

Course Syllabus

Day 1 - PDI Fundamentals & Setup
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Advanced Transformations & Integration
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2
Day 3 - Data Warehousing & OLAP
Module 17
Module 18
Short Break
15 mins
Module 19
Module 20
Recap and Q&A
15 mins
Lunch
1 hour
Module 21
Module 22
Short Break
15 mins
Module 23
Module 24
Recap and Q&A
15 mins
End of Day 3

Instructor

Loading...
Tasmeea Rahman Data Analytics & Engineering Training Specialist
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
TTT Accreditation
TTT Accreditation
Tasmeea Rahman is a highly accomplished corporate trainer and academic professional with a unique blend of technical expertise and pedagogical excellence. Currently pursuing her PhD in Project Management with a focus on Energy Management in the electrical power industry at Universiti Putra Malaysia, she maintains an exceptional 4.00/4.00 CGPA while actively contributing to the professional training landscape. With extensive experience as a Freelance Corporate Trainer since 2023, Tasmeea specializes in delivering comprehensive training programs across multiple domains. Her training portfolio encompasses advanced data analytics tools including Python, Power BI, Minitab, Jaspersoft, Apache Superset, and TIBCO Spotfire, as well as machine learning applications. She also excels in teaching engineering design software such as AutoCAD, Autodesk Fusion 360, Solid Edge, and Autodesk 3Ds Max for both 2D and 3D electrical and mechanical designs. Her project management training capabilities further complement her diverse skill set. Her academic credentials are impressive, holding a Master of Engineering Management from Universiti Putra Malaysia (CGPA: 3.713/4.00), an MBA in Marketing from the University of Dhaka (CGPA: 3.61/4.00), and a Bachelor's degree in Electrical and Electronics Engineering. This multidisciplinary educational background enables her to bridge technical concepts with business applications effectively. As an Adjunct Lecturer at Leading University, she demonstrated her ability to develop curricula and deliver engaging lectures on complex electrical and electronics subjects, including VLSI design, digital signal processing, and microprocessor systems. Tasmeea's research contributions are noteworthy, with publications in high-impact journals including a first-author paper in Renewable and Sustainable Energy Reviews (Q1, Impact Factor: 15.9) and co-authored works in IEEE Access. She holds a Train the Trainer Certification from HRD Corp Malaysia and is certified in Agile Project Management by Google. Her technical proficiency spans programming languages like Python and C++, engineering software including MATLAB and CISCO Packet Tracer, and various data analytics platforms. With her combination of industry experience, academic rigor, and certified training expertise, Tasmeea delivers practical, industry-relevant training that empowers professionals to excel in their respective fields.
8 Students
93 Courses
8 Years

Instructor

Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
108 Courses
18 Years

Instructor Reviews

TR

Tasmeea Rahman

Data Analytics & Engineering Training Specialist

"Tasmeea was an excellent teacher. Very pleasant, willing to assist and answer concerns, and continuously asked how she could assist more. She made the course enjoyable as well as informative."

"Thank you so much for your invaluable guidance. I really enjoyed it and appreciated how much fun you made it! I feel much more equipped to cope with difficult challenges."

"The training was both fascinating and beneficial. Many members of the staff commented on how useful it was. Tasmeea delivers the topic with authority, wit, and passion."

ML

Mohammad Mehdi Lotfinejad

Chief Data Officer & Data Science Trainer

"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."

"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."

"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."

FAQ

Frequently Asked Questions About This Course

Why should you attend?

This course provides a comprehensive exploration of the Pentaho Business Intelligence Suite and its Data Integration capabilities. Participants will begin with an introduction to the fundamental concepts of business intelligence and data integration, gaining insights into how these elements are crucial for modern data-driven decision-making. The course then delves into the components of the Pentaho suite, emphasizing the role of ETL (Extract, Transform, Load) processes in effective data integration. Learners will be guided through the installation and configuration of Pentaho and PDI (Pentaho Data Integration), ensuring they understand system requirements and can navigate the Pentaho User Console efficiently. The course also covers designing basic transformations, handling various data types, and working with multiple file formats, providing a solid foundation in managing and transforming data. Advanced topics include real-time data integration scenarios, complex transformation logic, error handling, and debugging techniques. Participants will explore connecting to big data sources like Hadoop and NoSQL databases, automating tasks with job scheduling, and understanding key data warehousing concepts such as dimensional modeling and fact tables. The course concludes with best practices for optimizing ETL processes and performance tuning. By the end of this training, participants will have developed a robust skill set in using Pentaho for comprehensive data integration solutions.


What you'll learn

  • Connect PDI to relational databases and big data sources like Hadoop.
  • Apply best practices for ETL process optimization and performance tuning.
  • Understand the components of the Pentaho BI Suite and their roles in business intelligence.
  • Implement real-time ETL solutions using streaming data.
  • Automate tasks using PDI job scheduling for efficient workflow management.
  • Design basic transformations and handle various data types within PDI.
  • Install and configure Pentaho Data Integration effectively.

Course Syllabus

Day 1 - PDI Fundamentals & Setup
Module 1
Module 2
Short Break
15 mins
Module 3
Module 4
Recap and Q&A
15 mins
Lunch
1 hour
Module 5
Module 6
Short Break
15 mins
Module 7
Module 8
Recap and Q&A
15 mins
End of Day 1
Day 2 - Advanced Transformations & Integration
Module 9
Module 10
Short Break
15 mins
Module 11
Module 12
Recap and Q&A
15 mins
Lunch
1 hour
Module 13
Module 14
Short Break
15 mins
Module 15
Module 16
Recap and Q&A
15 mins
End of Day 2
Day 3 - Data Warehousing & OLAP
Module 17
Module 18
Short Break
15 mins
Module 19
Module 20
Recap and Q&A
15 mins
Lunch
1 hour
Module 21
Module 22
Short Break
15 mins
Module 23
Module 24
Recap and Q&A
15 mins
End of Day 3

Instructor Reviews

Tasmeea Rahman

Tasmeea Rahman

Data Analytics & Engineering Training Specialist

"Tasmeea was an excellent teacher. Very pleasant, willing to assist and answer concerns, and continuously asked how she could assist more. She made the course enjoyable as well as informative."

"Thank you so much for your invaluable guidance. I really enjoyed it and appreciated how much fun you made it! I feel much more equipped to cope with difficult challenges."

"The training was both fascinating and beneficial. Many members of the staff commented on how useful it was. Tasmeea delivers the topic with authority, wit, and passion."

Mohammad Mehdi Lotfinejad

Mohammad Mehdi Lotfinejad

Chief Data Officer & Data Science Trainer

"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."

"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."

"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."

We price match

Public Pricing

MYR 5250

Corporate Pricing

Pax:

Training Fees: MYR 6500/day
Total Fees: MYR 19500 ++

Training Provider Pricing

Pax:

Training Fees: MYR 2800/day
Material Fees: MYR 600
Total Fees: MYR 9000 ++

Features

3 days
24 modules
4 intakes
Full life-time access
English, Malay
Technical: 25 pax

Target Audience

students
engineers

Methodologies

lecture
slides
labs
q&A

Subsidies

HRDC Claimable logo

Instructors

Loading...
Tasmeea Rahman Data Analytics & Engineering Training Specialist
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
TTT Accreditation
TTT Accreditation
Tasmeea Rahman is a highly accomplished corporate trainer and academic professional with a unique blend of technical expertise and pedagogical excellence. Currently pursuing her PhD in Project Management with a focus on Energy Management in the electrical power industry at Universiti Putra Malaysia, she maintains an exceptional 4.00/4.00 CGPA while actively contributing to the professional training landscape. With extensive experience as a Freelance Corporate Trainer since 2023, Tasmeea specializes in delivering comprehensive training programs across multiple domains. Her training portfolio encompasses advanced data analytics tools including Python, Power BI, Minitab, Jaspersoft, Apache Superset, and TIBCO Spotfire, as well as machine learning applications. She also excels in teaching engineering design software such as AutoCAD, Autodesk Fusion 360, Solid Edge, and Autodesk 3Ds Max for both 2D and 3D electrical and mechanical designs. Her project management training capabilities further complement her diverse skill set. Her academic credentials are impressive, holding a Master of Engineering Management from Universiti Putra Malaysia (CGPA: 3.713/4.00), an MBA in Marketing from the University of Dhaka (CGPA: 3.61/4.00), and a Bachelor's degree in Electrical and Electronics Engineering. This multidisciplinary educational background enables her to bridge technical concepts with business applications effectively. As an Adjunct Lecturer at Leading University, she demonstrated her ability to develop curricula and deliver engaging lectures on complex electrical and electronics subjects, including VLSI design, digital signal processing, and microprocessor systems. Tasmeea's research contributions are noteworthy, with publications in high-impact journals including a first-author paper in Renewable and Sustainable Energy Reviews (Q1, Impact Factor: 15.9) and co-authored works in IEEE Access. She holds a Train the Trainer Certification from HRD Corp Malaysia and is certified in Agile Project Management by Google. Her technical proficiency spans programming languages like Python and C++, engineering software including MATLAB and CISCO Packet Tracer, and various data analytics platforms. With her combination of industry experience, academic rigor, and certified training expertise, Tasmeea delivers practical, industry-relevant training that empowers professionals to excel in their respective fields.
8 Students
93 Courses
8 Years
Loading...
Mohammad Mehdi Lotfinejad Chief Data Officer & Data Science Trainer
Trainer Profile
Trainer Profile
TTT Certificate
TTT Certificate
Mohammad Mehdi Lotfinejad is a distinguished Chief Data Officer and certified HRDF trainer with over 15 years of experience in computer science instruction and professional data science training. Currently serving as Chief Data and Knowledge Officer at Magna.ai, a Florida-based lawtech company, he leads the development of sophisticated graph databases, data warehouses, and API solutions that power AI-driven legal case analysis systems. His expertise spans the entire data ecosystem, from architecture design to workflow automation and team leadership. With a robust background encompassing more than a decade of hands-on experience in data engineering and data science, Mohammad has successfully implemented enterprise-scale data processing pipelines across multiple industries and geographies. His professional journey includes senior roles at Axiata Digital Advertising (ADA) in Malaysia, where he designed and deployed data pipelines using AWS Redshift, Snowflake, Apache Spark, and Apache Airflow, and at The Center of Applied Data Science, where he led teams delivering training solutions to major corporations including CIMB, PETRONAS, SHELL, and TNB. Mohammad's technical proficiency is comprehensive and current, encompassing cloud platforms (AWS, Google Cloud), data warehousing solutions (Redshift, Snowflake), big data technologies (Apache Spark, Hadoop, Hive), workflow orchestration (Apache Airflow), and multiple database systems (MySQL, PostgreSQL, MongoDB). He holds a Harvard Business School certification in Business Analytics and multiple AWS certifications, including specialized credentials in Big Data, Data Warehousing, and Practical Data Science with Amazon SageMaker. As an educator, Mohammad brings exceptional depth to his training delivery. His academic career includes faculty positions at Payame Noor University and Islamic Azad University, where he served in leadership roles including Chancellor and Department Head. He has authored three technical books and published numerous peer-reviewed papers in international journals. His teaching repertoire covers data engineering, data science, machine learning, software development, and computer architecture, delivered through engaging, hands-on methodologies that bridge theoretical concepts with practical industry applications. Mohammad's unique combination of executive leadership, technical expertise, and proven training capabilities makes him an invaluable resource for organizations seeking to develop their data science and engineering capabilities. His ability to translate complex technical concepts into actionable learning outcomes, coupled with his extensive real-world implementation experience, ensures that training participants gain immediately applicable skills that drive business value.
8 Students
108 Courses
18 Years

FAQ

Frequently Asked Questions About This Course

Close menu