pentaho kettle etl tutorial materials

Recommended courses on Udemy

• tableau bi course on udemy2015-10-21As an ETL developer, you should know what is the use of the data warehouse you create. learn aBI tool, like tableau. here is a good option: here is the link to it: https://www.udemy.com/tableau-advanced/ students: 600+ rank: 12 (5 starts)...

  Read More
• business data analysis course2015-10-21Its a good idea to learn also about data analysis Its a very related subject here is a good option: the-complete-introduction-to-business-data-analysis here is the link to it: https://www.udemy.com/the-complete-introduction-to-business-data-analysis/ students: 190+ rank: 3 (5 starts)...

  Read More
• Learn mysql database design2015-10-21Mysql database design course To become an ETL pro, one must know all about mysql and databases, If you feel you are not familiar enough with the subject, i strongly  recommend you to go to udemy and take a course. here is a good option: “learn-database-design-with-mysql” here is the link to it: https://www.udemy.com/learn-database-design-with-mysql/ students: 1000+ rank: 22 (5 starts)  ...

  Read More

software and books you should consider having

books

book #1: “pentaho kettle solution”

created by: Matt Custers – who also developed kettle before it was bought by pentaho, Roland Bouman, Jos von Dongen.
I use the book as a reference , when i develop its like a guide to specific things , i bought it as PDF and i just
search before i go and try to find more info online.

From my point of view this is the “Bible” of pentaho kettle.
I think that my course will give you most of the material you need, but to have the complete picture i
recommend buying the book too(and i did). you will need it for the day by day development.
it covers some complex materials:
Unstructured data handling , web services ,xml , Clustering, big data and more
I want to compliment Matt casters for developing pentaho kettle, this is unbelievable for one person to achieve on his own .

Book #2 : pentaho solutions

written by: Roland Bouman, Jos von Dongen
it covers the full pentaho solution and has some parts of kettle as part of the suite.

Book #3 : “pentaho 3.2 data integration”

by Maria carina Roldan it’s a beginning guide to pentaho kettle

book #4: The Data Warehouse Toolkit

author Ralph kimball – The “bible” of dimension modeling , explaining the 34 guidelines to develop an optimize data warehouse
in our case the “target” meaning load of the data.
a must book if you intend to be a top natch ETL developer

softwares

materials for the course