Talend Data Quality Essentials | Agilitics

Login

Register

Login

Register

Buy Courses

Talend Data Preparation Cloud
January 9, 2018
Talend Data Stewardship
January 9, 2018
Show all

Talend Data Quality Essentials

Category:
Description

No. of Days: 2

Target audience Anyone who wants to use Talend Studio for Data Quality to assess data quality
Prerequisites Completion of Talend Data Integration Basics, familiarity with SQL
Course objectives After completing this course, you will be able to:

  • Connect to a database and run an analysis on it
  • Examine the contents of a connection to a data source
  • Create, configure, and run a column analysis
  • Generate regular expressions for pattern matching in an analysis to test data quality
  • Define indicator thresholds that are flagged in analysis results when violated
  • Create, configure, and run different types of table analysis
  • Define a SQL business rule and set up an analysis to identify rows that conflict with your rule
  • Create, configure, and run a table match analysis to search for duplicates
  • Use advanced matching to enhance identification of duplicates
  • Ensure data privacy by shuffling and masking customer data
  • Display analysis reports in PDF files and on Data Quality Portal
Course agenda Structural analysis

  • Creating a database connection
  • Performing structural analyses

Column analysis

  • Performing a basic column analysis
  • Adding regular expressions
  • Defining indicator thresholds
  • Applying advanced statistics
  • Generating Jobs from an analysis

Table analysis

  • Using a column set analysis
  • Using a business rule analysis

Cross-table analysis

  • Using redundancy analysis

Advanced matching

  • Getting ready for match analysis
  • Reviewing the match analysis process
  • Performing a match analysis
  • Configuring additional settings for the table match analysis
  • Using a matching integration Job

Data privacy

  • Shuffling data for privacy
  • Masking data for privacy

Reports and Data Quality portal

  • Configuring the Data Quality database
  • Creating a report
  • Creating an evolution report
  • Configuring Data Quality Portal
  • Running reports on Data Quality Portal
Reviews (0)

Reviews

There are no reviews yet.

Be the first to review “Talend Data Quality Essentials”

Your email address will not be published. Required fields are marked *

Request a Call Back
Request For Demo