- 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: #38,696 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 .
See the Best Books of 2018 So Far
Looking for something great to read? Browse our editors' picks for the best books of the year so far in fiction, nonfiction, mysteries, children's books, and much more.
Frequently bought together
Customers who bought this item also bought
From the Back Cover
The most authoritative and comprehensive guide to dimensionalmodeling, from its originators—fully updated
Ralph Kimball introduced the industry to the techniques ofdimensional modeling in the first edition of The Data WarehouseToolkit (1996). Since then, dimensional modeling has become themost widely accepted approach for presenting information in datawarehouse and business intelligence (DW/BI) systems. The DataWarehouse Toolkit is recognized as the definitive source fordimensional modeling techniques, patterns, and best practices.
This third edition of the classic reference delivers the mostcomprehensive library of dimensional modeling techniques everassembled. Fully updated with fresh insights and best practices,this book provides clear guidelines for designing dimensionalmodels—and does so in a style that serves the needs of thosenew to data warehousing as well as experienced professionals.
All the techniques in the book are illustrated with real-worldcase studies based on the authors' actual DW/BI design experiences.In addition, the Kimball Group's "official" list of dimensionalmodeling techniques is summarized in a single chapter for easyreference, with pointers from each technique to the case studieswhere the concepts are brought to life.
The third edition of The Data Warehouse Toolkitcovers:
- Practical design techniques—both basic andadvanced—for dimension and fact tables
- 14 case studies, including retail sales, electronic commerce,customer relationship management, procurement, inventory, ordermanagement, accounting, human resources, financial services,healthcare, insurance, education, telecommunications, andtransportation
- Sample data warehouse bus matrices for 12 case studies
- Dimensional modeling pitfalls and mistakes to avoid
- Enhanced slowly changing dimension techniques type 0 through7
- Bridge tables for ragged variable depth hierarchies andmultivalued attributes
- Best practices for Big Data analytics
- Guidelines for collaborative, interactive design sessions withbusiness stakeholders
- An overview of the Kimball DW/BI project lifecyclemethodology
- Comprehensive review of extract, transformation, and load (ETL)systems and design considerations
- The 34 ETL subsystems and techniques to populate dimension andfact tables
About the Author
RALPH KIMBALL, PhD, has been a leading visionary in thedata warehouse and business intelligence industry since 1982.The Data Warehouse Toolkit book series have been bestsellerssince 1996.
MARGY ROSS is President of the Kimball Group and thecoauthor of five Toolkit books with Ralph Kimball. She hasfocused exclusively on data warehousing and business intelligencefor 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!