I tend to get some variation of the following question as I present at SQL Saturdays and work with clients:
What is the one book I should read to gain a good understanding of this topic?
There are many great books out there on business intelligence, data warehousing, and the Microsoft BI stack. Here is my list of those that had a significant impact on my learning and career or that I consider the current defining book on the subject.
Data Warehousing/Dimensional Modeling – The Data Warehouse Toolkit by Ralph Kimball and Margy Ross (link is to the newest edition of the book) defines dimensional modeling, walks through many common data scenarios and explains recommended data modeling and ETL practices. If you are designing, building, or enhancing a dimensional data warehouse, please read this book.
Master Data Management – Master Data Management by David Loshin thoroughly explains the resources required, helps clarify goals, and discusses the challenges of implementing a master data management program in your organization. The book also discusses architecture options and provides a roadmap that you can adapt to your project. I actually did an independent study class based upon this book as part of my MBA. I would recommend it to anyone just getting into MDM as a great platform agnostic view of MDM.
Agile Data Warehousing – Agile Data Warehousing Project Management: Business Intelligence Systems Using Scrum by Ralph Hughes is an enlightening read about applying the agile process to data warehousing by someone who understands both. Use this book to help set expectations at the beginning of projects, estimate effort, decide what should be included in an iteration, and provide value early in your project. It addresses DW enhancements as well as new DW projects.
SSIS – Professional Microsoft SQL Server 2012 Integration Services contains great information whether you are just learning SSIS or you just need to understand the new features in 2012. It covers each task and data flow component, offers tips for performance tuning, and provides great examples. If you haven’t moved up to SQL Server 2012 yet, you will want to learn about the project deployment model, environment variables, and project-level connection managers, which are all covered in this book.
SSAS Tabular – Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model by Marco Russo, Alberto Ferrari, and Chris Webb
There aren’t that many books available on SSAS tabular models since it is fairly new. This one got me through a couple of projects as I learned tabular cubes and DAX. You will read almost every page while building your first tabular cube. Then you will return to find helpful tips on writing DAX calculations.
Data Visualization – Information Dashboard Design by Stephen Few (link is to the newest edition of the book)
This book is what got me interested in data visualization. The way I design reports and dashboards changed after I read it. I was torn whether to go with this book or Show Me the Numbers, but I think Information Dashboard Design covers the main points of Show Me the Numbers that I most want people to understand (it was also the first of Few’s books that I read). Today’s technology enables us to make reports that are high on shiny and low on actionable information. I see two troubling trends: reports that are just wide tables with several hundred lines that no one can read at one time, and really shiny dashboards with lots of bells and whistles that make them look really cool. This book will tell you there is an appropriate time and place for tables and dashboards. And while visual appeal is good, it should not be at the expense of effectively communicating the intended message of the information.
I just picked up some books that look very promising and may cause me to update my list above:
- Excel Gurus Gone Wild by Bill Jelen
- The Naked Presenter by Garr Reynolds
- Business Intelligence in Microsoft SharePoint 2013 by Norman P. Warren, Mariano Teixeira Neto, Stacia Misner, Ivan Sanders, Scott A. Helmers
- DAX Formulas for PowerPivot by Rob Collie