Updated: September 29, 2025 (July 31, 2024)
RoadmapSQL Server Analysis Services Roadmap
Update Oct. 2025 – You’ll have to wait for SQL Server 2025, but expect some performance and developer updates that help developer maintaining and running older DAX queries and multidimensional models.
SQL Server Analysis Services (SSAS) is a role in SQL Server, Microsoft’s long-standing on-premises database management and business intelligence (BI) software. SSAS is an analytic processing component used to build complex data models used in data mining and other data analytic applications to guide business decisions. Analysis Services has two modes for organizing data into models:
- Tabular mode organizes data into tables, columns, and metrics, and the technology is used in Excel, Power BI, and Azure Analysis Services
- Multidimensional (MDX) mode is an older technology that organizes data into models called cubes.
SSAS is available in SQL Server, as a deployment option in Azure Analysis Services and in Power BI. The cloud services include most SSAS features but with lower model sizes and are limited to Tabular data models only.
Atlas Members have full access
Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.
Membership OptionsAlready have an account? Login Now