Posts Tagged ‘front’

For those who consider to become a data integration (spoon) pentaho kettle developer

you need to be processed oriented, it is not that programming or PHP it’s more like understanding the requirements from the customer, understand the flow of how the customer runs his business and translate it to a system that allows him to get real information so he/she can decide about actions the company needs to take.

So you need a combination of: understand managers and needs but at the same time to be a technological skilled in order to implement it the right way.
I think the most interesting thing about it is that you become more acquainted of the business than the managers, and because you see the full picture you know what questions need to be asked before starting the project.

What I like in this process the most is to analyze the requirements and then implement it.
From my point of view pentaho kettle is a playground, like a puzzle / logic games that need to be solved. And they pay me for that.

So if you feel that you’re like that, you enjoy interviewing managers and then try to find the right solution to bring data from ridiculous sources and try combining them to one place in logic that will give the manager a way to analyze and decide according.
You came to the right place.

pre requirements (ingredients) for the pentaho kettle course

I built the course for all users of pentaho kettle developers from newbies to experts.
Of course the newbies will gain more knowledge and experience due to the amount of new features and ideas they will meet.
For the more experienced ones , I added

  • case studies
  • specific steps that we don’t use regularly and use of steps In scenarios
  • steps you don’t understand why they created them until you find why
  • tips and tricks

General announcement:

tip 2#: there is no course in the world that will make you understand how to work with this software without serious hands on. You must practice until you get it.
It’s like having a subscription for the gym and not going. (I wonder where are the muscles they promised)

but you should know at least some :

1. database design
2. sql queries

If you dont know SQL then you can search on udemy :
i think this course can be good for you : sql-database-course-for-kettle-tutorial

if you want to be an expert database designer , i suggest you read the “bible” of datawarehouse toolkit
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling

database design and pentaho kettle

link to wikipedia : database design

find more information about pentaho kettle

here are some resources for learning more about pentaho kettle

1 pentaho kettle forum (click here)

2 books
I have them all , because learning is my hobby:
I can remember myself 10 years ago traveling to London with my girlfriend (now she’s my wife) spending six hours at the bookstore for information technologies that nowhere to be find but there, returning home with 12 kg of books on my back.
Then I evolved: my back went backward and the technology went forward.
So I bought books on Amazon. Then they invented the Kindle and now we have gone to online courses.
So udemy became my best friend.

book #1: “pentaho kettle solution” (click here)
created by: Matt Custers – who also developed kettle before it was bought by pentaho, Roland Bouman, Jos von Dongen.
From my point of view this is the “Bible” of pentaho kettle.
It deals with more complex, exotic subject so if I must say I think my course represents 80% of the material that gives you 95% of what you need day by day.
The book me go into details in subjects like:

• Input / output xml
• Unstructured data handling
• Nosql databases (mongo…)
• Web services
• Clustering (scale out on more servers for performance)
I would like to compliment Matt casters for developing one incredible piece of software that helps all of us making better solutions for managers decisions. Great job.

Book #2 : pentaho solutions (click here)
written by: Roland Bouman, Jos von Dongen
very good book also, but these more general about kettle and deals with the whole pentaho suite.

Book #3 : “pentaho 3.2 data integration” (click here)
by Maria carina Roldan it’s a beginning guide to pentaho kettle

3 Examples that comes with the installation of pentaho kettle
under folder data integration you have examples of many steps that you can run with spoon (the bat file that runs kettle) and learn.

4 blogs:

1. My blog here in the website
2. Matt casters blog
3. Roland Bouman blog

I think the combination of my course and the first book : “pentaho kettle solutions” will give you the whole package.