CDDP study materials
CDDP study resources

CDDP key terms

CDDP · Get comfortable with the vocabulary.

Data Governance

The system of decision rights and accountabilities over data assets, defining who may take which actions, under what rules, and how compliance is monitored across the organization.

Related: Data Stewardship, Data Lineage, Data Ethics
Data Stewardship

The operational practice of assigning named individuals to care for specific data domains, resolving quality issues, approving definitions, and enforcing governance policies day to day.

Related: Data Governance, Data Owner, Data Quality Dimensions
Data Owner

An accountable role with authority to approve access, classify sensitivity, and accept risk for a defined data domain or asset, usually at a senior management level.

Related: Data Stewardship, Data Classification, Role-Based Access Control
Data Ethics

The principles guiding fair, transparent, and responsible use of data, including consent, harm avoidance, bias mitigation, and accountability for algorithmic decisions affecting people.

Related: Data Governance, Data Privacy, Data Bias
Data Bias

Systematic error or unfair skew in collected data or model outputs that disadvantages groups, often arising from sampling, historical inequity, labeling choices, or proxy variables.

Related: Data Ethics, Data Quality Dimensions, Data Profiling
Data Classification

The process of assigning data to sensitivity tiers such as public, internal, confidential, or restricted, so that handling, access, and retention controls match the risk involved.

Related: Data Owner, Data Privacy, Data Retention Policy
Data Retention Policy

Documented rules specifying how long each data category is kept, where it resides, and how it is destroyed, balancing legal obligations, business needs, and privacy minimization.

Related: Data Classification, Data Privacy, Data Lifecycle Management
Data Lifecycle Management

The coordinated set of practices covering creation, storage, use, sharing, archiving, and deletion of data, ensuring each stage has defined controls and ownership.

Related: Data Retention Policy, Data Lineage, Data Governance
Conceptual Data Model

A technology-independent diagram of major business entities and their relationships, used to agree on scope and meaning before physical design begins.

Related: Logical Data Model, Physical Data Model, Entity-Relationship Diagram
Logical Data Model

A refined model specifying entities, attributes, keys, and relationships without committing to a particular database product, bridging business concepts and physical implementation.

Related: Conceptual Data Model, Physical Data Model, Normalization
Physical Data Model

The implementation-level design of tables, columns, indexes, partitions, and constraints tuned for a specific database engine and workload.

Related: Logical Data Model, Normalization, Star Schema
Normalization

Structuring relational tables to reduce redundancy and update anomalies by organizing attributes into progressively stricter normal forms based on functional dependencies.

Related: Denormalization, Logical Data Model, Entity-Relationship Diagram
Denormalization

Deliberately introducing redundancy or precomputed values into a schema to speed reads and simplify queries, accepting extra storage and update complexity.

Related: Normalization, Star Schema, Data Warehouse
Star Schema

A dimensional model with a central fact table of measures linked to surrounding dimension tables, optimized for analytical queries and business-friendly navigation.

Related: Snowflake Schema, Data Warehouse, Denormalization
Snowflake Schema

A dimensional model in which dimension tables are normalized into related sub-dimensions, reducing redundancy at the cost of more joins in analytical queries.

Related: Star Schema, Normalization, Data Warehouse
Entity-Relationship Diagram

A visual notation showing entities, their attributes, and the cardinality of relationships between them, commonly used to communicate data model designs.

Related: Conceptual Data Model, Logical Data Model, Normalization
ETL

Extract, transform, load: a pipeline pattern that pulls data from sources, applies cleansing and business rules, then writes results into a target store.

Related: ELT, Data Pipeline, Data Integration
ELT

Extract, load, transform: a pattern that loads raw data into a target platform first and performs transformations there, leveraging scalable warehouse or lakehouse compute.

Related: ETL, Data Lakehouse, Data Pipeline
Data Pipeline

An automated sequence of steps that moves and transforms data between systems, including scheduling, error handling, monitoring, and dependency management.

Related: ETL, Data Integration, Data Lineage
Data Integration

Combining data from multiple sources into a consistent view, using patterns such as consolidation, federation, or propagation to serve analytical and operational needs.

Related: ETL, Data Virtualization, Master Data Management
Data Virtualization

A technique that presents a unified query layer over disparate sources without physically copying the data, trading some performance for freshness and reduced duplication.

Related: Data Integration, Data Federation, Data Lakehouse
Data Lakehouse

An architecture combining cheap object storage and open table formats with warehouse-style transactions, schema enforcement, and governance to support both analytics and machine learning.

Related: Data Lake, Data Warehouse, ELT
Data Warehouse

A centralized repository optimized for analytical querying, holding integrated, time-variant, subject-oriented data loaded from operational systems through controlled pipelines.

Related: Data Mart, Star Schema, Data Lakehouse
Data Mart

A subset of a warehouse scoped to one business area or team, providing focused, pre-shaped data for reporting with simpler access controls.

Related: Data Warehouse, Star Schema, Data Lakehouse
Data Lake

A large store holding raw and refined data in native formats on cheap storage, typically schema-on-read, serving diverse analytical and machine-learning workloads.

Related: Data Lakehouse, Data Warehouse, Data Swamp
Data Quality Dimensions

Measurable characteristics used to assess fitness for use, commonly accuracy, completeness, consistency, timeliness, uniqueness, and validity.

Related: Data Profiling, Data Cleansing, Data Stewardship
Data Profiling

Statistical examination of datasets to reveal structure, value distributions, null rates, key candidates, and anomalies, forming a baseline for quality rules and modeling decisions.

Related: Data Quality Dimensions, Data Cleansing, Data Lineage
Data Cleansing

Correcting or standardizing invalid, duplicate, incomplete, or malformed records so that data meets agreed quality rules before use in analysis or operations.

Related: Data Quality Dimensions, Data Profiling, Master Data Management
Master Data Management

The discipline and tooling for creating authoritative, shared records of core entities such as customers, products, and suppliers, and synchronizing them across systems.

Related: Reference Data, Data Cleansing, Data Integration
Reference Data

Controlled code sets and lookup values, such as country codes or currency lists, that classify and constrain other data and must be consistent enterprise-wide.

Related: Master Data Management, Data Cleansing, Data Classification
Data Lineage

A recorded trace of where data came from, how it was transformed, and where it flows, supporting impact analysis, debugging, audit, and regulatory evidence.

Related: Data Pipeline, Data Governance, Data Profiling
Descriptive Statistics

Summary measures that characterize a dataset, including central tendency, dispersion, frequency, and shape, used to understand distributions before deeper analysis.

Related: Inferential Statistics, Data Visualization, Correlation
Inferential Statistics

Methods that use sample data to draw conclusions about a wider population, including confidence intervals, hypothesis tests, and estimates of uncertainty.

Related: Descriptive Statistics, Statistical Significance, Sampling Bias
Statistical Significance

A result unlikely to have occurred by chance under a stated null hypothesis, conventionally judged against a chosen probability threshold such as 0.05.

Related: Inferential Statistics, Correlation, Sampling Bias
Correlation

A measure of the strength and direction of association between two variables, ranging from minus one to one, which does not by itself establish causation.

Related: Descriptive Statistics, Statistical Significance, Data Visualization
Sampling Bias

Distortion arising when the selected sample is not representative of the target population, causing estimates and conclusions to systematically misstate reality.

Related: Inferential Statistics, Data Bias, Statistical Significance
Data Visualization

Encoding quantitative and categorical information into visual forms such as charts and maps so patterns, comparisons, and outliers can be perceived quickly and accurately.

Related: Dashboard Design, Descriptive Statistics, Data Storytelling
Dashboard Design

The practice of arranging metrics, filters, and supporting visuals on a single screen so a defined audience can monitor performance and act without extraneous clutter.

Related: Data Visualization, Data Storytelling, KPI
KPI

A key performance indicator: a small set of measures tied to strategic objectives, with agreed definitions, targets, and owners used to judge progress.

Related: Dashboard Design, Data Storytelling, Data Quality Dimensions
Data Storytelling

Combining visuals, narrative, and context to guide an audience from evidence to a recommended decision, emphasizing clarity of message over decorative presentation.

Related: Data Visualization, Dashboard Design, KPI
Data Privacy

Protecting personal information through lawful collection, purpose limitation, consent, minimization, and honoring individual rights such as access and erasure.

Related: Data Classification, Data Masking, Data Ethics
Data Masking

Replacing sensitive values with realistic substitutes or redactions so non-production users and analysts can work without seeing identifiable or confidential content.

Related: Data Privacy, Tokenization, Role-Based Access Control
Tokenization

Substituting a sensitive value with a non-sensitive token mapped through a protected vault, reducing exposure while allowing authorized re-identification when required.

Related: Data Masking, Data Privacy, Encryption at Rest
Role-Based Access Control

Granting permissions according to job roles rather than individuals, simplifying administration and enforcing least privilege across systems and datasets.

Related: Data Masking, Data Owner, Data Classification
Encryption at Rest

Protecting stored data by encoding it with cryptographic keys so that stolen disks, backups, or storage volumes remain unreadable without authorized key access.

Related: Tokenization, Data Privacy, Data Classification
Cloud Data Platform

Managed, elastically scalable services for storage, compute, and analytics delivered over the internet, billed by consumption and configured through provider controls.

Related: Data Lakehouse, Data Warehouse, Data Pipeline
Data Fabric

An architecture using metadata, virtualization, and automated integration to connect distributed data sources into a coherent, governed access layer.

Related: Data Virtualization, Data Lineage, Data Lakehouse
Data Mesh

A socio-technical approach decentralizing analytical data ownership to domain teams who publish governed, discoverable data products against shared platform standards.

Related: Data Fabric, Data Governance, Data Lakehouse
Streaming Data

Continuously produced event records processed incrementally as they arrive, enabling near-real-time monitoring and reactions rather than periodic batch loads.

Related: Data Pipeline, Cloud Data Platform, Data Integration