This factsheet describes knowledge about Critical Data Elements (CDE’s) and a CDE Factor Rating Matrix in a nutshell. These are highlighted from different angles in a structured way.
The purpose of CDE’s is to prioritize efforts to improve and ensure the quality of the most valuable data in the organization.
|Plan||* Determine the scope of the selection procedure.
* Collect the Data Elements within the scope.
* Select a method to determine the CDE’s.
* Select or deselect CDE’s by the method.
* Establish the CDE’s.
|Do||* Use the CDE’s as input for actions to improve and assure the quality of the CDE’s.|
|Check||* Evaluate the set of CDE’s.|
|Act||* Decide whether the set of CDE’s should be amended.|
The procedure to manage CDE’s is part of a data quality management system.
|Criticality of a Data Element||A CDE is a data element that exceeds a threshold for criticality.|
|Completeness of the set of CDE’s||The set of CDE’s is complete within the scope of the management system.|
|Actuality of the set of CDE’s||The set of CDE’s is up to date, e.g., it is not ten years old.|
The simplest method to select the CDE’s is that the data owner selects and establishes the CDE’s.
The Factor Rating Method is a method the select CDE’s in more objective way and is appropriate when more stakeholders have a say in the selection.
The next procedure is followed:
Table 1: Factors for selection of Data Elements
|Label||Factor for selection a Data Element||Weight|
|Regulatory||Is used for regulatory reporting.||3|
|Compliance||Contributes to compliance to laws and regulations||3|
|Accounting||Is used for financial/management accounting||2|
|Operational||Has impact on the operational process and the quality of the product or service.||1|
Table 2: Rating classification
Table 3: Factor Rating Matrix
|Data element||Factor and Weight||Score|| CDE?
Threshold is 10.
The customer database of telephone company CallMe is contaminated. This resulted in customer dissatisfaction and avoidable bill disputes, causing extra workload for Client Services. Efforts to clean up the database failed because of the amount of work involved. The owner of the database then decided to select data elements that matter. He invited a few key players (stakeholders) to determine which data elements these would be. They all agreed that the name of the customer was the most important data element (critical data element). This selection was also fully in line with the data quality policy and data quality objectives.
The owner of the database then first tightened the data quality rules around names, to prevent further contamination. Furthermore, he hired a name specialist to clean up the names automatically where possible and, where necessary, to approach customers personally to ask for their correct name. This action was highly appreciated by customers because they felt seen by CallMe. It has also helped its own organization to realize improvements in data and a reduction of the workload.
DAMA Dictionary of Data Management. 2nd Edition 2011. Technics Publications, LLC, New Jersey.
Loshin, David (2009). Master Data Management. The MK/OMG Press.