Data Quality Explorer
The Data Quality Explorer is the tool for the carrying out data profiling tasks. You use the Explorer to investigate the actual state of your data, e.g. before transfer to other systems, in migrations or before the start of larger data quality projects. However, the Data Quality Explorer can not only track down errors, anomalies, inconsistencies and much more in your databases, but also assist in improving the data quality. In this regard, it has a function for composing and following up projects, the so-called problem management. The Explorer is used e.g. for the analysis of financial, transaction, statistical or order data.
Typical use scenarios
- Data migration projects
- Data warehouse projects
- Data integration
- Compliance initiatives
- Balanced scorecard project tasks of the Explorer
Tasks of the Explorer
- Cooperative analysis and exploration of data quality.
- Creation of profiles on the basis of snapshots.
- Documenting, managing and tracking data quality problems.
Profiling function
-minimum, maximum
- values and patterns
-uniqueness
-and much, much more!
- value of attribute X is uniquely determined by attributes A, B, C
- uniqueness of the combination of the attributes A, B, C
- overlapping of attributes A, B in Table-1 and X, Y in Table-2
Problem management functionality
- Problems can be defined at all levels:
- Data repository
- Entity (database table)
- Data field
- Problems can be assigned to employees:
- With e-mail notification
- With sample records
- Reports about data profiles and problems can be generated.
- Overview of problematic cases depending on selectable criteria.
- Overview of the number of fields still to be analyzed.
Data analysis and data profiling in 3 steps
The Data Quality Explorer is available in the following versions:
- Typical use scenario: "One-man analysis projects" with small quantities of data.
- Windows single workstation solution.
- Supports all standard databases and also flat files.
- Typical use scenario: Cooperative analysis projects with a few employees, small
to medium quantities of data.
- Client/server group application - Client and Server Windows
- Supports all standard databases and also flat files.
- Multi-processor support
- Typical use scenario: Large cooperative analysis projects with a large number
of employees, large quantities of data.
- Client/server group application - Client Windows, Server Windows or Unix.
- Supports all standard databases and also flat files.
- Multi-processor support