SQL Server Analysis Services (SSAS)

SQL Server Analysis Services (SSAS) is a Microsoft SQL Server component providing online analytical processing (OLAP) and data mining capabilities for analyzing large volumes of data across databases, warehouses, and files. It organizes data into multidimensional cubes or tabular models using…

Key facts

First appeared: 1998
Category: technology
Problem solved: Processing and analyzing massive, multidimensional data spread across organizational sources, which predecessors handled only in two-dimensional rows/columns requiring manual SQL parsing, by enabling fast OLAP cube-based slicing, dicing, and drill-down without SQL expertise.[1][2]
Platforms: Windows Server, On-premises SQL Server instances

Related technologies

Power BI
Excel
SQL Server
ETL tools

Notable users

Fortune 500 companies
Microsoft enterprise customers
Financial services firms