Microsoft Analysis Services

Microsoft SQL Server Analysis Services (SSAS)
Developer(s)Microsoft
Stable release
Analysis Services 2016 / December 21, 2010 (2010-12-21)
Operating systemMicrosoft Windows
TypeOLAP, Data Mining
LicenseMicrosoft EULA
Websitehttps://technet.microsoft.com/en-us/sqlserver/cc510300.aspx

Microsoft SQL Server Analysis Services (SSAS[1]) is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services, Reporting Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors multidimensional and tabular, where the difference between the two is how the data is presented.[citation needed] In a tabular model, the information is arranged in two-dimensional tables which can thus be more readable for a human. A multidimensional model can contain information with many degrees of freedom, and must be unfolded to increase readability by a human.[citation needed]

  1. ^ Tableau frequently refers to SSAS Cubes as MSAS Cubes Archived 2016-12-29 at the Wayback Machine