Importing Data Assessments
HOPEX provides an Excel template to import data quality criteria values into your repository.
This Excel template is mapped to the data quality assessment template implemented in the direct assessment tool of HOPEX Data Architecture.
It can be used for different types of objects that have direct evaluation, e.g. concepts, classes, tables, etc.
Import Example
Below is an example of importing the different quality values of a concept.
Values defined in the Excel file
Résult in HOPEX Data Architecture
Content of the Excel Template
Columns | Description |
|---|---|
HOPEX Identifier | _IdAbs of an object assessed. When this property is specified, the Object Type and Name columns are not required. |
Object Type | This property indicates the type of object assessed: "Concept", "Concept view", "Class", "Data view", "Table". This property must be defined when the HOPEX identifier is not specified. |
Object Name | This property indicates the long name of the assessed object. It must be defined when the HOPEX identifier is not specified. |
Completeness | Corresponds to the evaluation criteria "Completeness". |
Uniqueness | Corresponds to the evaluation criteria "Unicity". |
Timeliness | Corresponds to the evaluation criteria "Timeless". |
Validity | Corresponds to the evaluation criteria "Validity". |
Accuracy | Corresponds to the evaluation criteria "Accuracy". |
Consistency | Corresponds to the evaluation criteria "Consistency". |
Assessor Name | Assessor name. If no assessor is indicated, the name of the current user is taken by default in HOPEX. |
Evaluation Date | Object assessment date. For the same object, measurements can be made at different times. |
Downloading the Excel Template
The Data Quality Excel Template is available in the MEGA HOPEX Store. To download it:
1. Go to the HOPEX Store, at the following address:https://community.mega.com/t5/HOPEX-Store/bd-p/hopex-store.
2. Click Data Quality Excel Template.
3. Download the file.
Importing an Excel File of Data Assessments
To import data assessments from an Excel file:
1. Click the Main Menu then Import > Excel (*.xls; *.xlsx).
2. To the right of the Excel Import File field, click Browse .
3. Select the file containing the assessments.
4. Click Import.