When establishing a MOM.

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.

Explanation:

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.

References:

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.