In a

data warehouse In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for Business intelligence, reporting and data analysis and is a core component of business intelligence. Data warehouses are central Re ...

, a measure is a property on which calculations (e.g., sum, count, average, minimum, maximum) can be made. A measure can either be categorical, algebraic or holistic.

Example

For example, if a retail store sold a specific product, the quantity and prices of each item sold could be added or averaged to find the total number of items sold or the total or average price of the goods sold.

Use of ISO representation terms

When entering data into a metadata registry such as

ISO/IEC 11179 The ISO/IEC 11179 metadata registry (MDR) standard is an international International Organization for Standardization, ISO/International Electrotechnical Commission, IEC standard for representing metadata for an organization in a metadata registry ...

representation term A representation term is a word, or a combination of words, that semantically represent the data type (value domain) of a data element. A representation term is commonly referred to as a ''class word'' by those familiar with data dictionaries. ISO ...

s such as number, value and measure are typically used as measures.

References

* Kimball, Ralph et al. (1998); ''The Data Warehouse Lifecycle Toolkit'', p17. Pub. Wiley. . * Kimball, Ralph (1996); ''The Data Warehouse Toolkit'', p100. Pub. Wiley. . * Han, Jiawei Pei, Jian Tong, Hanghang. (2023). Data Mining Concepts and Techniques (4th Edition) - 3.2.4 Measures: Categorization and Computation. (pp. 105). Elsevier. {{Data warehouse Data warehousing Metadata

Example

Use of ISO representation terms

See also

References