Microsoft BI Books


  • I've been looking for a book that provides a good overview of all the tools available from Microsoft regarding BI and have found the following. Has anyone read any one (or two) of these books? If you have what is yout thoughts?
    • Smart Business Intelligence Solutions With Microsoft SQL Server 2008
    • The Microsoft Data Warehouse Toolkit: With SQL Server 2005 And The Microsoft Business Intelligence Toolset
    • Microsoft Office 2007 Business Intelligence: Reporting, Analysis, and Measurement from the Desktop
    I think the last one would be good to have as a reference for analytical purposes, but which one would be the recommend one between the first two? Ideally I'm looking for books that would illistrate industry best practices regarding the implementatio nand design of data warehouses (book 1 & 2) and then the tools used to interpret the data.
    Thursday, December 03, 2009 1:13 PM


  • Hi Orion,

    Building the Data Warehouse by Bill Inmon and The Data Warehouse Toolkit by Ralph Kimball. Both books should be present on any BI developer's bookshelf.

    MDX_Solutions_With_MS_SQL_Server_Analysis_Services_2005_And_Hyperion_Essbase_2nd_Edition is also a good book.

    Step by step books of SQL Server is useful too.

    Jin Chen
    Jin Chen - MSFT
    Tuesday, December 08, 2009 9:00 AM
  • Some for BI books for your reference

     "Expert Cube Development with Microsoft SQL Server 2008 Analysis Services"

    If you're still using 2005, this is a great book -
      Microsoft SQL Server 2005 Analysis Services by Melomed, Gorbach, Berger and Bateman. 

    This is a must have book, To advance your knowledge in SSAS, you must master MDX/DMX

    MDX Solutions: With Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase by George Spofford, Sivakumar Harinath, Christopher Webb, and Dylan Hai Huang (Paperback - Mar 6, 2006)

    Data mining:

    Data Mining with Microsoft SQL Server 2008 by Jamie MacLennan, ZhaoHui Tang, and Bogdan Crivat (Paperback - Nov 17, 2008)

    Data Mining with SQL Server 2005 by ZhaoHui Tang and Jamie MacLennan (Paperback - Oct 7, 2005)

      helpful sites:



    Tuesday, December 08, 2009 4:15 PM

All replies