Topic: VertiPaq

        Page 2 of 24 posts
article –

Data Model Size with VertiPaq Analyzer

Analyzing table and column size is an important step in optimizing a data model for Power Pivot, Power BI, or Analysis Services Tabular. This article describes VertiPaq Analyzer, an Excel workbook to analyze detailed information extracted from Dynamic Management Views.  Read more

article –

Choosing the Right Hardware for Analysis Services Tabular

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

white paper –

SSAS 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

article –

DIVIDE Performance

The DIVIDE function in DAX is usually faster to avoid division-by-zero errors than the simple division operator. However, there are exceptions to this rule, described in this article through a simple performance analysis.  Read more

white paper –

Using Tabular Models in a Large-scale Commercial Solution

Analysis Services Tabular can be used in large-scale solutions and SQLBI already helped several companies in the challenging effort of defining a reliable and scalable architecture, designing the right data model and optimizing the queries. One of these stories is…  Read more

white paper –

Understanding DAX Query Plans

Understanding DAX query plans is a long process. This paper explains how to capture and read a DAX query plan, helping you to find possible optimizations of your DAX queries.  Read more