ISO/TS 8000-81-2021 pdf download.Data quality 一 Part 81: Data quality assessment: Profiling.
5.3 Outputs
The output from structure analysis is a data element concept.
6 Column analysis
6.1 Inputs
The inputs to column analyst’s are a data set and a corresponding data element concept from structure an.ilysls (see CLause 5).
6.2 Scope of activities
Co)umii aodysis isits of:
— extracting data elements irom the data element concept.
— comparing the data elements with the values in the data set:
— determining the value domain.
NOTE The methods for extracting data elements include discovery, assertion testing and visual inspection
These methods can be supported by automated took.
6.3 Outputs
The output from column analysis is a list of constraints of value domain. These constraints Include the following (see Annex B for more details):
— cardinalities: count of rows, range of values, nulls, count of distinct values and uniqueness;
— store: data type, length of values and decimals;
— valid values: discrete value list, permissible range, skip-over rules, pattern and domain.
7 Relationship analysis
7.1 Inputs
The Inputs for relationship analysis are a data set and the corresponding data elements tram column analysis (Soc Clauac6).
NOTE Rrlaflunship analysis extracts reLationships between columns within nut only a single cable but also multilde tables.
7.2 Scope of activities
Relationship analysis consists of:
— comparing the extracted data elements with any supporting Information in the data set:
— determining dependency.
NOTE When performing relationship analysis, a key requirement is to understand the correspondence between the data structure (tables and columns) and cems In the real world. This understanding artses from data profibng practstioners cidlaborating with experts who work with the core processes 04 the organuatlun These experts are Familiar with the details nithe’ items represented by the data.ISO/TS 8000-81 pdf download.