Post reply

Analysis Services Text Books/Resources

  • December 15, 2006 at 2:44 am

    #170774

    As a complete beginner with AS I'm looking for a couple of books which will get me up and running with Analysis Services for SQL Server 2005 and give me a good introduction to the basic cincepts, can anyone recommend any particular books I should consider?

    many thanks

    Laurence

  • December 18, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • December 18, 2006 at 8:22 am

    #678679

    Microsoft® SQL Server™ 2005 Analysis Services Step by Step

    This book is for beginners if you like the walk through tutorial approach. It is a good way of getting an overview of the functionality but isn't a great reference book.

    http://www.microsoft.com/MSPress/books/8592.aspx

    Regards

    Daniel

  • December 18, 2006 at 9:04 am

    #678699

    Thanks Daniel, thats sounds like it what I need to get started, but then I probably need a more in-depth reference as well. I've heard good things about Teo Lachev's 'Applied Microsoft Analysis Services 2005', don't know if anyone out there has any comments..?

  • December 20, 2006 at 7:36 am

    #679117

    Yep, it's a good book.  There's a few grammatical errors in there but the gist is what counts.  If/when you need to look at many-to-many dimensons there's a good paper on this by Marco Russo (here).

     

    Steve.

  • May 9, 2007 at 4:09 pm

    #705409

    I've been reading Brian Larson's "Delivering Business Intelligence ..." (link) and it's pretty good so far (on ch.13 currently) but I would have to say the chapter on SSIS could be shortened or replaced with something more specific and useful. The chapter on SSIS lists every control flow and data flow task along with descriptions. This is good for reference but I think could be shortened to the more common tasks used.

    Have you started reading the 'Analysis Step by Step' book yet? The "Delivering BI" book doesn't go into great detail about it and it is by far my weakest category so I would like to get something more thorough...

    Cheers,

    Ben

    Cheers,

    Ben Sullins
    bensullins.com
    Beer is my primary key...

  • May 10, 2007 at 7:45 am

    #705491

    I would recommend Applied Microsoft Analysis Services 2005 and Microsoft Business Intelligence Platform, ISBN 0-9766353-0-5 and The Microsoft Data Warehouse Toolkit, ISBN 0-471-26715-5

    I would say the first one is more "how to" and the second is a design manual. But I have found them to complement each other and both are (IMHO) very good books. I think the chapter on Designing the Business Process Business Model in the Toolkit is worth the price of the book.

     

     

     

     

     

  • May 15, 2007 at 12:28 am

    #706403

    this whitepaper has lots of good information about adminstering AS 2005:

    http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc

    ---------------------------------------
    elsasoft.org

Viewing 8 posts - 1 through 7 (of 7 total)

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