Recommended Reading Around Microsoft BI Stack

I am often asked to recommend good books to help with training or as references around different areas of the MS BI stack. This blog is a list of books I have found most useful, I will look to add to this as I find new ones.

  1. Books
    1. Datawarehouse Design – The Data Warehouse Toolkit: Third Edition by Ralph Kimball and Margy Ross – The definitive workbook for all data modelling requirements that should be in every BI professional’s bag or on their Kindle!
    2. SSAS  – Expert Cube Development by Chris Webb, Marco Russo and Alberto Ferrari – Although this book says for SSAS 2008 it is completely relevant to SSAS 2012 and 2014.
    3. SSIS – SSIS 2012 Design Patterns by Matt Masson, Tim Mitchell, Andy Leonard, Jessica Moss, Michelle Ufford – Great book to take you further with SSAS including a good chapter on PDW SSIS techniques and considerations.
    4. SharePoint Business Intelligence – MS SharePoint BI Unleashed by various authors – although this is for SHPNT 2010 it is also very valid for 2013 except the SSRS pieces. Also has a good guide for setting up a base SHPNT environment for BI.
    5. MDX Reference Guide – MDX with SSAS 2012 Cookbook by Sherry Li and Tomislav Piasevoli – Great reference book for all things MDX which is key for any SSAS project.
    6. Power View – Visualising Data with Microsoft Power View – a great overview of Power View along with some very useful videos.
    7. SSAS Tabular – Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model – still one of the only books available on the Tabular model and a very useful book for getting started with Tabular data models.
Advertisements

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