An analytical data engine that hosts semantic models for reports and analysis. It supports tabular and multidimensional models and data mining.
Title graphic: SQL Server Analysis Services (Product)
Description
SQL Server Analysis Services (SSAS) is an analytical data engine, called VertiPaq, for decision support and business analytics. It provides enterprise-grade semantic data models for reports and client applications. It is installed as a server instance on premises or on a virtual machine. Models can hold query objects, calculations and KPIs that capture business logic.
SSAS supports tabular models, multidimensional models and data mining, and it also supports Power Pivot for SharePoint. The usual workflow is to install an instance, build a model in Visual Studio with the Analysis Services projects extension, deploy it as a database to the server, process it to load data and then assign permissions. Models are mostly fed from data warehouses on SQL Server or Oracle, and tabular models support more source types.
Power BI, Excel and Reporting Services reports can use the deployed models as a data source. Business users and analysts connect through Excel or other tools, BI developers build and deploy models, and data warehouse teams supply the data. The page lists Azure Analysis Services and Fabric or Power BI Premium under Applies to, but the article itself covers SQL Server Analysis Services only.
Data Analysis Expressions, better known as DAX, is the calculation language that powers Microsoft Power BI, Excel Power Pivot, and SQL Server Analysis Services. In this episode of the M365 FM Podcast, Mirko Peters explains DAX in plain English and shows why…
Articles about SQL Server Analysis Services (2)
Demystifying DAX UDFs: VAL vs. EXPR Explained · Mirko Peters Welcome back to the podcast companion blog! In our latest episode, we took a deep dive into the powerful world of DAX User-Defined Functions (UDFs). If you have bee…
DAX, or Data Analysis Expressions, is a formula language for data analysis used in Power BI, Excel Power Pivot and SQL Server Analysis Services to create custom calculations. · From the episode: Data Analysis Expressions (DAX) - Simply…
Relationship map of SQL Server Analysis Services: linked topics
Related topics in brief
Microsoft· Developed by · Organization Microsoft Corporation is a technology company that develops software and cloud services such as Microsoft 365, Azure and Dynamics 365.
Analytics and BI tool· Is a · Category A tool for analysing data and building reports and dashboards.
Microsoft tool· Is a · Category A software product or service developed by Microsoft.
Microsoft SQL Server· Related to · Product Microsoft's relational database management system that uses T-SQL. Its engine also underpins Azure SQL Database and Azure SQL Managed Instance.
Power BI· Related to · Product Microsoft's business intelligence tool for turning data into interactive reports and dashboards. Semantic models define the data and measures, and reports can be shared in the Power BI service or embedded in other apps.
SQL Server Reporting Services (SSRS)· Related to · Product Microsoft's server-based report generation platform for paginated reports defined in RDL, authored for example with Reporting Services projects in Visual Studio.
Microsoft Fabric· Related to · Platform An all-in-one analytics platform that combines data engineering, data warehousing, real-time analytics and Power BI on a shared storage layer called OneLake, billed through shared capacity.
SQL Server Integration Services· Related to · Product Microsoft's platform for data integration and ETL. It moves, cleans and transforms data with packages that run on SQL Server or in Azure.
Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.
Experts and companies for this topic
Nobody has listed this topic yet. Add it to your profile.