SQL Server Analysis Services (a.k.a. SSAS) is part of SQL Server. It enables lightning-fast access to large amounts of data. Both in multidimensional mode (classic OLAP cubes) and in tabular mode (in memory analytics engine), it is possible to quickly browse through data. In Analysis Services, Data Tools are used to create reporting models that can be used with Microsoft’s own BI tools (such as Power BI or Report Builder), as well as many BI tools from other suppliers.
- Real-time or in memory
- Accessible to third party query tools
- Part of SQL Server