“Dimensions for Descriptive Context Dimensions provide the “who, what, where, when, why, and how” context surrounding a business process event. Dimension tables contain the descriptive attributes used by BI applications for filtering and grouping the facts. With the grain of a fact table firmly in mind, all the possible dimensions can be identified. Whenever possible, a dimension should be single valued when associated with a given fact row. Dimension tables are sometimes called the “soul” of the data warehouse because they contain the entry points and descriptive labels that enable the DW/BI system to be leveraged for business analysis. A disproportionate amount of effort is put into the data governance and development of dimension tables because they are the drivers of the user's BI experience. Chapter 1 DW/BI and Dimensional Modeling Primer Chapter 3 Retail Sales Chapter 11 Telecommunications Chapter 18 Dimensional Modeling Process and Tasks Chapter 19 ETL Subsystems and Techniques”
―
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Share this quote:
Friends Who Liked This Quote
To see what your friends thought of this quote, please sign up!
0 likes
All Members Who Liked This Quote
None yet!
This Quote Is From
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
by
Ralph Kimball1,016 ratings, average rating, 61 reviews
Open Preview
Browse By Tag
- love (101561)
- life (79521)
- inspirational (75958)
- humor (44409)
- philosophy (31065)
- inspirational-quotes (28949)
- god (26942)
- truth (24775)
- wisdom (24685)
- romance (24395)
- poetry (23348)
- life-lessons (22647)
- quotes (21145)
- death (20582)
- travel (19611)
- happiness (19033)
- hope (18561)
- faith (18427)
- inspiration (17329)
- spirituality (15757)
- relationships (15676)
- life-quotes (15586)
- religion (15407)
- love-quotes (15367)
- motivational (15339)
- writing (14953)
- success (14197)
- motivation (13196)
- time (12883)
- motivational-quotes (12570)
