Ralph Kimball Books

If you are involved in Business Intelligence, then the books by Ralph Kimball are required reading:

The Data Warehouse Lifecycle Toolkit: Practical Techniques for Building Data Warehouse and Business Intelligence Systems, Second Edition, 2008, 636 pages (Amazon).  Subject: Implementation guide.  Primary Audience: Good overview for all project participants; key tool for project managers, business analysts, and data modelers.  See Tools and Utilities.  Walks you through the detailed steps of designing, developing, and deploying a DW/BI system: Introduces the Kimball Lifecycle, managing the project, collecting the requirements, introducing the technical architecture, creating the architecture plan and selecting products, introducing and designing the dimensional model, designing the physical database and planning for performance, introducing and designing/developing ETL, introducing and designing/developing BI applications, deploying/supporting/expanding the DW/BI system

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, Second Edition, 2002, 436 pages (Amazon).  The third edition was published July 1, 2013 (Amazon).  Subject: Dimensional data modeling.  Primary Audience: Data modelers, business analysts, DBAs, ETL  developers.  Complete library of dimensional modeling techniques.  Starts with fundamental design recommendations and progresses through increasingly complex scenarios..  Has guidelines for designing dimensional models using real-world data warehouse case studies from retail, accounting, inventory, CRM, HR, financial, etc

The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data, First Edition, 2004, 491 pages (Amazon).  Subject: ETL system architecture.  Primary Audience: ETL architects and developers.  Shows you how to plan and design your ETL system, choose the appropriate architecture from the many possible options, build the development/test/production suite of ETL processes, build a comprehensive data cleaning subsystem, and tune the overall ETL process for optimum performance

The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence, First Edition, 2010, 744 pages (Amazon).  Subject: DW/BI system design and development.  Primary Audience: A topical reference book for all project participants. A collection of recommended guidelines for data warehousing and business intelligence. Compiles the best articles written by Ralph Kimball as his team of colleagues. Covers the complete lifecycle—including project planning, requirements gathering, dimensional modeling, ETL, and business intelligence (BI) and analytics

The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset, Second Edition, 2011, 696 pages (Amazon).  See Tools and Utilities.  The “bible” if you are using the Microsoft BI stack.  Think of it as a combination of the four previous books, taking parts of each, but making it specific to the Microsoft BI tool-set, where the other books are tool independent. The goal of the book is to guide the reader down the best path toward designing and building a successful business intelligence system and its underlying data warehouse databases using the Microsoft SQL Server product set

Kimball’s Data Warehouse Toolkit Classics: The Data Warehouse Toolkit, 2nd Edition; The Data Warehouse Lifecycle Toolkit, 2nd Edition; The Data Warehouse ETL Toolkit, 2009, 1628 pages (Amazon).  This is just a way to save money: instead of buying the three books separately you can make one purchase at a cost savings

About James Serra

James is a big data and data warehousing solution architect at Microsoft. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 25 years of IT experience.
This entry was posted in Business Intelligence, SQLServerPedia Syndication. Bookmark the permalink.

8 Responses to Ralph Kimball Books

  1. Jordan says:

    I think that the Kimball Books are great foundational for 80%, but Data Vaulting and Business Modeling have their place. Problem is. There are no books on the subjects.

  2. Pingback: Presentation Slides for Building an Effective Data Warehouse Architecture | James Serra's Blog

  3. Pingback: Why You Need a Data Warehouse - SQL Server - SQL Server - Toad World

  4. Pingback: Why You Need a Data Warehouse | James Serra's Blog

  5. The great people at Kimball Group sent me a signed copy of their MS Data Warehouse Toolkit With SQL Server 2008. (http://twitpic.com/cp23da) It’s a good resource, specially if you’re new to BI. It should be a required reading for anyone working around BI with SQL Server.

  6. Pingback: IT books that should be on your shelf - SQL Server - SQL Server - Toad World

  7. Pingback: Why You Need a Data Warehouse ?? | Microsoft SQL Server

  8. Jason Hurley says:

    Great post! I’ve always respected your writing, so when I was searching for the different Kimball books, I was glad to see you posted on it. I’m taking one of their classes and trying to decide which book I want to get for free with the class and this was a big help. I work exclusively with Microsoft, so your comment about the MS book comprising all of the other 4 books, you sold me. Thanks!