Microsoft Analysis Services

<p>Microsoft SQL Server Analysis Services (SSAS) is an <a href="/facts/Online_analytical_processing/VNNbIlD0">online analytical processing</a> (OLAP) and <a href="/facts/Data_mining/AH53q5ac">data mining</a> tool in <a href="/facts/Microsoft_SQL_Server/eCdt2JBL">Microsoft SQL Server</a>. 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. <a href="/facts/Microsoft/nGIDDXdx">Microsoft</a> has included a number of services in SQL Server related to <a href="/facts/Business_intelligence/ftThn7Wf">business intelligence</a> and <a href="/facts/Data_warehousing/we5rblq9">data warehousing</a>. These services include Integration Services, Reporting Services and Analysis Services. Analysis Services includes a group of OLAP and <a href="/facts/Data_mining/AH53q5ac">data mining</a> capabilities and comes in two flavors multidimensional and tabular, where the difference between the two is how the data is presented. 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.
</p>

Microsoft Analysis Services open-in-new

Microsoft Analysis Services