Shop spring savings on Case Packs
Buy new:
-13% EUR50.04
EUR 12.96 delivery Monday, 13 April
Dispatches from: Amazon
Sold by: Amazon
EUR 50.04 with 13 percent savings
RRP: EUR 57.34
EUR 12.96 delivery Monday, 13 April. Details
Or fastest delivery Friday, 10 April. Details
In stock
EUR EUR 50.04 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
EUR EUR 50.04
Subtotal
Initial payment breakdown
Delivery cost, delivery date and order total (including tax) shown at checkout.
Shipper / Seller
Amazon
Amazon
Shipper / Seller
Amazon
Returns
Returnable within 30 days of receipt
Returnable within 30 days of receipt
Item can be returned in its original condition for a full refund within 30 days of receipt
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
Gift options
Available at checkout
Available at checkout This item is a gift. Change
At checkout, you can add a custom message, a gift receipt for easy returns and have the item gift-wrapped
EUR 44.32
EUR 4.01 delivery 15 - 17 April. Details
Only 1 left in stock.
EUR EUR 50.04 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
EUR EUR 50.04
Subtotal
Initial payment breakdown
Delivery cost, delivery date and order total (including tax) shown at checkout.
Dispatched from and sold by momox co uk.
Added to

Sorry, there was a problem.

There was an error retrieving your Wish Lists. Please try again.

Sorry, there was a problem.

List unavailable.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet or computer – no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

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

Follow the authors

Follow to get new release updates, special offers (including promotional offers), and improved recommendations.
See all
Ralph Kimball
Follow
Margy Ross
Follow
Something went wrong. Please try your request again later.

The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition Paperback – 21 Jun. 2013

by Ralph Kimball (Author), Margy Ross (Author)
4.6 out of 5 stars (750)
{"desktop_buybox_group_1":[{"displayPrice":"EUR 50.04","priceAmount":50.04,"currencySymbol":"EUR","integerValue":"50","decimalSeparator":".","fractionalValue":"04","symbolPosition":"left","hasSpace":true,"showFractionalPartIfEmpty":true,"offerListingId":"j%2B6qTWjAiYPNIqecK7G09nrUww9QzIF%2BnYyxdSZAWaYds2illdhT8RMZnhdtSVwtLGnXamz3cPrS5TNe3T0BGS5hHGrPXWo0WjB3DdpPKAkXzvF%2FppL9iQaGbFVWlZxv","locale":"en-GB","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"EUR 44.32","priceAmount":44.32,"currencySymbol":"EUR","integerValue":"44","decimalSeparator":".","fractionalValue":"32","symbolPosition":"left","hasSpace":true,"showFractionalPartIfEmpty":true,"offerListingId":"j%2B6qTWjAiYPNIqecK7G09nrUww9QzIF%2BypOU2TtzgiHz4%2F5YRsbakLjLB51mxhTo2Bx36b2bGyaf1j8FJ2cq4CcY0Yal%2F95k8C%2FSa7Q8M%2FS1RmUSUenYZts%2BoMjFlXxoXm2kUs9tieBJsRxaAHigPJMAM8JBwYIs%2BFoV%2BwHRKRPSXoFC7LS%2BwA%3D%3D","locale":"en-GB","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

Updated new edition of Ralph Kimball's groundbreaking book on dimensional modeling for data warehousing and business intelligence!

The first edition of Ralph Kimball's The Data Warehouse Toolkit introduced the industry to dimensional modeling, and now his books are considered the most authoritative guides in this space. This new third edition is a complete library of updated dimensional modeling techniques, the most comprehensive collection ever. It covers new and enhanced star schema dimensional modeling patterns, adds two new chapters on ETL techniques, includes new and expanded business matrices for 12 case studies, and more.

  • Authored by Ralph Kimball and Margy Ross, known worldwide as educators, consultants, and influential thought leaders in data warehousing and business intelligence
  • Begins with fundamental design recommendations and progresses through increasingly complex scenarios
  • Presents unique modeling techniques for business applications such as inventory management, procurement, invoicing, accounting, customer relationship management, big data analytics, and more
  • Draws real-world case studies from a variety of industries, including retail sales, financial services, telecommunications, education, health care, insurance, e-commerce, and more

Design dimensional databases that are easy to understand and provide fast query response with The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition.

Read more
Previous slide of product details
  1. ISBN-10
    1118530802
  2. ISBN-13
    978-1118530801
  3. Edition
    3rd
  4. Publication date
    21 Jun. 2013
  5. Part of series
    The Data Warehouse Toolkit
  6. Language
    English
  7. Dimensions
    18.8 x 3.3 x 23.11 cm
  8. Print length
    600 pages
Next slide of product details

Frequently bought together

This item: The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
EUR50.04
In stock
Sent from and sold by Amazon.
+
Fundamentals of Data Engineering: Plan and Build Robust Data Systems
EUR45.88
Get it as soon as Monday, Apr 13
Only 6 left in stock.
Sold by Unique Store Limited and sent from Amazon Fulfillment.
+
Designing Data–Intensive Applications: Big Ideas Behind Reliable, Scalable, and Maintainable Systems
EUR44.14
In stock
Sent from and sold by Amazon.
Total price: $00
To see our price, add these items to your basket.
Details
Added to Basket
Some of these items are dispatched sooner than the others.
Show details Hide details
Choose items to buy together.

From the brand

Previous page

  2. Recognized and respected throughout the world as the most influential leaders in the data warehousing and business intelligence (DW/BI) industry, Ralph Kimball, Margy Ross, and the rest of the Kimball Group are the team behind the bestselling book series on dimensional modeling and DW/BI methodology.

  3. The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
    The Data Warehouse Lifecycle Toolkit, 2nd Edition
    The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intellig...
    The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and De...

    See more Kimball Group books

    Visit the store

  4. Group photo outdoors showing several people in casual business attire against a natural backdrop with foliage.
Next page

Product description

Review

Select Guide Rating

From the Inside Flap

The most authoritative and comprehensive guide to dimensional modeling, from its originators—fully updated

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

Product details

  • Publisher ‏ : ‎ Wiley
  • Publication date ‏ : ‎ 21 Jun. 2013
  • Edition ‏ : ‎ 3rd
  • Language ‏ : ‎ English
  • Print length ‏ : ‎ 600 pages
  • ISBN-10 ‏ : ‎ 1118530802
  • ISBN-13 ‏ : ‎ 978-1118530801
  • Item weight ‏ : ‎ 1.01 kg
  • Dimensions ‏ : ‎ 18.8 x 3.3 x 23.11 cm
  • Part of series ‏ : ‎ The Data Warehouse Toolkit
  • Best Sellers Rank: 51,842 in Books (See Top 100 in Books)
  • Customer reviews:
    4.6 out of 5 stars (750)

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Ralph Kimball

    Ralph Kimball

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Ralph Kimball has been a leading visionary in the data warehouse industry since 1982 and is one of today's most internationally well-known speakers, consultants, and teachers on data warehousing. He writes the "Data Warehouse Architect" column for Intelligent Enterprise (formerly DBMS) magazine. Dr. Kimball's coauthors have each founded their own very successful data warehouse consulting firms: Laura Reeves of StarSoft Solutions; Margy Ross of DecisionWorks Consulting; and Warren Thornthwaite of InfoDynamics LLC.

    See more on the author's page
  2. Margy Ross

    Margy Ross

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Margy Ross is President of DecisionWorks Consulting. She was previously President of the Kimball Group. She has focused exclusively on data warehousing and business intelligence for more than 35 years, specializing in program/project strategy, business requirements analysis, and dimensional modeling. After helping hundreds of organizations with their data warehouse and business intelligence systems, she remains convinced that business acceptance is the true measure of DW/BI success.

    In addition to her consulting activities, Margy teaches onsite and public dimensional modeling classes, both domestically and internationally. She co-taught Dimensional Modeling in Depth with Ralph Kimball for more than a decade through Kimball University. She has taught dimensional modeling concepts to over 10,000 students. She graduated with a BS in Industrial Engineering from Northwestern University.

    For more information about Margy and DecisionWorks, visit decisionworks.com.

    See more on the author's page
  3. Margy Ross

    Margy Ross

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read book recommendations and more.

    See more on the author's page
Next page

Related books

Page 1 of 1Start again
Sponsored
Previous page
  1. Shop the store on Amazon ›
    Build Passive Income with AI – No Code? No Budget? No Problem!: Join the Digital Gold Rush Before It Passes You By
    Build Passive Income with AI – No Code? No Budget? No Problem!: Join the Digital Gold Rush Before It Passes You By
    4.34.3 out of 5 stars374
    EUR11.46
  2. Shop the store on Amazon ›
    Trading for Beginners: Learn Technical Analysis, Build Your Mindset And Start Earning - British English Version
    Trading for Beginners: Learn Technical Analysis, Build Your Mindset And Start Earning - British English Version
    4.54.5 out of 5 stars4
    EUR29.92
  3. Shop the store on Amazon ›
    The Wardrobe Project: A Year of Buying Less and Liking Yourself More
    The Wardrobe Project: A Year of Buying Less and Liking Yourself More
    4.84.8 out of 5 stars44
    EUR14.78 RRP:EUR19.44
  4. Shop the store on Amazon ›
    The Subtle Art of Leadership: Build Trust and Inspire Action with Small, Strategic Moves. Lead with Clarity, Confidence, and Care.
    The Subtle Art of Leadership: Build Trust and Inspire Action with Small, Strategic Moves. Lead with Clarity, Confidence, and Care.
    4.84.8 out of 5 stars36
    EUR17.19
  5. Shop the store on Amazon ›
    Step-by-Step Electrical Engineering: Learn and Apply Core Concepts Quickly. Build Your Knowledge with Practical Examples - No Background Required! Perfect for Aspiring Engineers and Enthusiasts!
    Step-by-Step Electrical Engineering: Learn and Apply Core Concepts Quickly. Build Your Knowledge with Practical Examples - No Background Required! Perfect for Aspiring Engineers and Enthusiasts!
    4.54.5 out of 5 stars207
    EUR23.51
Next page

Customer reviews

4.6 out of 5 stars
750 global ratings
Excellent, but.....
4 out of 5 stars
Excellent, but.....
If you need this book then you need it and the content is excellent. However, the pages have not been cut properly. Several pages are longer than others and stick out like some sort of flap. If I did not need the book for its content, then I would return it. This experience has meant its 4 stars rather than 5.
Hide
Thank you for your feedback
Sorry, there was an error
Sorry, we couldn't load the review

Top reviews from United Kingdom

  • Alexandra
    5.0 out of 5 stars Must have for data analysts
    Reviewed in the United Kingdom on 24 June 2019
    Format: PaperbackVerified Purchase
    The book is a must have for anyone working with databases and particularly data warehousing. Lot of examples and strong exposure to data warehouse theory.
    The most recent edition I know about.
    Helpful
     Report
  • Oleg
    5.0 out of 5 stars Excellent and perfect
    Reviewed in the United Kingdom on 16 November 2025
    Format: PaperbackVerified Purchase
    Must read and practice
    Helpful
     Report
  • pb2
    5.0 out of 5 stars The go to manual
    Reviewed in the United Kingdom on 7 December 2014
    Format: Kindle EditionVerified Purchase
    The go to book for datawarehousing.. Reads very well and each section has a bunch of relevant examples... Can't go wrong purchasing this...
    Helpful
     Report
  • Jason
    4.0 out of 5 stars Excellent, but.....
    Reviewed in the United Kingdom on 27 March 2021
    Format: PaperbackVerified Purchase
    If you need this book then you need it and the content is excellent. However, the pages have not been cut properly. Several pages are longer than others and stick out like some sort of flap. If I did not need the book for its content, then I would return it. This experience has meant its 4 stars rather than 5.
    Customer image
    Jason
    4.0 out of 5 stars
    Excellent, but.....

    Reviewed in the United Kingdom on 27 March 2021
    If you need this book then you need it and the content is excellent. However, the pages have not been cut properly. Several pages are longer than others and stick out like some sort of flap. If I did not need the book for its content, then I would return it. This experience has meant its 4 stars rather than 5.
    Images in this review
    Customer image
    3 people found this helpful
    Helpful
     Report
  • Priscilla Jordao
    5.0 out of 5 stars This is THE book
    Reviewed in the United Kingdom on 2 May 2014
    Format: Kindle EditionVerified Purchase
    If you work with Kimball's Business Intelligence methodology, you need to learn from the master! That's the way to go! Very easy to understand, definitely a must have!
    Helpful
     Report
  • Niall Curran
    5.0 out of 5 stars Excellent 😊
    Reviewed in the United Kingdom on 3 October 2017
    Format: PaperbackVerified Purchase
    The one and only book to buy as a Starter in Dimensional Modelling. Excellent 😊
    Helpful
     Report
  • James C Waller
    5.0 out of 5 stars Five Stars
    Reviewed in the United Kingdom on 7 December 2015
    Format: PaperbackVerified Purchase
    never read this book but it looks good on my desk. 10/10
    6 people found this helpful
    Helpful
     Report
  • DBA
    5.0 out of 5 stars Buy it.
    Reviewed in the United Kingdom on 26 June 2016
    Format: PaperbackVerified Purchase
    Excellent reference book, useful examples and guidance,
    Helpful
     Report

Top reviews from other countries

Translate all reviews to English
  • Nicolas Melgar Marín
    5.0 out of 5 stars La biblia del modelado de datos
    Reviewed in Spain on 20 October 2024
    Format: PaperbackVerified Purchase
    Este libro se le considera como la "biblia" del modelado de datos, al fin y al cabo, Kimball fue el padre del modelo de datos dimensional. Tiene unos capitulos introductorios donde se explican los conceptos básicos del modelado en general, para despues explicar los diferentes elementos del modelo dimensional y sus diferentes tipos. Ya más adelante, cada capítulo se centra en un área de negocio y presenta diferentes técnicas que se pueden aplicar a cada una de éstas áreas, con ejemplos de modelos y tal. También da consejos sobre que hacer y que no hacer en determinadas situaciones.

    El libro tiene su tiempo y algunos conceptos pueden estar un poco anticuados, pero siguen siendo uno de los pilares fundamentales del modelado de datos.

    Obviamente, el libro está en ingles y es necesario dominar el idioma para sacarle partido. Si quieres trabajar de modelador de datos, tienes alguna oferta de trabajo, o quieres profundizar en el tema, éste es tú libro.
    Report
  • Andrea Vincenzi
    5.0 out of 5 stars Sempre il numero uno
    Reviewed in Italy on 31 October 2013
    Format: PaperbackVerified Purchase
    Passano gli anni (Ralph Kimball ne ha quasi settanta e la prima edizione del libro è del 1996), ma questa nuova edizione è ancora un esempio di come dovrebbere essere scritto un libro di computer (o qualsiasi altro testo tecnico).
    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.
    Report
  • Nick C
    5.0 out of 5 stars A must for data modelers!
    Reviewed in Germany on 22 June 2025
    Format: PaperbackVerified Purchase
    Come on, it's Kimball! If you are a data architect/modeler, this is more than a must-read!
    Report
  • Luciano Martins dos Santos
    5.0 out of 5 stars Livro de cabeceira para o profissional de BI.
    Reviewed in Brazil on 22 April 2018
    Format: PaperbackVerified Purchase
    Este livro tem uma leitura de fácil compreensão, o autor explica os conceitos do Data Warehouse e modelagem de dados dimensional de uma forma didática e com estudos de casos do mundo real, para tornar a experiência real e o mais aplicável possível. Esta é bíblia do BI, pois, a modelagem de Data Warehouse do Ralph Kimble é o mais bem aceito e usado internacionalmente, então, isto torna essencial a todo profissional de BI. A única crítica que faço desta obra é que o escritor se torna meio redundante ou prolixo na explicação de alguns conceitos, mas nada que tire o alto valor do livro.
    Report
  • Danicash.L
    5.0 out of 5 stars Useful and good to read
    Reviewed in Canada on 14 July 2025
    Format: PaperbackVerified Purchase
    Nice book！very useful for learning data
    Report
See more reviews