Activities related to Reference & Master Data typically include managing the lifecycle, establishing governance policies, modeling data, and defining architectural approaches. However, evaluating and assessing data sources is generally not considered a core activity specific to Reference & Master Data management. Here's a detailed explanation:

Core Activities:

Manage the Lifecycle: Involves overseeing the entire lifecycle of master data, from creation to retirement.

Establish Governance Policies: Setting up policies and procedures to govern the management and use of master data.

Model Data: Creating data models that define the structure and relationships of master data entities.

Define Architectural Approach: Developing the architecture that supports master data management, including integration and data quality frameworks.

Excluded Activity:

Evaluate and Assess Data Sources: While this is an important activity in data management, it is more relevant to data acquisition and integration rather than the ongoing management of reference and master data.

Data Management Body of Knowledge (DMBOK), Chapter 7: Master Data Management

DAMA International, 'The DAMA Guide to the Data Management Body of Knowledge (DMBOK)'

MDM (Master Data Management) is characterized by formal management with a high degree of diligence and collaboration. Here's why:

Formal Management:

Structured Processes: MDM involves structured processes for managing master data, including data governance, data quality management, and data stewardship.

Policies and Standards: Establishes and enforces policies and standards to ensure data consistency, accuracy, and integrity.

Collaboration:

Cross-Functional Teams: Requires collaboration across different departments, including IT, business units, and data governance teams.

Stakeholder Involvement: Engages various stakeholders in the data management process, ensuring that master data meets the needs of the entire organization.

Data Management Body of Knowledge (DMBOK), Chapter 7: Master Data Management

DAMA International, 'The DAMA Guide to the Data Management Body of Knowledge (DMBOK)'

Reference data can be structured in various ways depending on its granularity and complexity.

Simple List:

Reference data can be a simple list when it involves basic, discrete values such as country codes or product categories.

Cross-Reference:

When reference data needs to map values between different systems or standards, it can be structured as cross-references. For example, mapping old product codes to new ones.

Taxonomy:

For more complex hierarchical relationships, reference data can be structured as a taxonomy. This involves categorizing data into parent-child relationships, like an organizational hierarchy or biological classification.

DAMA-DMBOK (Data Management Body of Knowledge) Framework

CDMP (Certified Data Management Professional) Exam Study Materials

Definitions and Context:

Data Profiling: This is the process of examining data from existing data sources and collecting statistics or informative summaries about that data.

Master Data Management (MDM): Establishing MDM involves processes and technologies for managing the non-transactional data entities of an organization.

Data profiling helps to understand the data's characteristics and quality by analyzing data values and comparing them to defined valid values.

This process is crucial in establishing a Master Data Management (MDM) system as it ensures the data adheres to the defined standards and is clean, accurate, and ready for integration into the MDM system.

DAMA-DMBOK: Data Management Body of Knowledge, 2nd Edition, Chapter 11: Master and Reference Data Management.

Kimball, R. & Caserta, J. (2004). The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data.

ISO 8000 is an international standard focused on data quality and information exchange. Its primary purpose is to define and measure the quality of data, ensuring that it meets the requirements for completeness, accuracy, and consistency. The standard provides guidelines for data quality management, including requirements for data governance, data quality metrics, and procedures for improving data quality over time. ISO 8000 is not meant to replace ISO 9000, which is focused on quality management systems, but to complement it by addressing data quality specifically.

ISO 8000: Overview and Benefits of ISO 8000, International Organization for Standardization (ISO)

DAMA-DMBOK2 Guide: Chapter 12 -- Data Quality Management