SQL Server Analysis Services (SSAS)

SQL Server Analysis Services contains engines for multidimensional (OLAP) and tabular analytical models, and for data mining.

Reference materials:

  1. MSDN. Introducing the BI Semantic Model in Microsoft® SQL Server® 2012
  2. MSDN. Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services
  3. MSDN. Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014
  4. MSDN. Securing the Tabular BI Semantic Model
  5. MSDN. Using DirectQuery in the Tabular BI Semantic Model

Reference materials on multidimensional modeling (OLAP):

Reference materials on tabular modeling:





%d bloggers like this: