- Paperback: 600 pages
- Publisher: Wiley; 3 edition (July 1, 2013)
- Language: English
- ISBN-10: 1118530802
- ISBN-13: 978-1118530801
- Product Dimensions: 7.2 x 1.1 x 9.1 inches
- Shipping Weight: 2.4 pounds (View shipping rates and policies)
- Average Customer Review: 83 customer reviews
- Amazon Best Sellers Rank: #31,550 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling 3rd Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
Frequently bought together
Customers who viewed this item also viewed
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.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
I do wish that there was less "Kimball" marketing in the text. All the readers will understand that this book (and others) originated with Ralph Kimball and represent his viewpoints. Thank god there wasn't a (tm) after each reference to Kimball...
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.
Concepts are good, I like the layout as well and the fact that updates and revisions have good additional content is a plus.
I've seen a lot of BI projects before. The ones that succeed followed Kimball's methodology. The ones that failed didn't.
Knowing *nothing* about dimensional modeling, I was asked to lead the team that's now building our data warehouse. This book (described as "the book on EDW" by the one exec at the company who's done this before) didn't make me an expert or anything, but it provided a solid foundation of the high-level concepts and some of the major low-level issues that only come up when you're actually trying to build and maintain a data warehouse.
Put another way, it didn't answer all my questions, but I was at least asking the right questions after going through it. (Ex: "Should we handle this as an SCD-Type 1 or -Type 2 dimension?"*, rather than "Wait, what's an SCD?")
I now spend most of my day talking and thinking about data warehouses, and I still find myself reaching for this book on a weekly basis. Take some time to read it through all the way, then keep it nearby, since it's a helpful reference guide for major concepts. (But not for any specific platform or vendor. If you want something specific to SSIS, for example, get another book. Better yet, get this one AND another book!)
If you're looking for more ETL-specific information, there's another book by Ralph Kimball (and a different co-author. Joe Caserta) called "The Data Warehouse ETL Toolkit"). It's useful, but not nearly as useful as this one.
*Answer: neither, and both. We actually ended up using a Type 6 approach!