A complete list of data warehousing and business intelligence books

Data warehousing and business intelligence books for designing and architecting a data warehouse

DW 2.0: The Architecture for the Next Generation of Data Warehousing
Building the Data Warehouse by W. H. Inmon
Mastering Data Warehouse Design: Relational and Dimensional Techniques by Claudia Imhoff, Nicholas Galemmo, and Jonathan G. Geiger
Building and Maintaining a Data Warehouse
The Business of Data Vault Modeling
Evolving Application Domains of Data Warehousing and Mining: Trends and Solutions
Complex Data Warehousing and Knowledge Discovery for Advanced Retrieval Development: Innovative Methods and Applica
Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance
Data Warehouse Design Solutions by Christopher Adamson and Michael Venerable
Parallel Processing Techniques for Data Warehousing and Mining: Application and Challenges
Advanced Data Warehouse Design: From Conventional to Spatial and Temporal Applications (Data-centric Systems and Applications)
Data Warehouse Implementations: Critical Implementation Factors Study
Fundamentals of Data Warehouses
Parallel Systems in the Data Warehouse (Data Warehousing Institute)
Encyclopedia of Data Warehousing and Mining, Second Edition
Data Warehousing : Design, Development and Best Practices
New Trends in Data Warehousing and Data Analysis (Annals of Information Systems)
Building the Operational Data Store (Wiley computer publishing)

Books on recent research in data warehousing and business intelligence

Data Warehousing and Knowledge Discovery: 9th International Conference, DaWaK 2007, Regensburg, Germany, September
Data Warehousing and Knowledge Discovery: 10th International Conference, DaWak 2008 Turin, Italy, September 1-5, 20
Advances in Database Technologies: ER Workshops on Data Warehousing and Data Mining, Mobile Data Access Mukesh Kumar Mohania

Data warehousing and business intelligence books for near real time data warehousing

Data Warehousing with Service-oriented Architecture: Designing and Implementing Prototype Models For an Integration

Data warehousing and business intelligence books for (data) modeling

The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling by Ralph Kimball and Margy Ross
Entity-attribute-value model: Data model, Data warehouse, Denormalization, Attribute- value system, Linked Data, Resource Description Framework, Semantic Web, Inner- platform effect
The Data Model Resource Book: A Library of Logical Data and Data Warehouse Models by Len Silverston, W. H. Inmon, and Kent Graziano
Common Warehouse Metamodel: An Introduction to the Standard for Data Warehouse Integration (Omg) by John Poole, Dan Chang, Douglas Tolbert, and David Mellor

Data warehousing and business intelligence books for SAP

Data Warehousing with SAP Bw7 Bi in SAP Netweaver 2004s: Architecture, Concepts, and Implementation by

Data Warehousing: Using the Wal-Mart Model (The Morgan Kaufmann Series in Data Management Systems) by

Leveraging DB2 Data Warehouse Edition for Business Intelligence by IBM Redbooks
50 Tb Data Warehouse Benchmark on IBM System Z by IBM Redbooks
IBM Data Warehousing: With IBM Business Intelligence Tools

Data warehousing and business intelligence books for MySQL

Dimensional Data Warehousing with MySQL: A Tutorial by Djoni Darmawikarta

Data warehousing and business intelligence books for open source environments

Dimensional Data Warehousing with MySQL: A Tutorial by Djoni Darmawikarta
Pentaho Solutions: Business Intelligence and Data Warehousing with Pentaho and MySQL

Data warehousing and business intelligence books for beginners and managers

A Manager’s Guide to Data Warehousing by Laura Reeves
Data Warehousing for Dummies by Thomas C. Hammergren
Data Warehousing Fundamentals: A Comprehensive Guide for IT Professionals
Implementing Enterprise Data Warehousing: A Guide for Executives
e-Data: Turning Data Into Information With Data Warehousing by
Modern Data Warehousing, Mining, and Visualization: Core Concepts
Data Warehousing Advice for Managers
The Essential Guide to Data Warehousing by Lou Agosta
Data Warehousing: The Ultimate Guide to Building Corporate Business Intelligence

Data warehousing and business intelligence books for SQL Server

Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset by Joy Mundy, Warren Thornthwaite, and Ralph Kimball
Microsoft SQL Server 2005 Analysis Services
Professional Microsoft SQL Server Analysis Services 2008 with MDX
Microsoft SQL Server 2008 Analysis Services Step by Step
Building a Data Warehouse: With Examples in SQL Server
Delivering Business Intelligence with Microsoft SQL Server 2008

Data warehousing and business intelligence books for SAS

Strategic Data Warehousing Principles Using SAS Software

Data warehousing and business intelligence books for web analytics

The Data Webhouse Toolkit: Building the Web-enabled Data Warehouse
Clickstream Data Warehousing
Web-enabled Data Warehouse
Data Warehousing and Web Engineering

Data warehousing and business intelligence books for project management

A Manager’s Guide to Data Warehousing by Laura Reeves
Agile Data Warehousing: Delivering World-Class Business Intelligence Systems Using Scrum and XP
The Data Warehouse Lifecycle Toolkit
Impossible Data Warehouse Situations: Solutions from the Experts
Data Warehouse Project Management
Data Warehouse Management Handbook
Strategic Data Warehousing: Achieving Alignment with Business

Data warehousing and business intelligence books for competitive intelligence

Filtering the Web to Feed Data Warehouses
Progressive Methods in Data Warehousing and Business Intelligence: Concepts and Competitive Analytics

Data warehousing and business intelligence books for business analysis

Strategic Data Warehousing: Achieving Alignment with Business

Data warehousing and business intelligence books for ETL and data integration

The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data
Data Warehouse: Extract, Transform, Load, Metadata, Data Integration, Data Mining, Data Warehouse Appliance, Database Management System, Decision Support System

Data warehousing and business intelligence books for metadata

Data Warehouse: Extract, Transform, Load, Metadata, Data Integration, Data Mining, Data Warehouse Appliance, Database Management System, Decision Support System

Data warehousing and business intelligence books for Oracle

OBIEE Dashboard & Report Best Practices
Oracle Data Warehousing and Business Intelligence Solutions: With Business Intelligence Solutions
Oracle DBA Guide to Data Warehousing and Star Schemas
Oracle Data Warehouse Tuning for 10g by Gavin JT Powell
Oracle 10g Data Warehousing by Lilian Hobbs PhD, Susan Hillson MS in CIS Boston University
Oracle9iR2 Data Warehousing by Lilian Hobbs , Susan Hillson MS in CIS Boston University, and
The Multidimensional Data Modeling Toolkit: Making Your Business Intelligence Applications Smart with Oracle OLAP
Oracle Essbase & Oracle OLAP: The Guide to Oracle’s Multidimensional Solution
Oracle8i Data Warehousing by Lilian Hobbs PhD and Susan Hillson MS in CIS Boston University
Oracle8i Data Warehousing
Essential Oracle8i Data Warehousing: Designing, Building, and Managing Oracle Data Warehouses
High Performance Oracle Data Warehousing: All You Need to Master Professional Database Development Using Oracle

Data warehousing and business intelligence books for Teradata

Tera-Tom on Teradata E-Business

Data warehousing and business intelligence books for Netezza

Netezza Underground: The unauthorized tales of derring-do and adventures in resilient data warehousing solutions

Data warehousing and business intelligence books for Informix

Data Warehousing with Informix: Best Practices

Data warehousing and business intelligence books for performance tuning

Data Warehouse Performance
Oracle Data Warehouse Tuning for 10g
Index Structures for Data Warehouses: v. 1859 (Lecture Notes in Computer Science)

Data warehousing and business intelligence books for OLAP

Data Warehouses and OLAP: Concepts, Architectures and Solutions
OLAP Solutions: Building Multidimensional Information Systems
The Multidimensional Data Modeling Toolkit: Making Your Business Intelligence Applications Smart with Oracle OLAP
Oracle Essbase & Oracle OLAP: The Guide to Oracle’s Multidimensional Solution
Microsoft SQL Server 2005 Analysis Services

Data warehousing and business intelligence books for CRM

Using data warehousing to deliver integrated management information:
Building the Customer-Centric Enterprise: Data Warehousing Techniques for Supporting Customer Relationship Manageme

Data warehousing and business intelligence books for clinical data

Clinical Data Mining and Warehousing, An Issue of Clinics in Laboratory Medicine (The Clinics: Internal Medicine)

Data warehousing and business intelligence books for sales and marketing

Using data warehousing to deliver integrated management information:

Data warehousing and business intelligence books for data quality

Improving Data Warehouse and Business Information Quality : Methods for Reducing Costs and Increasing Profits

Data warehousing and business intelligence books for e-commerce

Data Warehousing And Business Intelligence For e-Commerce
Data Warehousing for E-Business

Data warehousing and business intelligence books for ERP

ERP and Data Warehousing in Organizations: Issues and Challenges

Data warehousing and business intelligence books that have not been released yet

Rapid Data Warehouse Design: User-Focused Techniques for Designing Dimensional Data Warehouses

Data warehousing and business intelligence books for project managers and business analysts

Today we will have a look at data warehousing and business intelligence books for project management and business analysis.

The Profit Impact of Business Intelligence

By far the best book written on the subject and a must read for anyone embarking on a BI mission. Read a comprehensive review on the book.

Agile Data Warehousing: Delivering World-Class Business Intelligence Systems Using Scrum and XP

For agile DW methodologies have a look at Agile Data Warehousing: Delivering World-Class Business Intelligence Systems Using Scrum and XP. Most if not all data warehouse practitioners agree that traditional waterfall methodologies are not very well suited to managing a DW/BI project. This book looks at how agile methodologies and scrum can be leveraged to successfully implement a data warehouse project. This book offers a detailed step by step guide at a bargain price. While you won’t take everything on board covered in this book there are some very practical pieces of advice.

Successful Business Intelligence: Secrets to Making BI a Killer App

If you are new to business intelligence then Cindi Howson’s book is for you. It covers all the relevant DW/BI aspects in an easy to read manner. Topics include: BI architectures, how to measure success, agile development, Business Intelligence Competency Center (BICC), choosing a BI tool etc. This book is mainly written for business users and is relatively light on the technical side of things.

A Manager’s Guide to Data Warehousing

Laura Reeves’ book Data Warehouse for Project Managers is a fairly recent addition to the growing number of DW/BI books on project management. It is a very easy read particularly aimed at those of you who are tasked with setting up a data warehouse. A lot of the stuff in the book only scratches at the surface, however. What makes this book quite valuable is that it covers all aspects of the DW life cycle such as ETL, dimensional modelling, business requirements, data governance etc. from a business angle. However, a lot of areas in the book just rehash Kimball’s lifecycle book. Still a valuable book aimed at DW beginners. It can be easily read over a weekend (should you wish to do so).

Strategic Data Warehousing: Achieving Alignment with Business

In my opinion this book is just a rehash of what other books have covered better and in more detail. If you want to really know about achieving alignment between the data warehouse and business strategy I recommend The Profit Impact of Business Intelligence, which is truly the best book on the subject. The only two interesting chapters of the book cover two case studies on data warehousing. The first one is on Nielsen Media Research and the other one covers the data warehouse implementation at Raymond James Financial.

Kimball Data Warehouse Lifecycle Toolkit

This is one of the classics of course. As the title suggests it covers the full lifecycle of the data warehouse. In comparison to other books that cover the same stuff Kimball’s book is written from a more technical angle and also covers a crash course for business folks on dimensional modelling and ETL workflows. Apart from this the book covers the usual stuff on business requirements, BI tool selection etc. If you are following the Kimball methodology in your data warehouse implementation then this is a must have book.

Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications

This is one of the first books on project managing a data warehouse/business intelligence program. It describes the various stages of a DW/BI project such as justification, planning, business analysis, design, construction, and deployment. It covers the full data warehouse lifecycle. Very much focused on aspects of project management.

Other books

Data Warehouse Project Management

Impossible Data Warehouse Solutions

What I am really missing in the DW/BI literature is a book on usability aspects in the realm of Business Intelligence. This should include report and dashboard design, templates for a solid security architecture, best practices around version control and deployment, query and data governance etc.

Oracle Data Warehousing Books

Must have

In my opinion there aren’t really any brilliant Oracle data warehousing books out there. So what I recommend first of all is to read the Oracle Database Data Warehousing Guide.

I also recommend all of Tom Kyte’s books. Even though they are not specific to Oracle data warehousing they are a must read for anyone working on the Oracle RDBMS. What I love about all of Tom’s books and articles is the scientific no nonsense approach.

For similar reasons I recommend to get your hands on anything by Cary Millsap. I really recommend Optimizing Oracle Performance if you want to understand extended trace in Oracle. It’s a bit older but brilliant. And you can get your hands on a used copy for a couple of quid.

Two other books I have come across recently and found to be quite useful are (1) Troubleshooting Oracle Performance by Christian Antognini from Swiss consulting firm Trivadis. While this does not offer many new insights into the subject it is a valuable overview and reference book. (2) Oracle Performance Survival Guide: A Systematic Approach to Database Optimization. The chapters I found particularly useful here are on minimizing contention, optimizing memory, and optimizing IO. The last one has very useful information on SSDs (in my opinion one of the emerging trends in Data Warehousing for the next decade) and Exadata.

Should Have

If you are implementing a data warehouse in Oracle Oracle 10g Data Warehousing will give you a good technical overview. It touches on all the relevant areas you need to take into consideration when building your data warehouse on Oracle. It will also serve you well as a refresher or lookup for individual areas.

However, don’t expect too much detail. You will need to consult other books, the Oracle documentation, and the blogosphere for advanced topics and more detail.

As a technical introduction and reference to Oracle data warehousing this book has done me a good service over the years.

The Oracle DBA Guide to Data Warehousing and Star Schemas is a bit older, but contains some useful formulas for hardware sizing of an Oracle data warehouse. Does what it says on the tin, but fairly limited in scope.
           
         
           
         
           
         

Oracle Warehouse Builder 11g: Getting Started does pretty much what it says on the tin and gives a good introduction to novices in the area of data warehousing and Oracle Warehouse Builder. So if you have never used Oracle Warehouse Builder this book is for you. If you have used OWB before you will not learn anything new here. Also this book can only be a starting point for your OWB career. A lot more OWB features than are outlined in this book need to be learned to become a master in the area (if you think about it the OWB user manual in PDF format has about 1000 pages and in some areas only scratches at the surface). Also the timing of the publication of the book is a bit unfortunate as only recently OWB 11GR2 was released with a lot of important new features and a redesigned User Interface. Hopefully there will be a 2nd edition soon that addresses this shortcoming. Mark Rittman has also a review of this book on his blog.

Oracle BI Enterprise Edition Dashboard & Report Best Practices is the only book currently out there on OBIEE. Mainly around dashboard design. I haven’t read this myself so if anyone of my readers has I would be grateful for a comment.
           
         
           
         
           
         

I am not too familiar with Essbase myself and have not read the following two books. But from what I hear and looking at the credentials of the authors, both books should be a good read. The first one is Oracle OLAP and Essbase and has only been published recently. The other one is The Multidimensional Modelling Toolkit. Mark Rittman has a review of this on his blog.

Could Have

I had a very disjointed reading experience with Oracle Data Warehousing and Business Intelligence Solutions. There isn’t really a central a central theme in this book. This book is a patchwork of data warehouse related stuff at a very high level. Oracle Data Warehouse Tuning for 10g really is a rehash of the Oracle Performance Tuning for 10g by the same author. The book covers mostly very basic stuff here. I found that everything you find here is better explained in the documentation.

Data Warehousing Books: Design and Architecture

Must Have

DW 2.0: The Architecture for the Next Generation of Data Warehousing: Bill Inmon revisits his data warehouse architecture. Addresses the following issues: Real-time BI, unstructured data, the enterprise data warehouse and change, the data life cycle, time variance of data. Very useful from a conceptual point of view, but not enough detail.

The Data Warehouse Toolkit- The Complete Guide to Dimensional Modelling. My first book on data warehousing. Still valuable today. Great for dimensional modelling data marts or small non-realtime Enterprise Data Warehouses based on Kimball’s conformed dimensions. It also has a good overview on industry specific data model patterns in a dimensional context. A must have.

The Data Model Resource Books Vol 1-3: The books describe fundamental data modeling patterns that can be applied and reused across the enterprise. If you are assigned the task of modelling an Enterprise Data Warehouse, these books give you great insight into best practices in data modelling. Volume 2 offers industry specific data model patterns and provides invaluable information to better understand the issues at hand in a particular industry. Personally I find it that you should actually start with volume 3 as this is the most generic of the three books. Also if you only get one of the books get volume 3.

If you have a requirement around near-real time data warehousing and operational business intelligence I recommend to look into Dan Linstedt’s data vault modelling techniques. The Business of Data Vault Modeling will get you started.

Some more recent additions to the data warehouse architecture league of books includes Building and Maintaining a Data Warehouse and Advanced Data Warehouse Design. The first of these walks us through all the technical areas of a data warehouse project: source system analysis, database design, bi reporting, data quality, metadata. In my opinion, the best chapter is on data integration and ETL. There are very few dedicated ETL books out there and this is one of the few that touches on the subject, albeit from a high level. In Advanced Data Warehouse Design the authors discuss the shortcomings of existing data warehouse implementations focusing mainly on spatial and temporal data, e.g. the shortcomings of slowly changing dimensions when capturing changes over time. They propose a truly temporal and spatial data warehouse. Examples are given in MS SQL Analysis Service (temporal) and Oracle OLAP (temporal and spatial).

To my knowledge the only book out there dedicated to the physical design of databases is Physical Database Design: the database professional’s guide to exploiting indexes, views, storage, and more. Most of the stuff covered here is for advanced users. It covers Oracle, DB2, SQL Server, and for some of the MPP stuff Teradata. Personally I found the chapter on physical design for a shared nothing architecture, and the chapter on hardware (CPU architecture, disks, server sizing etc.) the most useful.

Should Have

If you have a lot of aggregate tables in your warehouse I recommend to have a look at Mastering Data Warehouse Aggregates for a formalised methodology and some really useful tips and tricks around an aggregate navigator.

Another recent addition to data warehouse design books is Data Warehouse Design: Modern Principles and Methodologies. Very useful chapter on ETL and quite affordable.

Could Have

Data Warehouse Design Solutions. This is useful as a second reference for industry specific dimensional models. However, it can not replace Kimball’s original book on the subject.

Clickstream Data Warehousing. If you are implementing a data warehouse for web analytics you should have a look here. However, in light of the explosion of data volumes and with Hadoop and MapReduce at hand this one is slightly obsolete.