performance

Display # 5 10 15 20 25 30 50 100 All

Avoiding calculated column in DAX

Written by Marco Russo on 06 February 2010.

Compression with Power Pivot

Written by Vidas Matelis on 10 December 2015.

Create a memory-efficient Data Model using Excel 2013 and the PowerPivot add-in

Written by Microsoft on 03 April 2013.

DAX Query Plan, Part 1, Introduction

Written by Jeffrey Wang on 08 January 2012.

Detail level reporting with DAX

Written by Chris Webb on 07 September 2011.

DIVIDE vs division operator in #dax

Written by Marco Russo on 25 July 2014.

Hardware/Capacity Planning: From the Trenches

Written by Rob Collie on 30 November 2010.

It’s always a best practice to avoid filtering an entire table if the filter condition involves only some of the table columns (i.e. when no key/unique columns are used in the condition expression).

Written by Marius Dumitru on 25 June 2010.

Keeping a workbook "pinned" in memory

Written by Dave Wickert on 04 March 2010.

Leaf level queries in Gemini (PowerPivot) and SSAS 2008

Written by Thomas Ivarsson on 19 September 2009.

My tweets from SQL PASS Summit 2009 - SSAS, PowerPivot, DAX and more

Written by Vidas Matelis on 09 November 2009.

Nested Measure Performance

Written by Scott Senkeresty on 17 February 2015.

Optimize SUMMARIZE with ADDCOLUMNS in Dax #ssas #tabular #dax #powerpivot

Written by Marco Russo on 04 September 2012.

Optimizing Columnar Storage for Measures

Written by Gerhard Brueckl on 18 February 2014.

Power Pivot Performance Gotchas

Written by Scott Senkeresty on 10 September 2014.

PowerPivot / PowerView Excel Workbook Optimizer

Written by Vidas Matelis on 29 April 2013.

PowerPivot Compression: Mysterious Ways

Written by Rob Collie on 29 March 2012.

PowerPivot field list and Excel field list at same time!

Written by Rob Collie on 27 June 2010.

PowerPivot FILTER condition optimizations

Written by Marco Russo on 07 February 2011.

PowerPivot: improve the performances by sorting tables

Written by Alberto Ferrari on 15 April 2011.

• 1
• 2