SQL Server Analysis Services (SSAS) is Microsoft's online analytical processing (OLAP) solution, and it is a SQL Server tool. OLAP solutions are central to business intelligence: using data about business operations to understand the business and make decisions that will drive future success in business. SSAS allows users to bring together data from multiple relational databases into a central location and then presents that data in a fashion that makes it easy for the users to query the data, view the data at various levels of detail, and perform advanced calculations against the data, all with the objective of deriving useful information from the millions or billions of transactions that occur in a business on a daily basis. SSAS accomplishes this by structuring and presenting data using the Unified Dimensional Model (UDM).
In addition to its OLAP functionality, Analysis Services provides a rich set of data mining features that allow users to build advanced statistical models of their data and use those models to categorize data and make predictions based on that data.
Please feel welcome to add links to the following sections, create new articles, or or recommend articles that can be referenced from this Wiki. Articles included here should touch on at least one of these subjects: queries using MDX, DMX and XMLA; multidimensional modeling and tabular modeling, using either UDM and BISM; effective design of dimensions, measures and other parts of a cube; troubleshooting, performance tuning, and monitoring of solutions built using MOLAP/HOLAP/ROLAP; business cases and real-life scenarios for SSAS solutions using both cube and tabular models; use of AMO and interfaces such as OLEDB to programmatically work with multidimensional or data mining objects; data mining using SQL Server Analysis Services.
Unified Dimensional Model
This article is also available in the following languages: