Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Quality & Profiling with ETL Pentaho DI & DataCleaner
Rating: 3.5 out of 5(48 ratings)
302 students
Created byRajkumar V
Last updated 4/2017
English

What you'll learn

  • Understand the key terms in Data Quality
  • Understand the basics of Pentaho Data Integration and Datacleaner tool
  • Understand how to install and use the tools for creating a Data profiling and cleansing jobs
  • Understand how to Integrate Datacleaner tool with PDI
  • Understand how to automate the key phases of Data Quality Management framework
  • Several hands on sessions to understand how to implement data quality jobs, data profiling jobs and how to schedule these jobs

Course content

8 sections43 lectures1h 42m total length
  • Introduction to Target Audience and Key Takeaways2:14

    A brief introduction about the Target Audience and what one could Benefit from this course.

  • Why to bother about Data Quality?1:57

    This lecture focuses on explaining the Importance of Data Quality in any business domain and the Consequences when not ensuring data quality.

  • Course Outline3:42

    This lecture focuses on to list what other lectures in the entire course will cover in a brief manner.

Requirements

  • You should have an exposure to Linux and basic shell commands

Description

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. 

Downloadable Resources

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.

Who this course is for:

  • Developers on ETL, Database, Data Warehouse and BI domain
  • Testers on ETL, Database, Data Warehouse and BI domain
  • Automation builders
  • Data Governance professionals
  • Quality Analysts
  • Beginners or Newbies who are not familiar with Data Quality or PDI or DataCleaner tool but willing to learn on these areas