The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling

Ralph Kimball, Margy Ross


the newest version of the only such a lot authoritative advisor on dimensional modeling for info warehousing!

Dimensional modeling has develop into the main commonly permitted strategy for facts warehouse layout. here's a whole library of dimensional modeling techniques-- the main accomplished assortment ever written. drastically multiplied to hide either uncomplicated and complicated strategies for optimizing info warehouse layout, this moment version to Ralph Kimball's vintage consultant is greater than sixty percentage updated.

The authors commence with primary layout options and progressively growth step by step via more and more advanced situations. simple instructions for designing dimensional versions are illustrated utilizing real-world information warehouse case reviews drawn from numerous enterprise software parts and industries, including:

* Retail revenues and e-commerce

* stock management

* Procurement

* Order management

* shopper dating administration (CRM)

* Human assets management

* Accounting

* monetary services

* Telecommunications and utilities

* Education

* Transportation

* healthiness care and insurance

By the tip of the booklet, you've mastered the total variety of robust suggestions for designing dimensional databases which are effortless to appreciate and supply quickly question reaction. additionally, you will the way to create an architected framework that integrates the dispensed facts warehouse utilizing standardized dimensions and facts.

This e-book can also be on hand as a part of the Kimball's info Warehouse Toolkit Classics field Set (ISBN: 9780470479575) with the next three books:

The info Warehouse Toolkit, second version (9780471200246)

The facts Warehouse Lifecycle Toolkit, 2d version (9780470149775)

The information Warehouse ETL Toolkit (9780764567575)

Show sample text content

Download sample