DMLI study materials
DMLI study resources

DMLI key terms

DMLI · Get comfortable with the vocabulary.

Data Governance

The system of decision rights and accountability that determines who may create, change, approve, or retire data assets, and how those decisions are enforced across an organization.

Related: Data Steward, Data Policy, Data Ownership
Data Steward

A role accountable for the day-to-day quality, definition, and appropriate use of a specific data domain, acting as the operational bridge between business users and technical teams.

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

The assignment of ultimate accountability for a data domain to a named individual or role who approves definitions, access rules, and changes affecting that data.

Related: Data Steward, Data Custodian, Data Governance
Data Custodian

The role responsible for the technical storage, backup, security, and movement of data on behalf of owners, without deciding business meaning or permitted uses.

Related: Data Ownership, Data Steward, Access Control
Data Policy

A formal statement of principles and mandatory rules governing how data is acquired, stored, shared, protected, and disposed of, approved at an authoritative level of the organization.

Related: Data Governance, Data Standard, Data Retention
Data Standard

A documented, reusable rule specifying a required format, value set, or naming convention that data must follow to be considered acceptable for use.

Related: Data Policy, Data Quality Rule, Reference Data
Data Classification

The practice of assigning data to sensitivity or criticality categories so that handling, access, and protection controls can be applied consistently and proportionately.

Related: Access Control, Personally Identifiable Information, Data Retention
Access Control

The mechanisms that decide which users or systems may read, modify, or distribute a data resource, typically through roles, attributes, or explicit permission lists.

Related: Data Classification, Data Custodian, Least Privilege
Least Privilege

A security principle stating that each user or process receives only the minimum data access needed to perform its assigned tasks, for only as long as needed.

Related: Access Control, Data Classification
Personally Identifiable Information

Data that can be used, alone or combined with other data, to identify a specific individual, triggering privacy obligations such as notice, consent, and deletion rights.

Related: Data Classification, Data Retention, Data Masking
Data Retention

A documented schedule stating how long each category of data must be kept and when it must be destroyed, driven by legal, regulatory, and operational requirements.

Related: Data Policy, Personally Identifiable Information, Data Lifecycle
Data Masking

A technique that replaces or obscures sensitive values with realistic substitutes so that non-production users or analysts can work without seeing the original confidential data.

Related: Personally Identifiable Information, Access Control
Data Lifecycle

The stages a data asset passes through from creation or acquisition, through storage, use, sharing, archiving, and eventual deletion or destruction.

Related: Data Retention, Data Lineage, Metadata
Metadata

Structured information that describes other data, such as its name, meaning, format, owner, source, and permitted uses, enabling discovery and correct interpretation.

Related: Data Lineage, Data Catalog, Data Dictionary
Data Dictionary

A reference listing the fields in a dataset or system together with their definitions, data types, allowed values, and relationships to other fields.

Related: Metadata, Data Standard, Entity-Relationship Model
Data Catalog

An organized inventory of available data assets with searchable descriptions, ownership, lineage, and usage guidance that helps users find and trust suitable data.

Related: Metadata, Data Lineage, Data Steward
Data Lineage

A record of the origin and movement of data across systems and transformations, showing how each output was derived from its upstream sources.

Related: Metadata, Data Catalog, ETL
Master Data

The core reference entities shared across business processes and systems, such as customers, products, and locations, whose consistency is essential for reliable operations and reporting.

Related: Reference Data, Data Quality Dimension, Entity-Relationship Model
Reference Data

A controlled set of permitted codes or values used to categorize other data, such as country codes or status values, which must be consistent across systems.

Related: Master Data, Data Standard, Data Dictionary
Data Quality Dimension

A named aspect used to evaluate fitness of data for use, such as completeness, accuracy, consistency, timeliness, validity, or uniqueness.

Related: Data Quality Rule, Data Profiling, Data Cleansing
Data Quality Rule

A testable condition or threshold that data must satisfy, expressed so that violations can be detected automatically and routed for correction.

Related: Data Quality Dimension, Data Profiling, Data Cleansing
Data Profiling

The automated examination of a dataset to reveal value distributions, null rates, patterns, duplicates, and anomalies before rules or transformations are designed.

Related: Data Quality Rule, Data Cleansing, Data Lineage
Data Cleansing

The process of detecting and correcting or removing inaccurate, incomplete, duplicated, or malformed records so that data meets agreed quality expectations.

Related: Data Quality Rule, Data Profiling, Data Standard
ETL

A processing pattern that extracts data from sources, transforms it to meet target requirements, and loads it into a destination such as a warehouse.

Related: ELT, Data Warehouse, Data Lineage
ELT

A processing pattern that loads raw source data into a target platform first and then applies transformations there, leveraging the target system's compute power.

Related: ETL, Data Warehouse, Data Lake
Data Warehouse

A centralized, structured repository optimized for query and reporting that holds integrated, historically retained data drawn from multiple operational systems.

Related: Data Mart, Data Lake, Dimensional Model
Data Mart

A subset of a data warehouse scoped to a single business area or team, providing focused, easier-to-query data for that group's reporting needs.

Related: Data Warehouse, Dimensional Model, Star Schema
Data Lake

A storage repository that holds large volumes of raw or lightly processed data in native formats until a specific analytical need requires it to be structured.

Related: Data Warehouse, ELT, Data Lifecycle
Dimensional Model

A design approach that organizes data into measurable facts and descriptive dimensions, making it intuitive for business users to query and analyze.

Related: Star Schema, Fact Table, Data Warehouse
Star Schema

A dimensional design in which a central fact table references surrounding dimension tables directly, producing simple joins and predictable query performance.

Related: Dimensional Model, Fact Table, Data Mart
Fact Table

A table whose rows record measurable events or transactions, storing numeric measures plus keys that link to the descriptive dimension tables.

Related: Dimensional Model, Star Schema, Data Warehouse
Entity-Relationship Model

A conceptual diagramming method that represents things of interest as entities, their attributes, and the business relationships and cardinalities between them.

Related: Data Dictionary, Master Data, Normalization
Normalization

The structured design of relational tables to reduce redundancy and update anomalies by separating data into related tables according to dependency rules.

Related: Entity-Relationship Model, Dimensional Model
Data Integration

The set of practices and technologies that combine data from multiple sources into a unified, consistent view for operational or analytical use.

Related: ETL, ELT, Data Lineage
Business Intelligence

The discipline of turning stored data into reports, dashboards, and analyses that support operational monitoring and management decision-making.

Related: Key Performance Indicator, Data Visualization, Data Warehouse
Key Performance Indicator

A quantified measure tied to a strategic objective, with a defined calculation, target, and owner, used to judge whether performance is on track.

Related: Business Intelligence, Metric Definition, Data Visualization
Metric Definition

A documented, unambiguous specification of how a measure is calculated, including its numerator, denominator, filters, grain, and source fields.

Related: Key Performance Indicator, Data Dictionary, Business Intelligence
Data Visualization

The presentation of data as charts, graphs, or maps chosen to reveal patterns and comparisons clearly and honestly to a defined audience.

Related: Business Intelligence, Key Performance Indicator
Data Ethics

The application of moral principles to how data is collected, used, and shared, weighing fairness, transparency, consent, and potential harm to affected people.

Related: Personally Identifiable Information, Data Classification, Algorithmic Bias
Algorithmic Bias

Systematic unfairness in automated outputs that arises from skewed training data, flawed proxies, or design choices, producing unequal outcomes for groups of people.

Related: Data Ethics, Data Quality Dimension