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.