Data Quality (DQ) Enterprise

In this course you will use tools to isolate, correct, report on and monitor non-conforming values within sample data sets. In addition to discovery and profiling the quality of your data, this course includes resolution of data quality issues. Both the Data Quality (DQ) and Data Integration (DI) aspects of the Talend Studio are utilized. Web based tools for data quality resolution, reporting and monitoring are also introduced.

Duration 1 day (approximately 7 hours)
Target Audience Anyone who wants to use more advanced features and techniques to cleanse non-conforming data.
Prerequisites Completion of DI Basics and DQ Basics courses (or equivalent knowledge). Basic knowledge of SQL, Java and regex is helpful but not required.
Course Objectives
After completing this class, you will be able to:
  • Navigate the views of Talend Studio in order to access desired functionality
  • Isolate non-conforming data for examination, assessment, and cleansing
  • Remove invalid data from a data set
  • Parse, standardize, and consolidate data before sending it to a destination
  • Cleanse a data set so that it contains only conforming values
  • Startup and use the Data Quality Portal
  • Startup and use the Data Stewardship Console
  • Manage your Workspace
Course Agenda
  • Data cleansing
  • Resolve conflicts
  • Create reports
  • Monitor data quality
  • Manage your Workspace