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

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

Learn how to install and use DAX Editor for Visual Studio  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

This session goes beyond the classical star schema modeling, exploring new techniques to model data with Power Pivot and SSAS Tabular. You will see how brute-force power in DAX allows different data models than those used in SSAS Multidimensional. You…  Watch now

DAX is not only an expression language, but also a query language and, when it comes to performance, the xVelocity in-memory engine is second to none. Scanning fact tables and performing leaf-level computation happens in a matter of milliseconds. Nevertheless,…  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