SQL Server Analysis Services (also called SSAS) is part of SQL Server. It makes fast access to large amounts of data possible. Both in multidimensional mode (classic OLAP) and in Tabular mode (in memory analytics engine), it is possible to 'browse' through the data quickly. In Analysis Services are reporting models are created with Data Tools that can be used by Microsoft's own BI tools (e.g. Power BI and Report Builder), but also by many BI tools from other providers.
- Real-time or in memory
- Accessible to querytools of third parties
- Part of SQL Server