performance

Display # 5 10 15 20 25 30 50 100 All

Quick Tip: Don’t Over-Use FILTER()

Written by Rob Collie on 08 April 2010.

Shrink Tabular column space used by over 50% using a simple trick

Written by James Beresford on 09 February 2015.

Slicer impact on PowerPivot query performance

Written by Vidas Matelis on 16 June 2010.

Slicers and pivot update performance

Written by Rob Collie on 05 July 2010.

SQL Server 2008R2 Self Service BI - Gemini (PowerPivot) - how it performs with bigger tables

Written by Vidas Matelis on 19 August 2009.

Table Denormalization Study in PowerPivot

Written by Marco Russo on 05 February 2010.

Tips and Tricks for Troubleshooting a Microsoft SQL Server PowerPivot for SharePoint Installation

Written by Dave Wickert on 25 June 2010.

Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible

Written by Kasper de Jonge on 07 July 2010.

Understanding Distinct Count in DAX Query Plans

Written by Alberto Ferrari on 22 January 2014.

Video - Excel PowerPivot SQL 2012 vs. Excel 2013 Performance Demo

Written by Dan English on 30 July 2012.

• 1
• 2