The Data Warehouse Toolkit and over 2 million other books are available for Amazon Kindle . Learn more
£24.21
  • RRP: £42.50
  • You Save: £18.29 (43%)
FREE Delivery in the UK.
In stock.
Dispatched from and sold by Amazon.
Gift-wrap available.
Quantity:1
The Data Warehouse Toolki... has been added to your Basket
Trade in your item
Get a £11.56
Gift Card.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling Paperback – 9 Jul 2013


See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle Edition
"Please retry"
Paperback
"Please retry"
£24.21
£21.41 £22.47

Frequently Bought Together

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling + Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema + The Data Warehouse Lifecycle Toolkit
Price For All Three: £67.30

Buy the selected items together


Trade In this Item for up to £11.56
Trade in The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling for an Amazon Gift Card of up to £11.56, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Product details

  • Paperback: 600 pages
  • Publisher: John Wiley & Sons; 3rd Edition edition (9 July 2013)
  • Language: English
  • ISBN-10: 1118530802
  • ISBN-13: 978-1118530801
  • Product Dimensions: 18.8 x 2.8 x 23.6 cm
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (9 customer reviews)
  • Amazon Bestsellers Rank: 8,942 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Authors

Discover books, learn about writers, and more.

Product Description

From the Back Cover

The most authoritative and comprehensive guide to dimensionalmodeling, from its originators fully updated

Ralph Kimball introduced the industry to the techniques ofdimensional modeling in the first edition of The Data WarehouseToolkit (1996). Since then, dimensional modeling has become themost widely accepted approach for presenting information in datawarehouse and business intelligence (DW/BI) systems. The DataWarehouse Toolkit is recognized as the definitive source fordimensional modeling techniques, patterns, and best practices.

This third edition of the classic reference delivers the mostcomprehensive library of dimensional modeling techniques everassembled. Fully updated with fresh insights and best practices,this book provides clear guidelines for designing dimensionalmodels and does so in a style that serves the needs of thosenew to data warehousing as well as experienced professionals.

All the techniques in the book are illustrated with real–worldcase studies based on the authors′ actual DW/BI design experiences.In addition, the Kimball Group′s "official" list of dimensionalmodeling techniques is summarized in a single chapter for easyreference, with pointers from each technique to the case studieswhere the concepts are brought to life.

The third edition of The Data Warehouse Toolkitcovers:

  • Practical design techniques both basic andadvanced for dimension and fact tables
  • 14 case studies, including retail sales, electronic commerce,customer relationship management, procurement, inventory, ordermanagement, accounting, human resources, financial services,healthcare, insurance, education, telecommunications, andtransportation
  • Sample data warehouse bus matrices for 12 case studies
  • Dimensional modeling pitfalls and mistakes to avoid
  • Enhanced slowly changing dimension techniques type 0 through7
  • Bridge tables for ragged variable depth hierarchies andmultivalued attributes
  • Best practices for Big Data analytics
  • Guidelines for collaborative, interactive design sessions withbusiness stakeholders
  • An overview of the Kimball DW/BI project lifecyclemethodology
  • Comprehensive review of extract, transformation, and load (ETL)systems and design considerations
  • The 34 ETL subsystems and techniques to populate dimension andfact tables

About the Author

RALPH KIMBALL, PhD, has been a leading visionary in thedata warehouse and business intelligence industry since 1982.The Data Warehouse Toolkit book series have been bestsellerssince 1996.

MARGY ROSS is President of the Kimball Group and thecoauthor of five Toolkit books with Ralph Kimball. She hasfocused exclusively on data warehousing and business intelligencefor more than 30 years.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Search inside this book:

Customer Reviews

4.1 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

3 of 3 people found the following review helpful By Mobi on 23 Jun. 2014
Format: Paperback
This is a long overdue reincarnation of Kimball's earlier 2nd edition. This edition continues with same format (the reading at places can be boring).

The new additions which are worth mention is that inclusion of chapters where Kimball actually advocated usage of hybrid approach (Inmon & Kimball together) and where he explained end to end project management phases of a large BI/DWH programs.

There were some verbose chapters on ETL technology as well.

There was a chapter on Big Data but it felt like an afterthough only to be mentioned in blurb. The book does not cover how data modelling differs in Big Data world. Technically it does cover, but not with examples as main part of book was written for RDBMS world.

May be that will happen in 4th edition of the book!
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
5 of 6 people found the following review helpful By Mrs. D. Kelly on 16 Feb. 2014
Format: Paperback
Back in the day, this was one of my most-referenced references.

If you work exclusively in relational data warehouses, such as Oracle RDBMS, then it's indispensable. It is still brilliant, and if you want to be a serious BI practitioner, you need to /know/ this text back to front. You need to know it *today*.

But times have moved on. I haven't built a presentation layer for seven years that was based on a /relational/ data warehouse. I still build 'em; it's just that they're only feeders for multidimensional hypercubes.

Back in 2002 I used Analysis Services to build a hypercube with 100 million sales and stock facts for a big retailer. It had a couple of seconds response time. Three years later we were writing sophisticated predictive analytics with multidimensional extensions (MDX).

There's no mention of this in the book. Solid on ETL, great on some industry-standard structures (but see stuff by Len Silverston et al), there's no question any aspiring BI person needs to know everything in here. But it's not enough.

I want to see this book updated to describe how to create a physical non-indexed DW as a feeder for a hypercube. I want to see the power and speed advantages of hypercubes described. I want to hear about the dramatic improvements in the presentation layer possible through the use of MDX. I want to hear about the security and /organisational/ issues involved in allowing reporting developers access to the presentation layer.

In short, as a new edition, this seems to fall a bit short. Still recommended, but . . .
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 4 people found the following review helpful By Dale Peakall on 18 Dec. 2013
Format: Kindle Edition
This book can take you from having no idea about how to implement a data warehouse to having a complete data model implemented that will support your business users needs.

The book includes some introductory details about the planning and management of your data warehouse/business intelligence project and also about the ETL process to populate your model - but you will need to read other books to complete your knowledge on those subjects.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
By pb2 on 7 Dec. 2014
Format: Kindle Edition Verified Purchase
The go to book for datawarehousing.. Reads very well and each section has a bunch of relevant examples... Can't go wrong purchasing this...
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
i think is well explained, easy to understand, but i haven't finished yet
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again


Feedback