Learn the key terminologies, basic concepts, implementation techniques that you will need to build fully functional data quality implementations with the popular ETL tool - Pentaho Data Integration and Data Quality tool - DataCleaner. Learn by comprehensive hands-on sessions to improve the data quality by profiling, cleansing and automating the DQM process with tools.
The concepts learned in this course can be applied in other ETL or Data Quality assurance tool as well.
Take care of the data to take care of the business
Learning the fundamentals and understanding the implementation of Data Quality tasks is something very imperative for any business to keep up in this competitive world. Ensuring the data quality will keep your business or projects from losses.
There are plenty of opportunities in data domain, and being able to learn and appreciate the importance of data quality will give you a confidence to tackle the challenges that you encounter while handling data of any volume and format.
Content and Overview
Through this 8 session course, 43 lectures and 103 minutes of content, you will learn the key terms in Data Quality, basics of Pentaho Data Integration and Datacleaner tool, how to install the tools, how to automate the key data quality and data profiling tasks with series of demo sessions.
You can test the knowledge gained through the sessions by attending quizzes and every use case mentioned in the course are explained with demo sessions thereby enabling you to practice the newly learned skills.
You can also download the files (available in the last session of this course) used for demo sessions in the course to practice at your end.
Learners who completes this course will have the knowledge and confidence to implement fully functional automated data quality solutions in the projects.
A brief introduction about the Target Audience and what one could Benefit from this course.
This lecture focuses on explaining the Importance of Data Quality in any business domain and the Consequences when not ensuring data quality.
At the end of this lecture, students will be able to List and Define some of the Key Terms in Data Quality domain.
This lecture focuses on to
As part of this lecture, students will get to know about the Key building blocks of PDI
As part of this lecture, students will get to know about the Key building blocks of DataCleaner
This lecture focuses on how to Install PDI community edition and Verify the installation
This lecture focuses on how to Install DataCleaner community edition and Verify the installation
This lecture focuses on how to Install and Integrate DataCleaner with PDI
This lecture focuses on to List the topics covered as part of this section, that includes various features in DataCleaner tool and how to utilize or implement those features with a series of hands-on demos.
This demo session on DataCleaner focuses on to
This demo session focuses on How to design a job with DataCleaner tool
This demo session focuses on How to Preview or Execute a DataCleaner job.
This demo session focuses on How to store the cleansed data with DataCleaner tool for immediate or later use.
This demo session focuses on various Command line options available with DataCleaner tool.
This demo session focuses on How to execute the job in Command line.
This demo session focuses on
This demo session focuses on
This demo session focuses on to
After this lecture, students will get to know
This lecture focuses on
As part of this demo session, students will learn How to design a job in PDI using Spoon GUI and save it.
Additional resources related to various PDI job entries are added with this lecture.
As part of this demo session, students will learn How to design a Transformation in PDI using Spoon GUI and save it.
Additional resources related to various PDI Transformation steps and instructions to configure database connectivity settings are added with this lecture.
As part of this demo session, students will learn How to execute a job in PDI using Spoon GUI.
As part of this demo session, students will learn
This demo session focuses on explaining
As part of this demo session, students will Takeaway tips to automate data quality solution by
Thank You Note and Resources in form of
Pentaho Data Integration Command Line Utilities
DataCleaner Command Line Options
My name is Rajkumar and I am so excited to contribute the learning from my industrial experience.
With more than a decade of experience in IT, I have spent the majority of my time dealing with "DATA", that includes data modeling, data profiling, cleansing, data transformation, storage, retrieval, optimization, governance, mining and reporting.
I have played various roles in my career that includes Developer, Data Modeler, Tester, Project Lead, Product Consultant, Data Architect, ETL Specialist, Solution Architect, Release Manager etc.
To sum up, I am absolutely passionate about anything to do with "DATA" and I am looking forward to share my passion and knowledge with you!