DEA Level 3 key terms
DEA Level 3 · Get comfortable with the vocabulary.
- Data Governance
- Related: Data Stewardship, Data Ownership, Data Policy
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.
- Data Stewardship
- Related: Data Governance, Data Ownership, Data Quality Rule
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.
- Data Ownership
- Related: Data Stewardship, Data Governance
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.
- Data Policy
- Related: Data Governance, Data Standard
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.
- Data Standard
- Related: Data Policy, Reference Data, Metadata
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.
- Metadata
- Related: Data Lineage, Data Catalog, Data Standard
Structured information describing other data, such as its meaning, origin, format, owner, and lineage, which enables discovery, interpretation, and control of data assets.
- Data Lineage
- Related: Metadata, Data Catalog, Data Provenance
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.
- Data Catalog
- Related: Metadata, Data Lineage, Business Glossary
An inventory of data assets with searchable descriptions, owners, classifications, and usage guidance, used by analysts and auditors to find and trust data.
- Business Glossary
- Related: Data Catalog, Data Standard, Conceptual Data Model
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.
- Data Quality Rule
- Related: Data Stewardship, Data Quality Dimension
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.
- Data Quality Dimension
- Related: Data Quality Rule
A named aspect of quality used to evaluate data, commonly accuracy, completeness, consistency, timeliness, validity, and uniqueness, each assessed with its own measures.
- Conceptual Data Model
- Related: Logical Data Model, Physical Data Model, Business Glossary
A technology-independent view of the business entities, their attributes, and relationships, used to agree scope and meaning before detailed design begins.
- Logical Data Model
- Related: Conceptual Data Model, Physical Data Model, Normalization
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.
- Physical Data Model
- Related: Logical Data Model, Normalization, Data Vault
A model tailored to a specific database technology, specifying tables, columns, data types, indexes, partitioning, and constraints needed to implement the design.
- Normalization
- Related: Logical Data Model, Dimensional Model, Physical Data Model
The process of organizing attributes into relations to remove redundancy and update anomalies, progressing through normal forms each with stricter rules on dependencies.
- Dimensional Model
- Related: Fact Table, Slowly Changing Dimension, Normalization
A design for analytical querying that separates measurable events (facts) from descriptive context (dimensions), typically arranged in star or snowflake schemas for fast aggregation.
- Slowly Changing Dimension
- Related: Dimensional Model, Fact Table
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.
- Data Vault
- Related: Physical Data Model, Change Data Capture
A modeling approach that separates stable business keys (hubs), relationships (links), and descriptive history (satellites), designed for auditability and parallel, incremental loading at scale.
- ETL
- Related: ELT, Data Pipeline, Data Integration
A data integration pattern in which data is extracted from sources, transformed in a separate processing tier, and then loaded into a target store.
- ELT
- Related: ETL, Data Pipeline
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.
- Change Data Capture
- Related: Data Pipeline, Data Vault, Idempotency
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.
- Idempotency
- Related: Change Data Capture, Data Pipeline
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.
- Data Pipeline
- Related: ETL, ELT, Orchestration
An automated sequence of steps that moves and transforms data between systems, including scheduling, error handling, monitoring, and dependency management.
- Orchestration
- Related: Data Pipeline, Idempotency
The coordination of pipeline tasks, dependencies, and schedules so that jobs run in the correct order with retries, alerting, and resource control.
- Data Lakehouse
- Related: Data Warehouse, Data Lake, Data Pipeline
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.
- Data Warehouse
- Related: Dimensional Model, Data Lakehouse, Data Mart
A centralized repository of integrated, subject-oriented, time-variant data structured for query and reporting rather than transaction processing.
- Data Mart
- Related: Data Warehouse, Dimensional Model
A subset of a warehouse or lake scoped to one business area or audience, providing focused, often pre-aggregated data with simpler access controls.
- Data Lake
- Related: Data Lakehouse, Data Warehouse, Data Catalog
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.
- Data Provenance
- Related: Data Lineage, Metadata
The record of a data item's origin, custody, and processing history, used to judge trustworthiness and to satisfy audit and reproducibility requirements.
- Regression Analysis
- Related: Hypothesis Test, Overfitting
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.
- Hypothesis Test
- Related: Regression Analysis, Confidence Interval
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.
- Confidence Interval
- Related: Hypothesis Test
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.
- Overfitting
- Related: Regression Analysis, Model Validation
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.
- Model Validation
- Related: Overfitting, Model Risk
The independent assessment of a model's conceptual soundness, data quality, performance, and limitations before use and periodically thereafter, documented for governance review.
- Data Classification
- Related: Data Masking, Access Control, Data Retention
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.
- Data Masking
- Related: Data Classification, Pseudonymization, Access Control
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.
- Pseudonymization
- Related: Data Masking, Data Classification
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.
- Access Control
- Related: Data Classification, Least Privilege
The mechanisms that decide which identities may read, change, or share which data, implemented through roles, attributes, or policies and enforced at system boundaries.
- Least Privilege
- Related: Access Control, Data Classification
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.
- Data Retention
- Related: Data Classification, Records of Processing
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.
- Data Strategy
- Related: Data Maturity Model, Business Case, Data Roadmap
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.
- Data Maturity Model
- Related: Data Strategy, Data Roadmap
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.
- Data Roadmap
- Related: Data Strategy, Data Maturity Model
A time-phased sequence of initiatives, dependencies, and milestones that translates a data strategy into deliverable increments with owners and target dates.
- Model Risk
- Related: Model Validation, Overfitting
The potential for loss or harm arising from incorrect or misused models, managed through inventory, validation, monitoring, and clear ownership of each model.
- Reference Data
- Related: Data Standard, Metadata
A controlled set of permissible values, such as country codes or product categories, shared across systems to keep classifications and joins consistent.
- Records of Processing
- Related: Data Retention, Data Classification
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.