SCN GmbH

Basics of data quality

Seminar / Training Fundamentals of Data Quality

Analysis of data quality

 

  • Creating a database connection
  • Performing structural analysis
  • Performing basic column analysis
  • Adding regular expressions
  • Defining indicator thresholds
  • Apply advanced statistics
  • Creating jobs from an analysis
  • Using a column set analysis
  • Using a business rule analysis
  • Using redundancy analysis

Advanced Matching

  • Preparing for the matching analysis
  • Reviewing the Matching Analysis Process
  • Performing a matching analysis
  • Configuring additional settings for table matching analysis
  • Using a match integration job
  • Deduplicating addresses

Cleaning up data

  • Cleaning up email addresses
  • Standardizing country codes

Protecting data

  • Shuffling data for privacy
  • Masking data for privacy
  • Masking data based on a pattern

Requirements

Completion of Introduction to Studio or Data Integration Basics, and familiarity with SQL

This seminar has the level "Administration / Basic".

If you are not sure whether this course is the right level for you, you can check this with the trainer in advance.

We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.

Your contacts

What makes our seminars different?

We offer seminars with a high practical relevance. The contents and exercises are geared to your daily tasks in the company and completely dispense with advertising references to other products of the software manufacturer.

All our training courses are manufacturer-independent. This enables us to offer critical considerations of the products themselves and comparisons with competitors of the manufacturer in the seminar. The course contents are our own and derived from the practical experience of our trainers in projects.

Of course, the contents of company seminars can be individually adapted to your needs. Please do not hesitate to contact us.

Oops, an error occurred! Code: 2024112110052212b7ac27