The Data Warehouse Toolkit and over 2 million other books are available for Amazon Kindle . Learn more

Sign in to turn on 1-Click ordering.
Trade in Yours
For a 12.75 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Image not available

Start reading The Data Warehouse Toolkit on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling [Paperback]

Ralph Kimball , Margy Ross
3.8 out of 5 stars  See all reviews (5 customer reviews)
RRP: 42.50
Price: 27.63 & FREE Delivery in the UK. Details
You Save: 14.87 (35%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Monday, 14 July? Choose Express delivery at checkout. Details


Amazon Price New from Used from
Kindle Edition 26.25  
Paperback 27.63  
Trade In this Item for up to 12.75
Trade in The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling for an Amazon Gift Card of up to 12.75, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

9 July 2013 1118530802 978-1118530801 3rd Edition
Updated new edition of Ralph Kimball′s groundbreaking book on dimensional modeling for data warehousing and business intelligence! The first edition of Ralph Kimball′s  The Data Warehouse Toolkit  introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more. Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence Begins with fundamental design recommendations and progresses through increasingly complex scenarios Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more Draws real–world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e–commerce, and more Design dimensional databases that are easy to understand and provide fast query response with  The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition .

Special Offers and Product Promotions

  • Spend 30 and get Norton 360 21.0 - 3 Computers, 1 Year 2014 for 24.99. Here's how (terms and conditions apply)
  • Seasonal Offer:
    This title is part of our Seasonal Offers promotion.

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: 78.62

Buy the selected items together

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: 23.4 x 18.8 x 2.9 cm
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Bestsellers Rank: 19,814 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 dimensional modeling, from its originators—fully updated Ralph Kimball introduced the industry to the techniques of dimensional modeling in the first edition of The Data Warehouse Toolkit (1996). Since then, dimensional modeling has become the most widely accepted approach for presenting information in data warehouse and business intelligence (DW/BI) systems. The Data Warehouse Toolkit is recognized as the definitive source for dimensional modeling techniques, patterns, and best practices. This third edition of the classic reference delivers the most comprehensive library of dimensional modeling techniques ever assembled. Fully updated with fresh insights and best practices, this book provides clear guidelines for designing dimensional models—and does so in a style that serves the needs of those new to data warehousing as well as experienced professionals. All the techniques in the book are illustrated with real-world case studies based on the authors' actual DW/BI design experiences. In addition, the Kimball Group's "official" list of dimensional modeling techniques is summarized in a single chapter for easy reference, with pointers from each technique to the case studies where the concepts are brought to life. The third edition of The Data Warehouse Toolkit covers: Practical design techniques—both basic and advanced—for dimension and fact tables 14 case studies, including retail sales, electronic commerce, customer relationship management, procurement, inventory, order management, accounting, human resources, financial services, healthcare, insurance, education, telecommunications, and transportation Sample data warehouse bus matrices for 12 case studies Dimensional modeling pitfalls and mistakes to avoid Enhanced slowly changing dimension techniques type 0 through 7 Bridge tables for ragged variable depth hierarchies and multivalued attributes Best practices for Big Data analytics Guidelines for collaborative, interactive design sessions with business stakeholders An overview of the Kimball DW/BI project lifecycle methodology Comprehensive review of extract, transformation, and load (ETL) systems and design considerations The 34 ETL subsystems and techniques to populate dimension and fact tables

About the Author

RALPH KIMBALL, PhD, has been a leading visionary in the data warehouse and business intelligence industry since 1982. The Data Warehouse Toolkit book series have been bestsellers since 1996. MARGY ROSS is President of the Kimball Group and the coauthor of five Toolkit books with Ralph Kimball. She has focused exclusively on data warehousing and business intelligence for 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

Most Helpful Customer Reviews
2 of 2 people found the following review helpful
4.0 out of 5 stars A bit dated 16 Feb 2014
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?
3.0 out of 5 stars Old wine in new bottle 23 Jun 2014
By Mobi
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?
5.0 out of 5 stars This is THE book 2 May 2014
Format:Kindle Edition|Verified Purchase
If you work with Kimball's Business Intelligence methodology, you need to learn from the master! That's the way to go! Very easy to understand, definitely a must have!
Comment | 
Was this review helpful to you?
2 of 3 people found the following review helpful
5.0 out of 5 stars The how to guide for building a data warehouse 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?
0 of 3 people found the following review helpful
2.0 out of 5 stars Awful 12 April 2014
Format:Paperback|Verified Purchase
Long, boring and an awful read. It just wasn't for me. I was looking more for a business type book but this is techincally orientated. If you want to know how to build a DI/DW system then this book is for you.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category