Topic: VertiPaq
Choosing Azure Analysis Services for large datasets
I often get questions about use cases for Azure Analysis Services. So I wanted to do a quick recap of the points I commonly discuss in these conversations, and have them readily available for the next conversation… As a bonus,… Read more
VertiPaq Analyzer 2.0 Preview 1
In 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used with Analysis Services and Power BI. Read more
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. Free download
Storage differences between calculated columns and calculated tables
This article compares the differences between calculated columns and calculated tables from a processing and storage point of view. Read more
Measuring the dictionary size of a column correctly
This article explains how to correctly measure the dictionary size of a column in a model created in Power BI, Power Pivot, or Analysis Services Tabular. Read more
VertiPaq Analyzer 1.7
VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Services Tabular. Learn how to connect VertiPaq Analyzer to Power BI and to SSAS Tabular, and see quick overview of the features available. Then, download… Watch now

Optimizing DAX expressions involving multiple measures
Writing measures referencing other measures is in general a good idea that simplifies the DAX code, but you might face specific bottlenecks. This article describes which performance issues might arise when different measures aggregate the same column using different filter… Read more

Optimizing Hardware Settings for Analysis Services Tabular
Hardware and virtualization settings have a big impact on Analysis Services Tabular performance. This article describes best practices for the most important settings to check. Read more

Costs of Relationships in DAX
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. Read more
Scalable BI and Advanced Modeling with Analysis Services and Power Pivot
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… Watch now