Community hub
0 subscribers7 pages, 0 posts
Recent from talks
All channels
Be the first to start a discussion here.
Be the first to start a discussion here.
Be the first to start a discussion here.
Be the first to start a discussion here.
Contribute something
Welcome to the community hub built to collect knowledge and have discussions related to Measure (data warehouse).
Nothing was collected or created yet.
Measure (data warehouse)
View on Wikipediafrom Wikipedia
In a data warehouse, 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
[edit]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
[edit]When entering data into a metadata registry such as ISO/IEC 11179, representation terms such as number, value and measure are typically used as measures.
See also
[edit]References
[edit]- Kimball, Ralph et al. (1998); The Data Warehouse Lifecycle Toolkit, p17. Pub. Wiley. ISBN 0-471-25547-5.
- Kimball, Ralph (1996); The Data Warehouse Toolkit, p100. Pub. Wiley. ISBN 0-471-15337-0.
- Han, Jiawei Pei, Jian Tong, Hanghang. (2023). Data Mining Concepts and Techniques (4th Edition) - 3.2.4 Measures: Categorization and Computation. (pp. 105). Elsevier.