Microsoft SQL Server is the central building block of a Microsoft-centric analytical platform, which is built on relational database technology at its core.
In addition to special functions for analytical data processing within the RDBMS, these are:
- SQL Server Integration Services (SSIS): data integration solution specifically tailored for use with SQL Server.
- SQL Server Analysis Services (SSAS):
- Supports the so-called "Tabular" and "Multidimensional" mode, i.e. modeling analytical data relationally/in tables or multidimensionally/in cubes
- SQL Server Reporting Services (SSRS): the predecessor to PowerBI