Archive for August, 2010
Data Warehouse terms
This post describes the different useful Data Warehouse terms which are closely associated with Kimbal Data Warehousing approach.
- Measure It is a numeric value in reporting and analysis. Example: Price,Balance or Inventory. Measures come from data sources. Measure is characterized by grain.
- Dimension A dimension is a collection of related values called members. example: 2008 is a member of Time. It can be described as an “axis of analysis”. In a query, dimension can be part of the query result. The most fundamental dimension is Time, which is essential in any context. Dimensions are typically master data entries.
Related Posts:
No commentsImportance of Data Warehousing and its Design
This post explains about what Data warehousing is and why we should care about it and then speaks about importance of using in enterprises and its design. It is important to understand the what data warehousing is all about, As a database developer you are likely to be involved with Data warehousing in one way or the other.
Data Warehousing Defined:
Data warehousing is a methodological approach for organizing and managing enterprise data to provide a trustworthy,consistent, integrated data foundation for an enterprise’s data-driven applications.
Importance
Data warehousing is must for running an enterprise of any size to make intelligent decisions. It enables the competitive advantage.Data warehousing is essentially tells about data and its relationships and it is foundation for Business Intelligence(BI). It clearly draws the distinction between data and information.
Related Posts:
No comments
