SSAS guide

• roblew 15918

  Ten Centuries

  Points: 1059

  More actions

  August 12, 2014 at 9:21 am

  #297881

  I have no working experience in SSAS and want to start from the beginning really while it is quiet in work.

  Found this - http://www.sqlservercentral.com/articles/server/94235/ and was wondering is this a good place to start or are there any better articles or stair was on here for SSAS using SQL 2012?

  Thanks

• Alan Burstein

  SSC Guru

  Points: 61141

  More actions

  August 12, 2014 at 10:01 am

  #1737283

  SSAS is the Analysis part of the Microsoft BI stack (SSRS, SSIS and SSAS). Pre-2012 the only components were OLAP cubes (Dimensional model) and Data mining. In 2012 they included a "tabular" model which is an alternative to cubes.

  The link you posted is good but, if you are just getting started with SSAS I suggest you skip data mining for now. That is certainly more complex.

  The best book for learning SSAS is the "Step-by-Step" series but I don't think there is an SSAS 2012 step-by-step.

  Do a google search for "ssas step by step" for some good links to start with.

  Also, take a look at this: http://msdn.microsoft.com/en-us/library/jj735264.aspx

  "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

• roblew 15918

  Ten Centuries

  Points: 1059

  More actions

  August 12, 2014 at 10:23 am

  #1737286

  ok, thanks for reply!

• roblew 15918

  Ten Centuries

  Points: 1059

  More actions

  August 13, 2014 at 4:38 am

  #1737502

  found this which seems a good start:

  http://download.microsoft.com/download/0/F/B/0FBFAA46-2BFD-478F-8E56-7BF3C672DF9D/SQL%20Server%202012%20Tutorials%20-%20Analysis%20Services%20Multidimensional%20Modeling.pdf