Topic: Optimization

        Page 3 of 33 posts
article –

Filter Arguments in CALCULATE

A filter argument in CALCULATE is always an iterator. Finding the right granularity for it is important to control the result and the performance. This article describes the options available to create complex filters in DAX.  Read more

article –

Security Cost in Analysis Services Tabular

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

video –

DAX Studio 2.1 – New Features

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

video –

Optimizing & Analyzing DAX Query Plans

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

video –

Microsoft PowerPivot Excel 2013 in Action

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