- Paperback: 464 pages
- Publisher: Wiley; 2 edition (April 26, 2002)
- Language: English
- ISBN-10: 0471200247
- ISBN-13: 978-0471200246
- Product Dimensions: 7.4 x 1 x 9.2 inches
- Shipping Weight: 1.5 pounds (View shipping rates and policies)
- Average Customer Review: 63 customer reviews
- Amazon Best Sellers Rank: #637,040 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 Complete Guide to Dimensional Modeling 2nd 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 .
There is a newer edition of this item:
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
"...this is the daddy of data warehousing process books. No other material available so concisely and precisely explains what is required from a data warehousing solution...this is a great book..." (Enterprise Server Magazine, July 2002)
From the Back Cover
The latest edition of the single most authoritative guide on dimensional modeling for data warehousing!
Dimensional modeling has become the most widely accepted approach for data warehouse design. Here is a complete library of dimensional modeling techniques-- the most comprehensive collection ever written. Greatly expanded to cover both basic and advanced techniques for optimizing data warehouse design, this second edition to Ralph Kimball's classic guide is more than sixty percent updated.
The authors begin with fundamental design recommendations and gradually progress step-by-step through increasingly complex scenarios. Clear-cut guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business application areas and industries, including:
* Retail sales and e-commerce
* Inventory management
* Order management
* Customer relationship management (CRM)
* Human resources management
* Financial services
* Telecommunications and utilities
* Health care and insurance
By the end of the book, you will have mastered the full range of powerful techniques for designing dimensional databases that are easy to understand and provide fast query response. You will also learn how to create an architected framework that integrates the distributed data warehouse using standardized dimensions and facts.
Wiley Computer Publishing. Timely. Practical. Reliable.
Visit our Web site at www.wiley.com/compbooks/
Visit Kimball's Web site at www.kimballuniversity.com
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
This book was perfect for me. I have data that I needed to analyze; I understood normalized relational databases and pivot tables; I'd heard the jargon such as "star schema" and "snowflake schema" but didn't know exactly what they meant. This book put all the concepts together and moved my level of understanding up to a new level. I am not building the data warehouse myself but now I can talk the talk with those who are.
I had been using pivot tables in Excel to do some analysis, but had been frustrated at times by not being able to get things to work out as I wanted. After reading this book, I understand why - it was because I had not organized the underlying data correctly. To anyone with a relation database background, the organization of data in a data mart or warehouse is very different and goes against one's instinct to normalize and eliminate redundant data. Getting past that was key to getting my data right, and that's what this book did for me.
However, if you are the person who will actually be building the data warehouse, you will need to go beyond this book to one that shows you how to actually do what you need. For example, this book does not go into "details" like ETL - how you actually get data into the warehouse from the transaction database - and the other practical details you will need to know. This book is also database and tool agnostic - those are all details that you will need to find elsewhere once you understand the concepts here.
My only quibble is that this book is quite pricey for what you get.
This book is an amazing one. This is the best book to learn about Data Warehousing. Ralph has described using the most real time scenarios.
If you are new to Data Warehousing, I say you should definitely read this book. And if you are working, then you sure must go through the individual chapters based on domains. He has explained it very beautifully!!
Content-wise, I just started reading so I expect this book to still be useful even though it's a bit long in the tooth.
The second edition updates many of the concepts contained in the first and includes some new chapters on hot topics like CRM and Telecommunications (which is the most important sector for dw at least here in Italy where I live).
I think that Kimball books are everything that's needed to design good, robust and flexible data warehouses, and this book maintains his high quality standards.