Post reply

Starting out in Analysis Services --- Help

  • May 7, 2009 at 7:48 am

    #209192

    Just lost out to an opportunity i was keen on because of lack of skills in Analysis Services - (not that this was made clear it was a key requirement before the interview).

    So.. to prevent the same thing happening again, I'd really like to skill up in AS, quickly.

    Can anybody recommend any resources/strategies/books/tips to get me up to a reasonable level of competency (fairly quickly).

    (I have a solid grounding in T-SQL, SSIS, SSRS on 2000/2005 - 4yrs experience).

    Any and all constructive comments welcomed

  • May 7, 2009 at 10:21 am

    #990489

    You need to get read up on the theory behind data warehousing first before tackling SSAS.

    I recommend Kimball's Data Warehouse Toolkit Classics, then if you want to follow it up with the Microsoft Data Warehouse Toolkit it will give you some good examples to go off of where the theory is applied.

    After that you probably want to get up to speed on MDX. I recommend the books Fast Track to MDX even though it's based on 2000 technology, and though I haven't read it, I've heard that Microsoft SQL Server 2008 MDX Step by Step is a good book too, although unneeded if you already have some MDX under your belt.

    You can then go with whatever SSAS book you want to learn more about the tool itself if you feel like you need to, I haven't read any of these so I'm not comfortable recommending any.

    You should be able to find all of these on Amazon by searching their titles.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply