- File Size: 24015 KB
- Print Length: 600 pages
- Publisher: Wiley; 3 edition (July 1, 2013)
- Publication Date: July 1, 2013
- Sold by: Amazon.com Services LLC
- Language: English
- ASIN: B00DRZX6XS
- Text-to-Speech: Enabled
- Word Wise: Not Enabled
- Lending: Enabled
- Amazon Best Sellers Rank: #86,376 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling 3rd Edition, Kindle Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Book recommendations, author interviews, editors' picks, and more. Read it now
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.
Customers who bought this item also bought
From the Back Cover
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
MARGY ROSS is President of DecisionWorks Consulting 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.
Would you like to tell us about a lower price?
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.
I've seen a lot of BI projects before. The ones that succeed followed Kimball's methodology. The ones that failed didn't.
Top international reviews
The most recent edition I know about.
Come per la seconda edizione, anche per questa terza non si tratta solo di un’operazione cosmetica: il testo contiene molti aggiornamenti, capitoli nuovi e reingegnerizzazioni che lo rendono ancora più valido e leggibile.
Ad esempio, i tipi di slowly changing dimension descritti sono arrivati a 7 (dai 3 della prima edizione). Altra aggiunta utilissima il capitolo 2, che raccoglie un elenco di tutte le tecniche contenute nel libro con i concetti base e i rimandi alle trattazioni dettagliate.
Quindi, riassumendo: fin dalla prima edizione questo era il testo di riferimento per chiunque volesse imparare come si progetta un data warehouse, adesso dopo 16 anni lo è ancora di più, essendo molto migliorato ed essendo nel frattempo le tecniche dimensionali diventate uno standard a livello globale.
Chi voglia approfondire le tecniche dimensionali con altri esempi e ottime spiegazioni lo può eventualmente complementare con “Star schema: the complete reference” di Chris Adamson.