Data Warehousing and Business Intelligence

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 DewsonSakhr YounessDenny LeeSam Fergusonet alChris GravesMark ScottMike BenkovichPaul TurleyRobert 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.

4 Comments »

  1. I think it would be great to have a list of powerpivot books also

    Comment by Jason Thomas — 1 December 2010 @ 2:58 pm | Reply

  2. According to me if you want abstract info on MS BI please refer vishalpawar.net

    Comment by rex — 22 December 2010 @ 2:45 pm | Reply

  3. even i am agree with rex

    Comment by Mosina — 22 December 2010 @ 2:46 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: