Selected Tags:

performance
Available Tags: dax, design, excel, install, internals, load, mdx, setup, sharepoint, slicer, tip, 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 Vidas Matelis 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
Quick Tip: Don’t Over-Use FILTER() Rob Collie 04/08/2010
Slicer impact on PowerPivot query performance Vidas Matelis 06/16/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). Marius Dumitru 06/25/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
Hardware/Capacity Planning: From the Trenches Rob Collie 11/30/2010
PowerPivot FILTER condition optimizations Marco Russo 02/07/2011
PowerPivot: improve the performances by sorting tables Alberto Ferrari 04/15/2011
Detail level reporting with DAX Chris Webb 09/07/2011
DAX Query Plan, Part 1, Introduction Jeffrey Wang 01/08/2012
 

Varigence Vivid