• stephen.salowitz (7/9/2014)


    Do you know of any great (online preferably) resources that I can use to learn more about SSAS?

    Two key books:

    I don't know what version you are considering but the Ultimate Guide to Microsoft BI IMHO is The Microsoft Data Warehouse Toolkit: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset. Though it's not specifically about SSAS it puts the who BI stack in Context. Anyone doing BI should study that book to death.

    For SSAS specifically: I recommend Microsoft® SQL Server® 2008 Analysis Services Step by Step It's the best book for SSAS newcomers that I have read. Great tutorials.

    Web Sites:

    I wish SSC had a stairway to SSAS. The next best thing would be Bill Pearson's Stairway to MDX[/url]. Though it's about MDX there's plenty to learn about SSAS in there.

    Microsoft Technet / BOL is a solid free resource. Check out: http://technet.microsoft.com/en-us/library/bb500153(v=sql.110).aspx

    Other Resources:

    SQL PASS, SQL in the City, SQL Saturday and my SQL BI User group have been indispensable.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001