(?)
Quotes are added by the Goodreads community and are not verified by Goodreads. (Learn more)

“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”

Ralph Kimball, The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Read more quotes from Ralph Kimball


Share this quote:
Share on Twitter

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 The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling by Ralph Kimball
1,016 ratings, average rating, 61 reviews
Open Preview

Browse By Tag