Microsoft Business Intelligence stack from 100 to . . . Wow

Somebody told me that the experts master the basics and know where to throw the net in the BI sea😉

Are you a motivated & self-started looking for a list of material to start with and became a Microsoft BI Developer with a good understanding of the theory and the tools? So this post is for you.

I’ve put together a ‘reasoned’ list of books/ training material with details of each content…

I hope you can buy at least 1/3 of this material to finance that wrote and invested time on that as this can be found on the web easily…

Intro

The basics are here the 1 and 2 give you foundations on BI end to end, the 3 is a cbt video that you can use to review what in the previous 2 and the 4 is more SP oriented.    


Just start here and spend 25% of your time if you are new to BI stack

DW


The Kimball methodology is the bible you should follow in your day practice, the 2 is about the DW schema star definition, is can be skipped if you have in a hurry

SSIS


The 24H training is enough detailed to be proactive; I suggest focusing then on the task you might need for your projects and refer to MSDN

SSAS


The 1 is a very detailed video about SSAS and OLAP methodology, the 2 and 3 are more about advanced usage

SSRS


If you want to present your data with SSRS this section give you the details how to build the reports and how to administer SSRS

SP and BI clients


The last section is a composed of an Excel pivot table course and the SP and Excel value and importance in a BI project (suggested).

Some useful free material can be found here … http://underthefold.org/2011/06/13/exam-70-448-study-guide-part-1/

Project tracking and knowledge structuring

At the moment I am using Mind Manager to track progress and structure the huge amount of knowledge …

I created a mind map here, so you can track your progress and add what you learn and export of the map in doc format here (even I suggest using the first one and installing mind manager)  


Please like this article if you found it useful, Mario

Update

As I am expanding the map content day by day I am copying my versions on dropbox… last update

]http://dl.dropbox.com/u/63221860/BI.Blog/BI.G/BI.G%40120518_1436.rar

Please, click here if you don’t have a have a dropbox account, I would appreciate…

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