Selected Tags:

excel, performance
Available Tags: dax, design, install, load, mdx, sharepoint, slicer, tabular, tip, tool, video
Title Author Date
SQL Server 2008R2 Self Service BI - Gemini (PowerPivot) - how it performs with bigger tables Vidas Matelis 08/19/2009
Leaf level queries in Gemini (PowerPivot) and SSAS 2008 Thomas Ivarsson 09/19/2009
My tweets from SQL PASS Summit 2009 - SSAS, PowerPivot, DAX and more PowerPivot-Info.com 11/09/2009
Table Denormalization Study in PowerPivot Marco Russo 02/05/2010
Avoiding calculated column in DAX Marco Russo 02/06/2010
Keeping a workbook "pinned" in memory Dave Wickert 03/04/2010
Slicer impact on PowerPivot query performance PowerPivot-Info.com 06/16/2010
Tips and Tricks for Troubleshooting a Microsoft SQL Server PowerPivot for SharePoint Installation Dave Wickert 06/25/2010
PowerPivot field list and Excel field list at same time! Rob Collie 06/27/2010
Slicers and pivot update performance Rob Collie 07/05/2010
Tune your PowerPivot DAX query, don’t use the entire table in a FILTER and replace SUMX if possible Kasper de Jonge 07/07/2010
PowerPivot FILTER condition optimizations Marco Russo 02/07/2011
PowerPivot: improve the performances by sorting tables Alberto Ferrari 04/15/2011
Video - Excel PowerPivot SQL 2012 vs. Excel 2013 Performance Demo Dan English 07/30/2012
PowerPivot / PowerView Excel Workbook Optimizer PowerPivot-Info.com 04/29/2013
 

Pyramid+PowerPivot