Data Quality Profiling with ETL Pentaho DI DataCleaner

Data Quality & Profiling with ETL Pentaho DI & DataCleaner, available at $19.99, has an average rating of 3.95, with 43 lectures, 3 quizzes, based on 47 reviews, and has 298 subscribers.

You will learn about 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 This course is ideal for individuals who are Developers on ETL, Database, Data Warehouse and BI domain or Testers on ETL, Database, Data Warehouse and BI domain or Automation builders or Data Governance professionals or Quality Analysts or Beginners or Newbies who are not familiar with Data Quality or PDI or DataCleaner tool but willing to learn on these areas It is particularly useful for Developers on ETL, Database, Data Warehouse and BI domain or Testers on ETL, Database, Data Warehouse and BI domain or Automation builders or Data Governance professionals or Quality Analysts or Beginners or Newbies who are not familiar with Data Quality or PDI or DataCleaner tool but willing to learn on these areas.

Enroll now: Data Quality & Profiling with ETL Pentaho DI & DataCleaner

Summary

Title: Data Quality & Profiling with ETL Pentaho DI & DataCleaner

Price: $19.99

Average Rating: 3.95

Number of Lectures: 43

Number of Quizzes: 3

Number of Published Lectures: 43

Number of Published Quizzes: 3

Number of Curriculum Items: 46

Number of Published Curriculum Objects: 46

Original Price: $24.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: What does this Course cover?

Lecture 1: Introduction to Target Audience and Key Takeaways

Lecture 2: Why to bother about Data Quality?

Lecture 3: Course Outline

Chapter 2: Building the Foundation

Lecture 1: Key Terminologies and Concepts in Data Quality

Chapter 3: Tools Introduction And Installation

Lecture 1: Why to use a tool for DQA Tasks?

Lecture 2: Introduction to Pentaho Data Integration or Kettle

Lecture 3: Introduction to DataCleaner

Lecture 4: Installation of PDI

Lecture 5: Installation of DataCleaner in Stand-alone mode

Lecture 6: Installation of DataCleaner as Plug-in with PDI

Chapter 4: Working with DataCleaner

Lecture 1: Section Outline

Lecture 2: Connecting a Datastore with DataCleaner

Lecture 3: Designing a Job with DataCleaner

Lecture 4: Previewing or Executing a DataCleaner Job

Lecture 5: Preserving Cleansed data with DataCleaner

Lecture 6: Command line options

Lecture 7: Executing a DataCleaner Job in Command line

Lecture 8: Scheduling a DataCleaner Job

Lecture 9: Parameterizable DataCleaner Jobs

Lecture 10: Configuration in DataCleaner

Lecture 11: Logging in DataCleaner

Lecture 12: Logging in PDI

Chapter 5: Integrating DataCleaner with PDI

Lecture 1: Section Outline

Lecture 2: Creating a Job with PDI

Lecture 3: Creating a Transformation with PDI

Lecture 4: Executing a DataCleaner Job in PDI

Lecture 5: Scheduling a PDI Job

Chapter 6: Walk Through on Demo Use Cases

Lecture 1: Section Outline

Lecture 2: Data Quality Dimensions – Use Cases – Part 1

Lecture 3: Data Quality Dimensions – Use Cases – Part 2

Lecture 4: Data Quality Dimensions – Use Cases – Part 3

Lecture 5: Data Profiling and Other Use Cases

Chapter 7: Demo

Lecture 1: Demo on Completeness

Lecture 2: Demo on Conformity

Lecture 3: Demo on Referential Integrity

Lecture 4: Demo on Validity

Lecture 5: Demo on Accuracy

Lecture 6: Demo on Duplicate check – Single field

Lecture 7: Demo on various Data Profiling Tasks

Lecture 8: Demo on Duplicate check – Multiple fields and Adhoc Profiling

Lecture 9: Demo on Integrating DataCleaner Job with PDI

Lecture 10: Tips on Automating Data Quality Solution

Chapter 8: What Next?

Lecture 1: Ways to move forward

Instructors

Rajkumar V
Data Architect

Rating Distribution

1 stars: 4 votes

2 stars: 6 votes

3 stars: 14 votes

4 stars: 11 votes

5 stars: 12 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!