Microsoft BI Books

Analysis Services (SSAS) Books, including Data Mining, MDX & OLAP

1. Expert Cube Development with Microsoft SQL Server 2008 Analysis Services by Chris Webb, Marco Russo, and Alberto Ferrari
2. Microsoft SQL Server 2008 Analysis Services Unleashed by Irina Gorbach, Alexander Berger, and Edward Melomed. 2005 version here.
3. Applied Microsoft Analysis Services 2005 & Microsoft Business Intelligence Platform by Teo Lachev
4. Professional Microsoft SQL Server Analysis Services 2008 with MDX (Wrox Programmer to Programmer) by Sivakumar Harinath, Robert Zare, Sethu Meenakshisundaram, and Matt Carroll
5. Microsoft SQL Server 2008 Analysis Services Step by Step, Book/CD Package by Hitachi Consulting Scott Cameron
6. Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer) by Sivakumar Harinath and Stephen R. Quinn
7. SQL Server 2005 Analysis Services Step by Step Book/CD Package (Step by Step (Microsoft)) by Reed Jacobson; Stacia Misner; Hitachi Consulting
8. Pro SQL Server 2008 Analysis Services by Philo Janus
9. Microsoft SQL Server 2008 Analysis Services Business Intelligence Skills for Mcts 70-448 and Mcitp 70-452 Video Mentor by Wendy Henry
10. Professional SQL Server 2000 Data Warehousing with Analysis Services by Robin Dewson, Sakhr Youness, Denny Lee, Sam Ferguson, et al, Chris Graves, Mark Scott, Mike Benkovich, Paul Turley, Robert Skoglund
11. OLAP Solutions: Building Multidimensional Information Systems by Erik Thomsen
12. MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase by George Spofford, Sivakumar Harinath, Christopher Webb, and Dylan Hai Huang. 2000 version here.
13. Fast Track to MDX: For SQL Server 2000 by Mark Whitehorn, Robert Zare, and Mosha Pasumansky. First version here.
14. Practical MDX Queries by Art Tennick
15. MDX Reporting and Analytics with SAP NetWeaver BW: An Up-to-Date Guide for Business Intelligence Reporting and Analytics with SAP by Larry Sackett
16. Data Mining with Microsoft SQL Server 2008 by Jamie MacLennan

Integration Services (SSIS) Books including ETL

1. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition by Ashwani Nanda. 2005 version here.
2. Professional Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer) by Brian Knight, Erik Veerman, Grant Dickinson, and Douglas Hinson. 2005 version here.
3. Microsoft SQL Server 2005 Integration Services Step-by-Step by Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, Pablo Guzman of Hitachi Consulting
4. Knight’s 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer) by Brian Knight, Devin Knight, and Mike Davis
5. Microsoft SQL Server 2008 Integration Services Unleashed by Kirk Haselden. 2005 version here.
6. Microsoft SQL Server 2008 Integration Services Problem-design-solution (Wrox Programmer to Programmer) by Erik Veerman, Jessica M. Moss, Brian Knight, and Jay Hackney
7. Pro SQL Server 2008 Integration Services by James Wightman. 2005 version here.
8. Microsoft SQL Server 2008 Integration Services Business Intelligence Skills for MCTS 70-448 and MCITP 70-452 Video Mentor by Wendy Henry
9. Expert SQL Server 2005 Integration Services (Programmer to Programmer) by Brian Knight and Erik Veerman
10. Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy
11. The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming, and Delivering Data by Ralph Kimball and Joe Caserta

Reporting Services (SSRS) Books

1. SQL Server 2005 Reporting Services Step by Step Book/CD Package (Step by Step (Microsoft)) by Stacia Misner; Hitachi Consulting
2. Applied Microsoft SQL Server 2008 Reporting Services by Teo Lachev
3. Pro SQL Server 2008 Reporting Services by R; McGehee, S; Voytek III, W Landrum
4. Microsoft SQL Server 2008 Reporting Services Unleashed by Michael Lisin, Jim Joseph, and Amit Goyal
5. Hitchhiker’s Guide to SQL Server 2000 Reporting Services (Microsoft Windows Server System) by with Peter Blackburn and William R. Vaughn
6. Professional Microsoft Sharepoint 2007 Reporting with SQL Server 2008 Reporting Services (Wrox Programmer to Programmer) by Coskun Cavusoglu, Jacob J. Sanford, and Reza Alirezaei
7. Learning SQL Server 2008 Reporting Services by Jayaram Krishnaswamy
8. Professional Microsoft SQL Server 2008 Reporting Services (Wrox Programmer to Programmer) by Paul Turley, Thiago Silva, Bryan C. Smith, and Ken Withee
9. Microsoft SQL Server 2008 Reporting Services by Brian Larson
10. Pro SQL Server 2005 Reporting Services by Rodney; Voytek II, Walter J. Landrum
11. Microsoft SQL Server 2008 Reporting Services Step by Step, Book/CD Package by Stacia Misner
12. Microsoft SQL Server 2005 Reporting Services for Dummies by Mark Robinson

Microsoft BI Books (mix of SSIS, SSAS, SSRS)

1. Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset by Joy Mundy, Warren Thornthwaite, and Ralph Kimball
2. Business Intelligence und Reporting mit SQL Server 2008: OLAP, Data Mining, Analysis Services, Reporting Services und Integration Services mit SQL Server 2008 by Pedro Azevedo, Gerhard Brosius, Stefan Dehnert, and Berthold Neumann
3. Smart Business Intelligence Solutions with Microsoft SQL Server 2008 (PRO-Developer) by Kevin S. Goff, Davide Mauri, Sahil Malik, and John Welch Lynn Langit

————————————————————-

If you think a book should be here, or if you want other information to be included, please let me know (vrainardi@gmail.com or via comments). MS BI is inter-related. When composing a BI solution we often use more than 1 product. In Analysis Services world for example, SSIS is used for cube processing, for processing only the changed partitions. SSRS is used for reporting OLAP query log, and for reporting from cubes. No surprises here as SSIS, SSAS, and SSRS they all come with SQL Server. “As we already got it, we may as well use it”, that’s what I often heard in the field. Hence I put SSAS, SSIS, SSRS in 1 page. In the list above, where there are 2 or more versions I only include the latest, with link to the older version. Talking to friends & colleagues about Microsoft BI books (I’ll put a separate list for DW books), here’s what I heard: Some people say that they don’t want to see a long list of books, just a short list of good ones. They also said they don’t want to see out of date ones. They want to see comments, opinions, rating/recommendation. They value this subjective info more than the factual info because facts that they can get themselves from Amazon. They also want to see other country links, particularly US (Amazon.com, BN) and Asia. So I’ll try to do all that, over time. Oohh work, work, work (particularly that review/opinion things — that’s a lot of work).  Oh 1 more thing (thanks to Vishal Kachiwala): MS BI is not just SSIS, SSRS, SSAS. What about Sharepoint, Performance Point and Excel? Hmm OK, I agree.