The Data Warehouse Toolkit and over one million other books are available for Amazon Kindle. Learn more
  • List Price: $60.00
  • Save: $35.87 (60%)
Rented from RentU
To Rent, select Shipping State from options above
Due Date: Dec 20, 2014
FREE return shipping at the end of the semester. Access codes and supplements are not guaranteed with rentals.
Qty:1
  • List Price: $60.00
  • Save: $14.57 (24%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $20.81
Gift Card.
Have one to sell? Sell on Amazon
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 – July 1, 2013

ISBN-13: 978-1118530801 ISBN-10: 1118530802 Edition: 3rd

Buy New
Price: $45.43
Rent
Price: $24.13
46 New from $29.97 22 Used from $29.88
Rent from Amazon Price New from Used from
eTextbook
"Please retry"
Paperback
"Please retry"
$24.13
$45.43
$29.97 $29.88

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling + The Data WarehouseETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data + The Data Warehouse Lifecycle Toolkit
Price for all three: $125.62

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

  • Paperback: 600 pages
  • Publisher: Wiley; 3 edition (July 1, 2013)
  • Language: English
  • ISBN-10: 1118530802
  • ISBN-13: 978-1118530801
  • Product Dimensions: 9.2 x 7.4 x 1.2 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (33 customer reviews)
  • Amazon Best Sellers Rank: #13,210 in Books (See Top 100 in Books)

Editorial Reviews

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.


More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.7 out of 5 stars
5 star
28
4 star
3
3 star
1
2 star
0
1 star
1
See all 33 customer reviews
I have the first edition of this book and thought it was time to update.
Amazon Customer
I've read basically all of Kimball's books and follow his method but this book for me is not only the foundation to his method but very entertaining and easy to read.
Julio J. Baylac
Kimball's seminal text about data warehousing was always a strong read, and third time's a charm for this book.
Michael Helms

Most Helpful Customer Reviews

11 of 11 people found the following review helpful By Makersmark76 on July 18, 2013
Format: Kindle Edition Verified Purchase
I have been delivering data warehousing solutions with the kimball methodology for over 10 years. This version of the book deals with more of the not so perfect world issues we have to deal with. It adds to the design choices available to architects to use.the old books had more of an assumption that businesses will make changes to accommodate the simple modeling processes and many wont. I just hope the ETL book gets a more realistic rewrite soon as well.
3 Comments 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 5 people found the following review helpful By Mikhail on August 27, 2013
Format: Paperback Verified Purchase
If you want to understand why's of Data Warehousing, and avoid a really expensive architectural and process errors during DW lifecycle, this is the book to read. It only gets better with every edition.
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 3 people found the following review helpful By JP O'Connor on July 9, 2013
Format: Paperback Verified Purchase
This third edition is greatly expanded from the already excellent second edition of this book. Kimball and Ross apply their vast experience as consultants (who actually deliver) and as educators to this book, providing a reference that is up-to-date, relevant, and most of all that is practical in its application of the principles to real world designs and projects. Practitioners following Kimball methods enjoy a very high success rate.

One of the hallmarks of Kimball Group books is the emphasis on business perspective and successful implementation. The underlying theories are always clearly presented and accessible to the reader, yet the material is framed in the context of delivering real results for real clients. This skillful blend of theory and reality is refreshing and most useful to those who have to deliver.

Perusing the Table of Contents, one finds treatment of many topics in the context of specific industries. Do not make the mistake of assuming these chapters apply only to the specific industries mentioned; instead realize that the industries are used as examples to clarify and amplify the presentation of the underlying design principles. The underlying principles are clearly presented and it is easy to imagine how they apply to other industries. Several other chapters address broader issues, both technical and on the business side. The entire book is up to date with current practice and includes clear discussion of newer topics such as additional Slowly Changing Dimension (SCD) types, and big data, among numerous others.

This book is an excellent resource for those tasked with designing, or managing the design, of quality dimensional data models for real projects with real deadlines. Kimball and Ross deliver, and so does this latest edition.
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 3 people found the following review helpful By Michael Helms on July 4, 2013
Format: Paperback Verified Purchase
Kimball's seminal text about data warehousing was always a strong read, and third time's a charm for this book. Anyone who is even remotely acquainted with data warehousing will find something of interest, and serious data warehouse practitioners should take careful note of Kimball's recommendations.

I've seen a lot of BI projects before. The ones that succeed followed Kimball's methodology. The ones that failed didn't.
1 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
2 of 2 people found the following review helpful By aussiejim on September 1, 2013
Format: Paperback Verified Purchase
This book is great I have found it very helpful in many areas.
A seminal piece of work, the old versions are good too but this new version has chapters on big data for the practically minded (aka no hype) and all the familiar studies against different subject areas / industries.

A must for anyone serious about building or running a successful data warehouse that is understandable by the business.
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
1 of 1 people found the following review helpful By Julio J. Baylac on April 10, 2014
Format: Kindle Edition Verified Purchase
This is the second time I read this book. The first time was the second edition so this one brings some updated material to the table. Also the fact that I purchased the Kindle version makes it a great reference source for when I need to resolve "non-typical" business requirements and need a quick refresher.
I've read basically all of Kimball's books and follow his method but this book for me is not only the foundation to his method but very entertaining and easy to read.
I strongly recommend this to any business intelligence designer or developer. Without a solid data warehouse, you will not have the necessary foundation to build a coherent and consistent business intelligence reporting application. And the Kimball Group definitely delivers this through their method in this 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
1 of 1 people found the following review helpful By Rob Schenck on November 17, 2013
Format: Paperback Verified Purchase
The gold standard of Data Modeling and Storage. A must read for anyone who develops data collection, retention, and analysis systems from business processes.
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
1 of 1 people found the following review helpful By Andrea Vincenzi on October 31, 2013
Format: Paperback
Years go by (Ralph Kimball is almost 70 and the first edition of the book is from 1996), but this 3rd edition is still an example of how a computer book (or any technical book for that matter) should be written.
Like for the second edition, it's not just a cosmetic operation: the book contains many updates, new chapters and reingeneered sections that make it even more useful and readable.
For example, the types of slowly changing dimensions are now up to 7 (from 3 in the first edition). Another very useful addition is chapter 2, which contains a summary of all the techniques explained inside the book, together with the basic concepts and pointers to the more detailed discussions in the other chapters.
In conclusion, since the 1st edition this has been the best book for whoever wanted to learn the art of designing data warehouses; now, after 16 years and three editions, it's even more so, because it has become much more complete and because in the meantime dimensional techniques have become a global standard.
People who want to go deeper in dimensional techniques might want to complement this book with "Star schema: the complete reference" by Chris Adamson.
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

Customer Images

Most Recent Customer Reviews

Search