Selected Tags:

performance
Available Tags: dax, design, excel, install, load, mdx, 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