Assessing the Data Quality in HOPEX IT Portfolio Management
An assessment is designed to give values, in a specific context, to data characteristics.
In HOPEX IT Portfolio Management it is possible to carry out a direct assessment on the data, as an expert.
For an assessment campaign on the data, you need the HOPEX Information Architecture solution.The assessment is supplemented by results analysis tools.
Assessing a Data Item
The assessment can focus on business data such as concepts or logical data such as classes.
To directly assess a data item:
1. Open the properties of the data item in question.
2. Select the Evaluation page.
3. Click New.
4. On the page that appears, select a value for each question.
For certain identified problems, an optional remediation plan can be created for data cleansing. 5. Click OK.
Data Evaluation Criteria
HOPEX IT Portfolio Management provides by default a data evaluation template that focuses on the following criteria:
Completeness
Identifies percentage completeness of data and missing properties.
Example
Below some columns have no value (in red) and others are truncated (Dupont@Samp.gm)
Accuracy
Identifies the percentage of accurate, reliable data.
Example
Below, for Dupont, the position and the department are reversed.
For Durand, the item displays a typographical error
For Rene, the department displays an erroneous value.
Consistency
Identifies the percentage of inconsistency in the data.
Example
Below is an inconsistency in the data format.
Validity
Identifies the percentage of invalid data.
Example
The value of the "Available units" field on Prod1 should not be negative.
A withdrawal date is set to Prod2 but the field "Available units" does not display a null value.
Uniqueness
This criterion evaluates duplicate data.
Example
The "Client" table must not contain the same occurrence twice, each record must be unique.
Timeless
This criterion assesses whether the information is available at the required time.
Data Quality Evolution Report
A report template allows you to follow the evolution of the quality of classes and concepts.
To launch this report:
1. Click the pop-up menu then Reports > Data Reports.
2. In the edit area, click the Data Quality Evolution tile.
The report appears.
3. Select the information concerned (class or concept).
4. Click the Refresh the report button.