ICCP CDP key terms
ICCP CDP · Get comfortable with the vocabulary.
- Data Lifecycle Management
- Related: Data Retention Policy, Master Data Management
The practice of governing data from creation through archival or destruction, defining policies for each stage so that data remains accurate, available, and compliant throughout its useful life.
- Data Profiling
- Related: Data Quality Dimensions, Data Cleansing
The process of examining a dataset to collect statistics and patterns about its structure, completeness, value distributions, and anomalies, typically performed before designing ETL or assessing data quality.
- Data Cleansing
- Related: Data Profiling, Data Quality Dimensions
The activity of detecting and correcting or removing inaccurate, incomplete, duplicated, or malformed records so that data meets agreed quality standards for its intended use.
- Data Quality Dimensions
- Related: Data Cleansing, Data Profiling
Measurable characteristics used to assess fitness for use, commonly including accuracy, completeness, consistency, timeliness, uniqueness, and validity, each evaluated against defined business rules.
- Master Data Management
- Related: Reference Data, Data Stewardship
A discipline and set of processes that create and maintain a single, trusted, shared view of core business entities such as customers, products, and suppliers across systems.
- Reference Data
- Related: Master Data Management, Data Dictionary
A controlled set of permissible values or classification codes, such as country codes or product categories, used to standardize data across applications and enable consistent interpretation.
- Data Dictionary
- Related: Metadata, Reference Data
Documentation describing the structure of a dataset, including entity names, attribute definitions, data types, formats, allowed values, and relationships, serving as a shared reference for developers and analysts.
- Metadata
- Related: Data Dictionary, Data Lineage
Structured information that describes other data, such as its origin, meaning, format, ownership, lineage, and usage, enabling discovery, interpretation, and management of data assets.
- Data Lineage
- Related: Metadata, ETL
A record of the origin and movement of data across systems, transformations, and reports, showing where values came from and how they were changed along the way.
- ETL
- Related: ELT, Data Lineage
Extract, Transform, Load: a data integration pattern that pulls data from source systems, applies cleaning and transformation rules, and writes the results into a target warehouse or store.
- ELT
- Related: ETL, Data Warehouse
Extract, Load, Transform: a pattern that loads raw source data into a target platform first and applies transformations there, typically leveraging the scalable compute of modern cloud warehouses.
- Data Warehouse
- Related: Data Mart, Star Schema, ELT
A centralized repository that integrates data from multiple operational sources, structured for query and analysis and optimized to support reporting and decision-making rather than transaction processing.
- Data Mart
- Related: Data Warehouse, Star Schema
A subset of a data warehouse, scoped to a particular business area or user group, that presents integrated data in a form tailored to that group's analytical needs.
- Dimensional Modeling
- Related: Star Schema, Fact Table, Slowly Changing Dimension
A modeling technique that organizes analytical data into fact tables containing measures and dimension tables containing descriptive context, designed for understandable and performant querying.
- Star Schema
- Related: Dimensional Modeling, Snowflake Schema, Fact Table
A dimensional design in which a central fact table references surrounding dimension tables through foreign keys, producing a simple, denormalized structure well suited to business intelligence queries.
- Snowflake Schema
- Related: Star Schema, Dimensional Modeling
A dimensional design in which dimension tables are normalized into multiple related tables, reducing redundancy at the cost of more joins and greater query complexity.
- Fact Table
- Related: Dimensional Modeling, Grain, Star Schema
The central table in a dimensional model that stores quantitative measures and foreign keys to dimension tables, typically at a defined grain such as one row per transaction or per day.
- Grain
- Related: Fact Table, Dimensional Modeling
The level of detail represented by a single row in a fact table, declared explicitly during design so that measures are neither double-counted nor aggregated too coarsely.
- Slowly Changing Dimension
- Related: Dimensional Modeling, Data Lineage
A technique for managing dimension attributes that change over time, using methods such as overwriting values or retaining history with versioned rows and effective dates.
- OLAP Cube
- Related: Dimensional Modeling, Data Mart
A multidimensional data structure that pre-aggregates measures across dimensions, allowing analysts to slice, dice, drill down, and pivot data quickly for analytical exploration.
- Data Governance
- Related: Data Stewardship, Data Policy, Data Ownership
The overall system of decision rights, policies, and accountabilities that determines how data is collected, managed, protected, and used across an organization.
- Data Stewardship
- Related: Data Governance, Data Ownership, Master Data Management
The operational execution of data governance, in which designated individuals apply standards, resolve quality issues, and maintain definitions for a defined data domain.
- Data Ownership
- Related: Data Stewardship, Data Governance
The assignment of accountability for a data domain to a role or person who approves definitions, access decisions, and quality targets for that data.
- Data Custodian
- Related: Data Ownership, Data Stewardship
A role responsible for the technical storage, movement, backup, and security of data on behalf of data owners, without necessarily deciding what the data means or who may use it.
- Data Policy
- Related: Data Governance, Data Retention Policy
A formal statement of rules and principles governing data handling, such as retention, access, privacy, and acceptable use, that guides decisions and behavior across the organization.
- Data Retention Policy
- Related: Data Lifecycle Management, Data Policy
Rules specifying how long each class of data must be kept, where it is stored, and when and how it must be destroyed, balancing legal obligations with business needs.
- Data Classification
- Related: Data Policy, Data Masking
The process of assigning data to categories such as public, internal, confidential, or restricted, based on sensitivity and regulatory requirements, to determine appropriate handling controls.
- Data Masking
- Related: Data Classification, Data Privacy
A technique that substitutes sensitive values with realistic but altered data, either permanently or dynamically at query time, so that users can work without seeing protected information.
- Data Privacy
- Related: Data Masking, Data Classification
The set of practices and obligations protecting personal information from unauthorized access or misuse, including consent management, minimization, and honoring individual rights over their data.
- Data Catalog
- Related: Metadata, Data Lineage
An organized inventory of data assets with searchable metadata, definitions, ownership, and lineage, helping users find, understand, and trust available data.
- Exploratory Data Analysis
- Related: Data Profiling, Data Visualization
An investigative approach that uses summary statistics and visualizations to reveal distributions, relationships, and anomalies before formal modeling or hypothesis testing.
- Predictive Modeling
- Related: Supervised Learning, Model Overfitting
The use of statistical or machine learning methods to estimate an unknown outcome from available variables, supporting classification, ranking, or forecasting decisions.
- Supervised Learning
- Related: Predictive Modeling, Model Overfitting
A machine learning approach that trains a model on labeled examples, learning a mapping from input features to a known target so it can predict that target for new cases.
- Model Overfitting
- Related: Supervised Learning, Cross-Validation
A modeling failure in which a model fits training data so closely that it captures noise and performs poorly on new data, often detected by comparing training and validation performance.
- Cross-Validation
- Related: Model Overfitting, Predictive Modeling
A resampling technique that partitions data into multiple folds, training and validating on different splits, to estimate how well a model will generalize to unseen data.
- Data Visualization
- Related: Exploratory Data Analysis, KPI
The representation of data through charts, graphs, and dashboards so that patterns, comparisons, and outliers are communicated clearly to an intended audience.
- KPI
- Related: Data Visualization, Data Mart
Key Performance Indicator: a quantifiable measure tied to a strategic objective, chosen so that progress toward that objective can be monitored consistently over time.
- Data Mining
- Related: Exploratory Data Analysis, Predictive Modeling
The application of statistical and computational techniques to large datasets to discover previously unknown patterns, associations, or segments that inform business decisions.