The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling 3rd Edition

Avoid Data Vault at all costs, just use this book as your guide to building a data warehouse.

I'm the "tech guy" for a startup -- we need something done/built, but don't have anyone who knows how to do it? Yep, that means I'll be doing it...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!

This is one of the best technical books I've read on any subject. The author doesn't waste any time on tedious introductions, but jumps right into the meat of the topic, which is something I appreciate. The book spends a reasonable amount of time on theory, then dives into a bunch of case studies showing how to apply the theory to common scenarios. This is good instructional technique.The authors are opinionated, but in a good way. They express views on how things ought to be done, based on long experience, and this helps moves the novice along the learning curve. I've seen a few critiques in other reviews that the authors are repetitive or make a big deal out of obvious things. This actually is good instructional technique; if you want to shape the behavior of a student, you need to repeat things over and over, because no one gets it the first time. As for what is obvious or not, that varies among students. Even when a practice is obvious to a particular student, it doesn't mean that he will actually conform to that practice in real life. People are often lazy and undisciplined, and don't do the things they were taught in kindergarten. It never hurts to reinforce the obvious.

This book is intended for DW/BI developers, but as a business user, I found it helpful to understand the process. The book begins with an overview, then has a series of case studies illustrating various techniques, then goes back to an overview. I would have preferred having all overviews at the front of the book. I also felt that the case studies got less detailed as the book went on. I would have preferred more diagrams, even when revisiting previously introduced concepts. Still, I found this very useful in understanding the process and structure of data warehouses and how it pertained to the data warehouse at my place of business.

Great book that captures a history that is often overlooked about data dimension modeling. Especially, the terms mentioned early in the book that help place context and perspective for many past projects that I have worked on. Thank you.

I learned a lot of things I did not know about dimensional modeling reading this book. I recommend reading it in its entirety. I wish it had code examples for creating the SCD's and Keys but even without it, its a great read.

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.

This is an informative data warehousing reference by an expert. I am giving this book 3 stars since it contains too much repetition and unnecessary wordiness. The information could have been condensed to less than one-third of the size of this book while maintaining its utility.