Data Quality Checks

From CDQ
Capability/Data Quality Checks
Jump to navigation Jump to search
Name Name of a concept, e.g. a data model concept. In contrast to terms, the name does not depend on a given context, e.g. a country-specific language. Data Quality Checks (category: , sort rank: 120, product: Data Quality Services)
Short description Informal and short human-readable definition of a concept. Data quality checks by managed and continuously updated data quality rules.
Description Informal and comprehensive human-readable definition of a concept. Transformation of human-documented data requirements into executable data quality rules is mostly a manual IT effort. Changing requirements cause IT efforts again and again. Some checks, e.g. tax number validity (not just format!), require external services. Other checks, e.g. validity of legal forms, require managed reference data (e.g. legal forms by country, plus abbreviations). Continuous data quality assurance (i.e. batch analyses) and real-time checks in workflows often use different rule sets. Data requirements and related reference data are collected and updated collaboratively by the Data Sharing Community. Data quality rules are derived from these requirements automatically, auditor approved. All data quality rules are executed behind 1 interface, in real-time, 1’000+ rules in < 1s. Batch jobs and single-record checks use the same rule set and can be integrated by APIs. If reference data (e.g. correct tax numbers) is available, fix proposals are provided for incorrect records.
Release status The release status in terms of development progress or maturity of a product feature or a business capability.<br/><code>EMPTY</code> (0): No feature considered yet, just rough idea for capability.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it. LIVE
Use cases Analyze and Prepare a Business Partner Storage for Get Clean, Bank Account Data Maintenance, Business Partner Data Maintenance Workflow, Business Partner Data Maintenance Workflow (Lean Create), Business Partner Data Maintenance Workflow (Lean Create), Business Partner Data Maintenance Workflow (Lean Update), Cleanse and Enrich a Business Partner Storage, Demonstrate and Test Data Quality Checks, Know Your Business Partner - Compliance and Risk Checks, Monitor Business Partner Data Quality, Share Business Partner Data, Understand CDQ Cloud Services
Apps
Following apps provide this capability
Batch Data Validation
  • Batch Data Validation Video
Single Data Validation
  • Single Data Validation Video
CDQ Wiki
  • CDQ Wiki
APIs
Following APIs provide this capability

Features

Feature Short description Informal and short human-readable definition of a concept. Release status The release status in terms of development progress or maturity of a product feature or a business capability.<br/><code>EMPTY</code> (0): No feature considered yet, just rough idea for capability.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it.
Address Checks CDQ data quality profiling services enable the validation of addresses with respect to different data quality criteria LIVE
Business Partner Profile Checks Validate business partner details such as legal form and company status. LIVE
Data Quality Rules Documentation of data quality rules with explanation and technical constraints to validate business partner data records. LIVE
Data Quality Rules Engine The customizable, high perfomance data quality rules engine that executes community and custom data quality rules LIVE
Data Quality Rules Engine Configuration Configuration of the data quality rules engine such as selection of rules, customization of the ruleset, data quality profiling scope (identifiers, addresses, etc.) LIVE
Data Quality Rules Function Library Data quality rule functions are methods implemented in a programming language for being used in data quality rule implementations. They can be e.g. used in custom data quality rules similar to functions employed by business users in popular spreadsheet applications such as Microsoft Excel. LIVE
Detailed Validation Result Users retrieve detailed information about each rule that is violated by an input record. LIVE
EU VAT Qualification For a given EU VAT, it is checked whether the name and address are really associated with this identifier (same information maintained in the VAT register as provided by the user). LIVE
Identifier Checks Validate business (VAT, tax, business register IDs) and location identifiers against different data quality rules categories LIVE
Rdfication Engine The RDFication Engine is a powerful technical feature for translating business partner records into a knowledge graph representation e.g. for the purpose of performing data quality checks LIVE
Bank Account Data Checks CDQ data quality profiling services enable the validation of bank master data with respect to different data quality criteria BETA
Business Partner Status Checks Data quality rules that check for the status of an address or business partner BETA
Compliance and Risk Checks CDQ data quality profiling services enable the identification of compliance or risk relevant issues in a business partner data record BETA
Data Quality Monitoring Monitor data quality of a data source in the data mirror over time BETA
Data Quality Monitoring Configuration Configuration of the data quality monitoring services in terms of job intervals, and configuration of the data quality rules engine such as selection of rules, customization of the ruleset, data quality profiling scope (identifiers, addresses, etc.) BETA
Data Quality Rules Testing and Release Management Data quality rules are part of a strict testing process. Each rule is tested daily. BETA
Regular Summary Reports Weekly summary comprising statistics about updates, data quality performance and news BETA
Standard Data Quality Profiling Reports Data quality profiling results are presented in reports and related dashboards. A report is a combination of a browsable result overview (which can be downloaded) and dashboard(s) that visualize the results. BETA
Business and Tax Identifier Qualification For business identifiers (e.g. business register IDs or tax identifiers) and address identifiers, it is checked whether the name and address are really associated with this identifier (same information maintained by the issuing authority for a given identifier as provided by the user). DEVELOPMENT
Benchmarking Reports IDEA
Data Quality Performance Index IDEA


More detailed information