Assessing the Data Quality in HOPEX Information Architecture
An assessment is designed to give values, in a specific context, to data characteristics.
Characteristics values can be given:
• in the properties of the application in question. : see Direct evaluation.
• through an evaluation questionnaire sent to the appropriate recipients: see Evaluation By Campaign.
The evaluation is supplemented by result analysis tools.
Evaluation Objects
An evaluation can deal with the following objects:
• concept, concept view
• class, data view
• table, physical view
• all data areas (business, logical and physical)
Data Evaluation Criteria
HOPEX Information Architecture provides by default a data evaluation template that focuses on the following criteria:
Completeness
Identifies the level of 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 level 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 level of consistency in the data.
Example
Below is an inconsistency in the data format.
Validity
Identifies the level of valid 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 assesses the level of uniqueness of the 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 evaluation modes
An evaluation can be carried out directly on data or remotely via questionnaires.
Direct evaluation
To directly assess a data item:
1. Open the properties of the data item in question.
2. Select the Evaluation page.
3. Click Evaluate.
4. On the page that appears, select a value for each question:
5. Click OK.
Evaluation By Campaign
The functional administrator can create evaluation campaigns or sessions for data.
On creation of a campaign, questionnaires are sent to designated respondents to obtain qualitative estimations on the objects for which they are responsible.
For more details on campaigns and sessions, see Introduction to Assessment by Campaign.
Prerequisites for Data Evaluation
Before starting a data evaluation campaign, you must first prepare the work environment. Ensure that you have defined respondents for the data, and specify for each one the entity to which he/she is attached as well as an email.
Creating assessment campaigns
To create an evaluation campaign with the template provided as standard:
Click the navigation menu, then Campaign Management > List of Campaigns.1. In the edit area click New.
The campaign creation page appears.
2. Enter the name of the campaign.
3. Select Evaluation Template "Data Quality Evaluation".
4. Modify the Calendar if required.
The calendar serves to initialize the begin and end dates of the evaluation campaign. 5. Specify the Begin Date and the End Date.
6. Click Next.
7. In the Scope Selection window, select the objects that define the evaluation context.
The context encompasses the elements of the branch that extends from the object in question up to the root.
If you deselect a node of a branch, only the child elements of this branch are deselected.8. Click Next.
9. In the preview window, click Refresh the Report.
Elements that will be assessed appear.
In particular, you can view:
• evaluated characteristics (defined in the evaluation template)
• evaluated objects
• the context objects
• evaluation nodes which correspond to objects placed in their context objects, associated with respondents.
• respondents
10. Click OK.
Next step: Creating an Assessment Session.
See also: Data Quality Report.