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

SQL Server Analysis Services

Producto

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

◆ PRODUCTOSQL Server AnalysisServicesM365.FM
Gráfico de título: SQL Server Analysis Services (Producto)

Descripción

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.

TipoProducto
También conocido comoSSAS, Analysis Services
Sitio weblearn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions
Documentaciónlearn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions

Artículos sobre 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
Mapa de relaciones de SQL Server Analysis Services: temas enlazados

Developed by

Is a

Related to

Glosario

Community wiki

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

Expertos y empresas para este tema

Nadie ha indicado aún este tema. Añádelo a tu perfil.

Fuentes

Mantenido por Mirko Peters (Microsoft MVP) · Última actualización: