Aggregations have been introduced in 2018 in Power BI, as an optimization technique to manage large tables. By providing pre-aggregated tables, you can highly improve the performance of a Tabular data model. In this session we introduce the concept of…  Watch now

How can you optimize your DAX expressions? In this session, we’ll analyze DAX expressions and Tabular models, then utilize DAX Studio and the VertiPaq model to explore how to optimize them. While most optimizations are the direct application of best…  Watch now

You have created a wonderful looking Power BI report, but when you open it you find it is not rendering as fast you want. This session covers where should you start analyzing the problem and what can you do to…  Watch now

DAX Studio 2.7 largely improved the debug experience by adding several feature described in this video: Tooltips for column statistics, capture all queries, and generate dependent measures.  Watch now

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

DAX Studio 2.1 has new important features to analyze query plans and find bottlenecks in your DAX queries. This is a short introduction to this new version.  Watch now

DAX is super-fast, you can use it to query billions of rows in less than one second. End of marketing, now let’s go back to the real world. If your query is not performing as advertised, it is time to…  Watch now