Learn DAX in Toronto!

VertiPaq

ARTICLE

Costs of Relationships in DAX

SalesHeaderDetails-Schema

The relationships in a data model queried by DAX are a fundamental part of the engine and simplify the query itself. This article examines the cost of relationships in a data model, providing hints to optimize them.

ARTICLE

Scalable BI and Advanced Modeling with Analysis Services and Power Pivot

ignite2015-brk3561

In this session, you will learn how to define a scalable data model in Power Pivot or Analysis Services, handling a growing volume of data and requests. You will see how to optimize memory usage and performance, how to use relationships in the data model, how to solve common design

ARTICLE

Data Model Size with VertiPaq Analyzer

DMV Size 01

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.

TOOL

VertiPaq Analyzer

VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Services Tabular. A complete description and short tutorial is available in the article Data Model Size with VertiPaq Analyzer.

ARTICLE

Choose 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 perfect Tabular server is not expensive.

ARTICLE

Heap Memory Settings for Analysis Services Tabular 2012 / 2014

The default memory settings for Analysis Services Tabular might be less than optimal. This article describes why this might happen, and guides you choosing the right configuration.

WHITEPAPER

SSAS Tabular as Analytical Engine

sass-as-engine@2x

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.

ARTICLE

DIVIDE Performance

DIVIDE Performance 01

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.

WHITEPAPER

Using Tabular Models in a Large-scale Commercial Solution

large-scale

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 now a case study published as a Microsoft White Paper.

ARTICLE

FILTER vs CALCULATETABLE: optimization using cardinality estimation

A common best practice is to use CALCULATETABLE instead of FILTER for performance reason. This article explore the reasons of that and explain when FILTER might be better than CALCULATETABLE.