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.
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.
| Tipo | Producto |
|---|---|
| También conocido como | SSAS, Analysis Services |
| Sitio web | learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions |
| Documentación | learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions |
Artículos sobre SQL Server Analysis Services (3)
- Desmitificando las UDF de DAX: VAL frente a EXPR explicado
· Mirko Peters
¡Bienvenido de nuevo al blog complementario del podcast! En nuestro último episodio profundizamos en el potente mundo de las funciones definidas por el usuario (UDF) de DAX. Si hasTienes que escuchar estoDAX UDF VAL vs EXPR: Prevent Timeouts and Wrong Totals - 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… - Demystifying DAX: A Beginner's Guide to Data Analysis Expressions
· Mirko Peters
Welcome to the ultimate beginner's guide to Data Analysis Expressions, commonly known as DAX. If you have ever stared at a raw dataset in Power BI or Excel and wond…
You should listen to thisData Analysis Expressions (DAX) - Simply Explained
Developed by
- Microsoft · Organización
Is a
- Analytics and BI tool · Categoría
- Microsoft tool · Categoría
Related to
- Microsoft SQL Server · Producto
- Power BI · Producto
- SQL Server Reporting Services (SSRS) · Producto
- Microsoft Fabric · Plataforma
- SQL Server Integration Services · Producto
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
- Sitio web oficial: learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions
- Documentación: learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions
- Feed de este tema (RSS): entity/sql-server-analysis-services/feed.xml
- Artículos sobre este tema: 3
Mantenido por Mirko Peters (Microsoft MVP) · Última actualización: