Business Topics

Data Quality Profiling: understand and analyse data

With our data quality profiling tool you determine the current condition of your data, e.g., before a transfer to another system, for migration, or before the start of a larger data quality project.

Not only does the data quality profiling tool find errors, anomalies, inconsistencies, etc., in your data stocks; it also helps to improve the data quality. Its problem management function also allows projects to be monitored. The data quality profiling tool is used, e.g., for analysing financial, transaction, statistical, and contractual data. 

Typical operational scenarios

Tasks of the data quality profiling tool

  • Cooperative analysis and data quality research
  • Creation of profiles based on snapshots
  • Document, manage and follow data quality problems

Data quality profiling tool functions

  • Profiles at field level

    • Minimum, maximum
    • Value and sample
    • Singularity
    • and much more …

  • Dependency check

    • Values from attribute X are singularly determined by attributes A, B, C 

  • Singularity check

    • Singularity of the combination of attributes A, B, C

  • Join checks

    • Overlap between attributes A, B in table 1 and X, Y in table 2

Problem management functions

  • Problems can be defined at all levels

    • Data repository system
    • Entity (database table)
    • Data field

  • Problems can be referred to particular employees

    • by email notification 
    • with example records

  • Reports about the data profile and problems can be created

    • Overview of problem cases according to selectable criterion
    • Overview of the number of fields remaining to be analysed

The data quality profiling tool is available in the following versions: 

  • Workstation 

    • Typical operational scenario: one-person analysis projects with small data quantities
    • MS-Windows single workplace solution
    • Supports all customary databases and flat files

  • Entry Server 

    • Typical operational scenario: cooperative analysis projects with a few employees, small to medium-sized data quantities
    • Client / server group use – MS-Windows client, MS-Windows server
    • Supports all customary databases and flat files
    • Multiprocessor support

  • Advanced Server 

    • Typical operational scenario: large cooperative analysis projects with many employees, large data quantities
    • Client /server group applications, MS-Windows client, MS-Windows server or UNIX
    • Supports all customary databases and flat files
    • Multiprocessor support