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
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.
Pingback:Presentation Slides for Building an Effective Data Warehouse Architecture | James Serra's Blog
Pingback:Why You Need a Data Warehouse - SQL Server - SQL Server - Toad World
Pingback:Why You Need a Data Warehouse | James Serra's Blog
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.
Pingback:IT books that should be on your shelf - SQL Server - SQL Server - Toad World
Pingback:Why You Need a Data Warehouse ?? | Microsoft SQL Server
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!