Alberto Ferrari

How do you optimize a DAX expression? In this session we analyze some DAX expressions and Tabular models and, through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them.

This is what seasoned data modelers always create: a star schema. There are a lot of reasons why a star schema works better, in Power BI as in most analytical engines.

If you already know and use the DAX but want to move to the next level, this workshop is for you. Unleash the full power of evaluation context manipulation, learn about expanded tables, control the data lineage, avoid circular dependencies, and manage relationships at different granularities.

Window functions (INDEX, OFFSET, WINDOW) are the latest addition to DAX; they also introduce a new concept named apply semantics. They are extremely powerful to simplify writing DAX code that needs to work on sorted tables, while also increasing performance for several calculations, like running totals, comparing one…

When you create a Power BI report, you might hit some performance issues when you have a large amount of data, complex data models, or complex DAX expression in your measures. The first goal of this tutorial is to discover possible bottlenecks analyzing the execution of DAX calculations using tools such as DAX Studio…

Composite models, that is the ability to extend an existing Power BI or Azure AS data model with new tables, columns and relationships, is the holy grail of self service business intelligence. In this introductory session we describe the feature along with some details about how to implement it in your existing…