M365Con 2027 – conferenza online gratuita · 11–22 Jan 2027 · 120 sessions→ m365con.net

SQL Server Analysis Services

Prodotto

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

◆ PRODOTTOSQL Server AnalysisServicesM365.FM
Title graphic: SQL Server Analysis Services (Prodotto)

Descrizione

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.

TipoProdotto
Noto anche comeSSAS, Analysis Services
Sito weblearn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions
Documentazionelearn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions

Articoli su 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
Relationship map of SQL Server Analysis Services: linked topics

Developed by

Is a

Related to

Glossario

Community wiki

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

Esperti e aziende per questo argomento

Nessuno ha ancora indicato questo argomento. Aggiungilo al tuo profilo.

Fonti

Mantenuto da Mirko Peters (Microsoft MVP) · Ultimo aggiornamento: