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

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!

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

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.

Other than the Ralph Kimball cheerleading section in the first couple of chapters, this is a great book for understanding how data warehouses work. The authors use several read-world examples and the text flows well. Good organization, starting with basic DW tables, moving to design concepts, variations on ETL architecture, and closing out with DW life cycle planning. With 21 chapters, covering many disciplines such as accounting, supply chain, marketing, operations, and others. I recommend this to anyone trying to understand the basics of data warehousing and analytics.

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.

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.

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.