Applying security roles to a SSAS Tabular database might impact query performance. This article describes existing issues and possible workarounds. This is an advanced article, a good knowledge of storage engine and formula engine is required.  Read more

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

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

Microsoft Excel 2013 and Business Intelligence: a marriage made in heaven. PowerPivot and Power View, the two most exciting BI tools in the Microsoft stack are now integrated into Excel 2013, providing the perfect environment to build self-service BI solutions.…  Watch now

The VertiPaq engine, which is the core of the new SQL Server Analysis Services Tabular engine, has an unprecedented level of performance, thanks to its fine-tuned architecture and its ability to perform fast cross-fltering. Automatic cross filtering between columns of…  Watch now