Data quality studio


BEWARE:

  is rebranded to  
 

The STAEDEAN documentation for products related to
 Microsoft Dynamics 365 for Finance and Supply Chain Management
is moved to docs.staedean.com.
 

The Data quality studio documentation
is moved to Data Quality Studio.
 

The documentation on docs.to-increase.com is no longer updated.

 

Data quality studio for Microsoft Dynamics 365 Finance and Supply Chain Management helps you control your data quality. You can apply data validation rules, duplicate check rules, and data action rules to keep your data clean and consistent.

This picture shows the data quality dimensions:

 

These data quality dimensions are covered by the Data quality studio in combination with D365 F&SCM:
  • Consistency: Is the data consistent between systems and entities? Do duplicate records exist? For example, you can check data consistency with duplicate check rules or a Data pattern type validation rule.
  • Validity: Are all data values within the value domains specified by the business? For example, you can check data validity with Range expression type validation rules.
  • Accuracy: Does data reflect the real-world objects or a verifiable source? For example, you can check email or address accuracy with Web service type validation rules or use Transformation list type action rules.
  • Integrity: Are the relations between entities and attributes consistent? Within tables and between tables? For example, you can check integrity with Range expression type or Data pattern type validation rules.
  • Timeliness: Is the data available at the time needed? For example, you can check timeliness with Mandatory type or Range expression type validation rules.
  • Completeness: Is all necessary data present? For example, you can control completeness with Mandatory type validation rules or action rules.

If you can't find the information you are looking for, you can:


Set up data quality policies

Set up data quality policy versions

General setup

In the Data Quality studio, you can define several general settings.

Set Data quality studio parameters

Set up dynamic queries

Set up configurable lookup

Set up condition table mapping

Set up secured values

Set up data quality assessment project

Set up reason codes

Apply data quality policy rules

You can apply data quality policy rules in several ways:

  • On manually entering or updating records.
  • On data import into D365 FO with a Connectivity studio message.
  • On doing a quality assessment in Data quality studio.