Developer(s) | Microsoft |
---|---|
Stable release | Analysis Services 2016
/ December 21, 2010 |
Operating system | Microsoft Windows |
Type | OLAP, Data Mining |
License | Microsoft EULA |
Website | https://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]