M365Con 2027 – conférence en ligne gratuite · 11–22 Jan 2027 · 120 sessions→ m365con.net

SQL Server Analysis Services

Produit

An analytical data engine that hosts semantic models for reports and analysis. It supports tabular and multidimensional models and data mining.

◆ PRODUITSQL Server AnalysisServicesM365.FM
Title graphic: SQL Server Analysis Services (Produit)

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.

TypeProduit
Aussi appeléSSAS, Analysis Services
Site weblearn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions
Documentationlearn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions

Articles sur SQL Server Analysis Services (3)

SQL ServerAnalysis ServicesMicrosoftDeveloped byAnalytics and BI to…Is aMicrosoft toolIs aMicrosoft SQL ServerRelated toPower BIRelated toSQL Server Reportin…Related toMicrosoft FabricRelated toSQL Server Integrat…Related to
Carte des relations de SQL Server Analysis Services : sujets liés

Developed by

Is a

Related to

Glossaire

Community wiki

Short info above, community knowledge below: add practical tips, examples or corrections. New contributions are reviewed first; trusted members publish directly.

Experts et entreprises pour ce sujet

Personne n'a encore indiqué ce sujet. Ajoutez-le à votre profil.

Sources

Maintenu par Mirko Peters (Microsoft MVP) · Dernière mise à jour: