Why should i take this course
Isn't it obvious? Don't you want to be the best ETL, pentaho kettle developer?
The course is the outcome of my 10 year experience with IT projects and business intelligence and data integration with pentaho kettle.
I developed the course because I want to share my knowledge with you.
the best way to learn technological software and concepts is via an online course,
structured by a real developer with actual experience that guide you through his (my) Path to knowledge.
I will help you master ETL with pentaho kettle .
What is the course about?The course is about taking you from the beginning and transfer you to a master of Pentaho kettle .
The main dish of the course is a walk-through of a real pentaho kettle project hands on, case study, tips taking you from easy steps that becomes more and more complex, layer by layer, as you go forward. That way you can learn pentaho kettle as a beginner but also become an expert as you go along (and practice)
Also I cover
Structure of the course
the course is divided 4 main sections:
Section 1: Theory and concepts of data integration in general
(if you already an ETL developer you can skip that)
Section 2: setting up the environment
install and operate the data integration with pentaho kettle.
Including database management and profiling the database as a source.
PDI, navicat (to manage database), jdbc drivers, JRE, sakila database example, mysql and more .
Section 3: the main dish
until the successfully end of the project. Including some 80% of the steps used by pentaho kettle in order to master data integration.
You can see all the steps in the curriculum (it's too many to write them here)
just for the example:
a. Connect to various data sources (databases, files…)
b. manipulate the data
changing strings, dates and calculations, joins, lookups, slowly changing dimensions, consideration of when and how to use different steps.
c. Work with variables
d. outputs steps (bulk load , table output , update/insert , file output…)
Section 4: wrapping up - go to production
You will learn how to:
The list of software we require in order to run and work with Pentaho ETL
JRE is required by Pentaho in order to run
This lecture shows how to install pentaho data integration
This lecture shows how to install navicat
this lecture shows how to install data architect - profile tool for databases
This lecture will show how to install expresso, a tool that acts as wizard for creating regular explressions
This lecture is about Profiling database with power architect
My name is Steinberg itamar,
I am in the field of information technology is for more than 15 years now,
I have a Master's degree (MBA) in information technology is an management.
My BA is also in the area of information technology from the University of Manchester.
During those years I was serving as manager and information technology expert
especially in the field of business intelligence and data integration.
all that time i used Pentaho kettle as the leading Data integration tool.
I started as a developer through team manager of development, head of the application department - responsible for all software, business processes and implementations,
also as project manager, my last role as an employee I was the CIO of the large company.
I was dealing with ERP, CRM business intelligence of course from all aspects of running a business. sales, transportation, customer service, imports, inventory, suppliers and manufacturing.
All of these areas gave me a unique perspective on business processes and how to analyze a company by looking at one large picture – that is the BI.
Of course that in order to combine all of those systems together you'll need data integration.
I have more than eight years working with pentaho kettle.
Six years ago I decided to start my own company - inflow systems and focus myself to business intelligence and data integration.
On those six years I, as CEO, was leading large business intelligence projects.
I hired several employees, very gifted, specific oriented to data integration and business intelligence. We have developed tens of projects from scratch at large companies like Alcatel Lucent (embedded solution), online gaming, binary options (stock market) and traditional businesses like food supplementary and organic food.
Today, I want to give from my knowledge to you because I believe that to share is the right way to go, during my learning phase I was reading a lot of books, struggling with the technology and I think I can make your life easier.