DEA Level 3 study materials
DEA Level 3 study resources

DEA Level 3 key terms

DEA Level 3 · Get comfortable with the vocabulary.

Data Governance

The system of decision rights, policies, and accountabilities that determines who can take which actions on which data, and how those decisions are enforced across an organization.

Related: Data Stewardship, Data Ownership, Data Policy
Data Stewardship

The day-to-day operational responsibility for a data domain, including defining quality rules, resolving issues, and approving changes, usually carried out by a named steward rather than an executive owner.

Related: Data Governance, Data Ownership, Data Quality Rule
Data Ownership

The accountability assigned to a senior role for a data domain's fitness for use, including approving access, funding remediation, and accepting residual risk on behalf of the business.

Related: Data Stewardship, Data Governance
Data Policy

A formal statement of mandatory rules and principles governing how data is created, stored, shared, and retired, against which procedures and controls are written and audited.

Related: Data Governance, Data Standard
Data Standard

An agreed, documented specification for representing a data element or format, such as a code set or date pattern, adopted so that systems and parties can exchange and compare data consistently.

Related: Data Policy, Reference Data, Metadata
Metadata

Structured information describing other data, such as its meaning, origin, format, owner, and lineage, which enables discovery, interpretation, and control of data assets.

Related: Data Lineage, Data Catalog, Data Standard
Data Lineage

The recorded path of data from its origin through each transformation to its final use, showing which sources, rules, and systems produced a given value.

Related: Metadata, Data Catalog, Data Provenance
Data Catalog

An inventory of data assets with searchable descriptions, owners, classifications, and usage guidance, used by analysts and auditors to find and trust data.

Related: Metadata, Data Lineage, Business Glossary
Business Glossary

A curated list of business terms with agreed definitions and relationships, used to align stakeholders on meaning so that reports and models refer to the same concepts.

Related: Data Catalog, Data Standard, Conceptual Data Model
Data Quality Rule

A testable condition that data must satisfy, such as completeness, uniqueness, or range checks, used to measure and monitor whether data meets its intended purpose.

Related: Data Stewardship, Data Quality Dimension
Data Quality Dimension

A named aspect of quality used to evaluate data, commonly accuracy, completeness, consistency, timeliness, validity, and uniqueness, each assessed with its own measures.

Related: Data Quality Rule
Conceptual Data Model

A technology-independent view of the business entities, their attributes, and relationships, used to agree scope and meaning before detailed design begins.

Related: Logical Data Model, Physical Data Model, Business Glossary
Logical Data Model

A detailed model of entities, attributes, keys, and relationships that is independent of any specific database product but precise enough to drive design and normalization decisions.

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

A model tailored to a specific database technology, specifying tables, columns, data types, indexes, partitioning, and constraints needed to implement the design.

Related: Logical Data Model, Normalization, Data Vault
Normalization

The process of organizing attributes into relations to remove redundancy and update anomalies, progressing through normal forms each with stricter rules on dependencies.

Related: Logical Data Model, Dimensional Model, Physical Data Model
Dimensional Model

A design for analytical querying that separates measurable events (facts) from descriptive context (dimensions), typically arranged in star or snowflake schemas for fast aggregation.

Related: Fact Table, Slowly Changing Dimension, Normalization
Slowly Changing Dimension

A technique for preserving history in a dimension so that attribute changes over time are tracked, commonly by adding rows or version columns rather than overwriting values.

Related: Dimensional Model, Fact Table
Data Vault

A modeling approach that separates stable business keys (hubs), relationships (links), and descriptive history (satellites), designed for auditability and parallel, incremental loading at scale.

Related: Physical Data Model, Change Data Capture
ETL

A data integration pattern in which data is extracted from sources, transformed in a separate processing tier, and then loaded into a target store.

Related: ELT, Data Pipeline, Data Integration
ELT

A data integration pattern in which raw data is loaded into a target platform first and transformed there using the platform's own compute, common with cloud warehouses.

Related: ETL, Data Pipeline
Change Data Capture

A technique for identifying and delivering only the inserts, updates, and deletes made to a source system since a prior point, reducing load and latency versus full extracts.

Related: Data Pipeline, Data Vault, Idempotency
Idempotency

A property of an operation whereby running it repeatedly with the same input produces the same result, which lets pipelines safely retry after failures without duplicating data.

Related: Change Data Capture, 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, ELT, Orchestration
Orchestration

The coordination of pipeline tasks, dependencies, and schedules so that jobs run in the correct order with retries, alerting, and resource control.

Related: Data Pipeline, Idempotency
Data Lakehouse

An architecture that combines low-cost object storage with table formats offering schema enforcement, transactions, and query performance, supporting both analytics and machine learning workloads.

Related: Data Warehouse, Data Lake, Data Pipeline
Data Warehouse

A centralized repository of integrated, subject-oriented, time-variant data structured for query and reporting rather than transaction processing.

Related: Dimensional Model, Data Lakehouse, Data Mart
Data Mart

A subset of a warehouse or lake scoped to one business area or audience, providing focused, often pre-aggregated data with simpler access controls.

Related: Data Warehouse, Dimensional Model
Data Lake

A storage repository holding raw data in native formats at scale, with schema applied on read, which offers flexibility but requires governance to avoid becoming unmanageable.

Related: Data Lakehouse, Data Warehouse, Data Catalog
Data Provenance

The record of a data item's origin, custody, and processing history, used to judge trustworthiness and to satisfy audit and reproducibility requirements.

Related: Data Lineage, Metadata
Regression Analysis

A statistical method that estimates how a dependent variable changes with one or more predictors, used for explanation, forecasting, and quantifying effect sizes with uncertainty.

Related: Hypothesis Test, Overfitting
Hypothesis Test

A procedure that compares observed data against a null assumption, yielding a probability that results are due to chance and supporting a decision to retain or reject the assumption.

Related: Regression Analysis, Confidence Interval
Confidence Interval

A range computed from sample data that, with a stated probability, contains the true population value, conveying both the estimate and the precision of that estimate.

Related: Hypothesis Test
Overfitting

A modeling failure in which a model captures noise specific to its training data, producing strong training results but weak performance on new, unseen data.

Related: Regression Analysis, Model Validation
Model Validation

The independent assessment of a model's conceptual soundness, data quality, performance, and limitations before use and periodically thereafter, documented for governance review.

Related: Overfitting, Model Risk
Data Classification

The assignment of data to sensitivity tiers, such as public, internal, confidential, or restricted, which determines the controls and handling rules that must be applied.

Related: Data Masking, Access Control, Data Retention
Data Masking

The replacement or obfuscation of sensitive values with realistic substitutes so that non-production or wider audiences can use the data without exposing protected information.

Related: Data Classification, Pseudonymization, Access Control
Pseudonymization

Replacing direct identifiers with artificial keys so that records can still be linked across datasets while attribution to a person requires separately held additional information.

Related: Data Masking, Data Classification
Access Control

The mechanisms that decide which identities may read, change, or share which data, implemented through roles, attributes, or policies and enforced at system boundaries.

Related: Data Classification, Least Privilege
Least Privilege

The principle that each identity receives only the minimum access needed for its current task, reducing the impact of compromise or error and simplifying access reviews.

Related: Access Control, Data Classification
Data Retention

A documented schedule specifying how long each class of data must be kept for legal, operational, or analytical needs, and when it must be securely deleted.

Related: Data Classification, Records of Processing
Data Strategy

A prioritized plan describing how data will be used to create business value, including target capabilities, investments, sequencing, and the measures by which success is judged.

Related: Data Maturity Model, Business Case, Data Roadmap
Data Maturity Model

A staged framework describing progressive levels of data capability, such as from ad hoc to managed to optimized, used to assess current state and plan improvement.

Related: Data Strategy, Data Roadmap
Data Roadmap

A time-phased sequence of initiatives, dependencies, and milestones that translates a data strategy into deliverable increments with owners and target dates.

Related: Data Strategy, Data Maturity Model
Model Risk

The potential for loss or harm arising from incorrect or misused models, managed through inventory, validation, monitoring, and clear ownership of each model.

Related: Model Validation, Overfitting
Reference Data

A controlled set of permissible values, such as country codes or product categories, shared across systems to keep classifications and joins consistent.

Related: Data Standard, Metadata
Records of Processing

A maintained register describing what personal data is processed, for which purposes, with whom it is shared, and how long it is kept, supporting accountability and regulatory requests.

Related: Data Retention, Data Classification