This shows you the differences between two versions of the page.
data_quality_management_system:critical_data_element [2023/03/26 14:32] peter |
data_quality_management_system:critical_data_element [2024/03/08 13:33] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Critical data elements ===== | ||
- | |||
- | === Definition === | ||
- | A critical data element is a [[data_concept: | ||
- | |||
- | ===Abbreviaton=== | ||
- | CDE | ||
- | |||
- | ===Notes== | ||
- | * For example, an organization may define its critical data elements as those that represent protected personal information, | ||
- | * The Factor Rating Method is method for deciding between two or more [[data_concept: | ||
- | * The Factor Rating Matrix is the output of the Factor Rating Method. | ||
- | |||
- | === Purpose | ||
- | |||
- | The purpose of critical data elements is to prioritize efforts to improve and ensure the quality of the most valuable data in the organization. | ||
- | |||
- | === Lifecycle === | ||
- | |||
- | * Select a critical data element | ||
- | * Deselect a critical data element | ||
- | |||
- | ^**Phase**^**Activity** | ||
- | |Plan |* Determine the scope of the selection procedure.\\ * Collect the [[data_concept: | ||
- | |Do |* Use the critical data elements as input for actions to improve and assure the quality of the critical data elements.| | ||
- | |Check | ||
- | |Act |* Decide whether the set of critical data elements should be amended.| | ||
- | |||
- | === Characteristics === | ||
- | |||
- | ^**Characteristic** | ||
- | |Criticality of a [[data_concept: | ||
- | |Completeness of the set of critical data elements|The set of critical data elements]] is complete within the scope of the management system.| | ||
- | |Actuality of the set of critical data elements | ||
- | |||
- | === Relations === | ||
- | |||
- | * Critical data element is part of a [[data_quality_general: | ||
- | * The [[data_quality_management_system/ | ||
- | * Critical data elements are input for the procedure to manage [[data_quality_management_system/ | ||
- | * [[data_quality_management_system/ | ||
- | * [[data_quality_management_system/ | ||
- | |||
- | {{: | ||
- | |||
- | |||
- | === Methods to select critical data elements === | ||
- | |||
- | == Method 1: Simple method == | ||
- | |||
- | The simplest method to select the critical data elements is that the data owner selects and establishes the critical data elements. | ||
- | |||
- | == Method 2: Factor Rating Method == | ||
- | |||
- | The Factor Rating Method is a method the select critical data elements in more objective way and is appropriate when more stakeholders have a say in the selection. | ||
- | |||
- | The next procedure is followed: | ||
- | |||
- | * Determine the factors for selection the critical data elements. | ||
- | * Determine the weight of each factor. | ||
- | * Determine the rating classification (levels of criticality). | ||
- | * Determine the algorithm to calculate the score (Score = Weight x Rate). | ||
- | * Determine the criticality threshold for the score. | ||
- | * Rate each combination of data element and factor. | ||
- | * Calculate the scores. | ||
- | * Compare the scores with the threshold. | ||
- | * Select the critical data elements. | ||
- | * Document the factor rating matrix. | ||
- | ** | ||
- | **\\ | ||
- | |||
- | **Table 1**: Factors for selection of critical data elements | ||
- | |||
- | ^**Label** | ||
- | |Regulatory |Is used for regulatory reporting. | ||
- | |Compliance |Contributes to compliance to laws and regulations | ||
- | |Accounting |Is used for financial/ | ||
- | |Operational|Has impact on the operational process and the quality of the product or service.|1 | ||
- | |||
- | **Table 2:** Rating classification | ||
- | |||
- | ^**Rate**^**Description**^ | ||
- | |0 |No impact | ||
- | |1 |Low impact | ||
- | |2 | ||
- | |3 |High impact | ||
- | |||
- | **Table 3**: Factor Rating Matrix | ||
- | |||
- | ^ **Data element** | ||
- | | ::: | **Regulatory**\\ \\ **Weight: 3** || **Compliance**\\ \\ **Weight: 3** || **Accounting**\\ \\ **Weight: 2** || **Operation**\\ \\ **Weight: 1** || ::: | ::: | | ||
- | | ::: | **Rate** | ||
- | | Customer number | ||
- | | Birth date | 3 | 9 | 3 | 9 | 0 | 0 | 3 | 3 | 19 | Yes | | ||
- | | Acceptance status | ||
- | | Mobile phone | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | No | | ||
- | | Gender | ||
- | |||
- | Threshold is 10. | ||
- | |||
- | === Story === | ||
- | |||
- | 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, | ||
- | |||
- | |||
- | === References === | ||
- | |||
- | DAMA (2017). DAMA-DMBOK. //Data Management Body of Knowledge.// | ||
- | |||
- | DAMA Dictionary of Data Management. 2< | ||
- | |||
- | [[https:// | ||
- | |||
- | Loshin, David (2009). Master Data Management. The MK/OMG Press. | ||
- | |||