What is SSAS? List out its key features

Programming Language
1

SSAS maintains multidimensional cubes of data and offers access to heaps of information, including data aggregation, as a middle-tier server for analytical processing, OLAP, and data mining. Analysis services give a unified view of data for OLAP or data mining applications.

The following are some of the key aspects of SSAS:

  • Ease of use with a lot of wizards and designers
  • Flexible data model creation and management
  • Scalable architecture to handle OLAP
  • Integration of administration tools, data sources, security, caching, reporting, etc.
  • Extensive support for custom applications
2

SQL Server Analysis Services(SSAS) is a tool for performing higher speed analyses of data than standard 3NF relational systems. Originally it was an OLAP solution based on multi-dimensional structures (cubes) that are simply one possible physical implementation of the star schema logical design. With the advent of the Tabular model, SSAS is trying to provide high performance analyses without the complexity of a cube and it’s accompanying language MDX.