Skip to Main Content
PowerPivot for Business Intelligence Using Excel and SharePoint
book

PowerPivot for Business Intelligence Using Excel and SharePoint

by Barry Ralston
March 2011
Beginner to intermediate content levelBeginner to intermediate
302 pages
6h 57m
English
Apress
Content preview from PowerPivot for Business Intelligence Using Excel and SharePoint

Tuning PowerPivot Performance

PowerPivot for Excel's features for loading and combining data can be dazzling. In certain cases, these very data loading features can also lead to slow-performing PowerPivot for Excel solutions.

Slicers: Less Is More

In my opinion, slicers are the most visually unique element of PowerPivot. However, they can greatly impact the performance of report (PivotTable and PivotChart) updates. If you incur this type of performance issue in your PowerPivot solutions, here are a couple of suggestions for decreasing update runtimes.

First, endeavor to source slicers from dimension tables as opposed to fact tables in your solution. For example, consider an organization that works with a product set that contains 200 distinct ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition

SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition

Tony Smith

Publisher Resources

ISBN: 9781430233800Purchase book