-
white paperSSAS Tabular as Analytical Engine
This article describes pros and cons of using SQL Server Analysis Services Tabular as the analytical engine in a service or application, based on the experience of companies who have adopted it. Read more
-
This article is the state-of-the-art guide of the development tools for Power BI and Analysis Services models, providing guidance to improve productivity and access to new features. Read more
-
Professional BI developers using Analysis Services and advanced users working with Power BI share a common pain. Their productivity editing a large data model is much lower than what you might expect in 2017. There are many reasons for that.… Read more
-
Choosing the right hardware is critical for a solution based on Analysis Services Tabular. Spending more does not always mean having a better machine. This short article describes how to choose the right server and, as you will see, the… Read more
-
This article describes the types of relationships available in Power BI and Analysis Services, clarifying the differences in cardinality and filter propagation of physical relationships. Read more
-
I recently delivered the online session Create your first SSAS Tabular Model at 24HOP Pass Summit, which recording is now available here. I received many questions and did not have enough time, so I answer now in this blog post.… Read more
-
This article describes how to implement incremental updates to an Analysis Services database in Tabular mode with compatibility version 1200 or higher. Read more
-
Translations are a new feature in Analysis Services Tabular 2016. This article explains how to use this feature and introduce SSAS Tabular Translator, a free tool to edit translations files. Read more
-
This article describes how to add a measure to a Tabular model already deployed on Analysis Services by using C# or PowerShell. This can be useful to deploy user-defined metrics without deploying the entire database. Read more
-
This article describes how to create Key Performance Indicators (KPI) in a Power BI Desktop data model by using Tabular Editor. Read more