SQL Server Analysis Services (SSAS)

SQL Server Analysis Services (SSAS)


 

Overview

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.


Analysis Services Wiki Articles

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.

Dimensional Modeling 101

Unified Dimensional Model

Security

Performance

Administration and Monitoring

Tools

Query and DDL Languages

Data Mining


See Also

 


Other Languages

This article is also available in the following languages:

Brazilian Portuguese (pt-BR)

German (de-DE)

Leave a Comment
  • Please add 7 and 8 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Richard Mueller edited Revision 31. Comment: Fixed HTML <h> tags so header lines show in TOC

  • Ed Price - MSFT edited Revision 28. Comment: Added tag. Added TOC.

  • Fernando Lugão Veltem edited Revision 26. Comment: added security session

  • Horizon_Net edited Revision 25. Comment: added link to German version

  • Fernando Lugão Veltem edited Revision 24. Comment: added portuguese version  

  • Jeannine Takaki edited Revision 22. Comment: added description of scope for articles (for search); spell check

  • Jeannine Takaki edited Revision 21. Comment: added link to DM stored procedures articles; fixed extra H1

  • Jeannine Takaki edited Revision 12. Comment: Added subheadings and some new links.

  • Ed Price MSFT edited Revision 4. Comment: Added Wiki Articles and See Also sections.

Page 1 of 1 (9 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Ed Price MSFT edited Revision 4. Comment: Added Wiki Articles and See Also sections.

  • Jeannine Takaki edited Revision 12. Comment: Added subheadings and some new links.

  • Jeannine Takaki edited Revision 21. Comment: added link to DM stored procedures articles; fixed extra H1

  • Jeannine Takaki edited Revision 22. Comment: added description of scope for articles (for search); spell check

  • Fernando Lugão Veltem edited Revision 24. Comment: added portuguese version  

  • Horizon_Net edited Revision 25. Comment: added link to German version

  • Fernando Lugão Veltem edited Revision 26. Comment: added security session

  • Ed Price - MSFT edited Revision 28. Comment: Added tag. Added TOC.

  • Richard Mueller edited Revision 31. Comment: Fixed HTML <h> tags so header lines show in TOC

Page 1 of 1 (9 items)