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.
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.
| Type | Produit |
|---|---|
| Aussi appelé | SSAS, Analysis Services |
| Site web | learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions |
| Documentation | learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions |
Articles sur SQL Server Analysis Services (3)
- Démystifier les UDF DAX : VAL ou EXPR expliqués
· Mirko Peters
Bienvenue de nouveau sur le blog compagnon du podcast ! Dans notre dernier épisode, nous avons plongé en profondeur dans l’univers puissant des fonctions définies par l’utilisateurÀ écouter absolumentDAX 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 · Organisation
Is a
- Analytics and BI tool · Catégorie
- Microsoft tool · Catégorie
Related to
- Microsoft SQL Server · Produit
- Power BI · Produit
- SQL Server Reporting Services (SSRS) · Produit
- Microsoft Fabric · Plateforme
- SQL Server Integration Services · Produit
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
- Site officiel: learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions
- Documentation: learn.microsoft.com/en-us/analysis-services/ssas-overview?view=asallproducts-allversions
- Flux de ce sujet (RSS): entity/sql-server-analysis-services/feed.xml
- Articles sur ce sujet: 3
Maintenu par Mirko Peters (Microsoft MVP) · Dernière mise à jour: