Microsoft SQL Server Analysis Services, SSAS (and sometimes MSAS), 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.