Talend Open Studio for Data Quality

Talend Open Studio for Data Quality enables business and data analysts to assess the data quality of any data source. Understand the completeness, accuracy and integrity of data in preparation for data migration, instance consolidation, and data integration.

This course is designed to get you up and running with Talend Open Studio for Data Quality as quickly as possible. It helps you learn how to assess the quality of data contained in your information system based on a defined set of metrics and thresholds, using a set of indicators, patterns, and rules for each data element being analyzed or monitored.

 

Talend Open Studio for Data Quality

Duration:

 One day (7 hours)

Target Audience:

 Anyone who wants to use Talend Open Studio for Data Quality to assess data quality.

Prerequisites:

 Familiarity with SQL.

Course Objectives:

 After completing this class, you will be able to:
  • Navigate Talend Open Studio for Data Quality in order to access desired functionality.
  • Connect to a data source and run a data analysis.
  • Examine the contents of a data source connection.
  • Perform a data analysis using the Schema and Catalog analysis tools.
  • Analyze the data retrieved from a single column using a pre-defined pattern.
  • Generate a regular expression to test data quality.
  • Use a custom built-in pattern or a pattern imported from the Talend Exchange to test data quality.
  • Perform a data analysis based on a single column, a single table, multiple columns, and multiple tables.
  • Create and apply a set of business rules to separate non-conforming data from conforming data.

Course Agenda:
  • Connection Analysis
  • Catalog Analysis
  • Single Column Analysis
  • Single Table Analysis
  • Multicolumn Analysis

 

Talend is the leading developer and distributor of open source middleware. The freely available Talend Open Studio makes it faster and easier for developers to build and deploy data integration processes like data migration, data replication, and ETL. Subscription-based enterprise grade solutions from Talend support advanced functionality like change data capture and support for enterprise data governance. Talend also offers open source application integration solutions that leverage and extend popular Apache ESB technologies like Apache Camel, ActiveMQ, CXF, and Karaf.
Apache, the Apache feather logo, and all Apache-related trademarks are the property of the Apache Software Foundation, and are used with permission. Click here for more information.