Talend Data Quality Essentials

Who Should Attend?

Complete TALEND DATA INTEGRATION familiar with SQL using TALEND STUDIO to access DATA QUALITY

}
Duration: 2 Days
Training Date
  • 11 September 2020 (KL)

To complete Talend Data Integration familiar with SQL using Talend Studio to access Data Quality.

  • 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
  1. Structural Analysis
    • Creating a database connection
    • Performing structural analyses
  2. Column Analysis
    • Performing a basic column analysis
    • Adding regular expressions
    • Defining indicator thresholds
    • Applying advanced statistics
    • Generating Jobs from an analysis
  3. Table Analysis
    • Using a column set analysis
    • Using a business rule analysis
  4. Cross Table Analysis
    • Using redundancy analysis
  5. 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
  6. Data Privacy
    • Shuffling data for privacy
    • Masking data for privacy
  7. 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

Register Now

Drop us your entry if you are interested to join this course.