Advertisement
Published in:
2014 | OriginalPaper | Chapter
8. Optimizing Power Pivot Models for Power View
Activate our intelligent search to find suitable subject content or patents.
Select sections of text to find matching patents with Artificial Intelligence. powered by
Select sections of text to find additional relevant content using AI-assisted search. powered by
Abstract
Power View is a worksheet type in Excel that lets users develop interactive visualizations that encourage ad-hoc exploration of the data. It is an ideal tool for users who are not Excel power users who want to explore and gain insight from the data. Since Power View visualizations are based on a Power Pivot model, you need to provide users with a solid model as a foundation for these visualizations. A good Power Pivot model tuned for use by Power View will make the difference between a great user experience and an extremely frustrating one. There are ways to optimize a Power Pivot model so that it facilitates better report creation in Power View. This chapter reviews these settings and shows how to create models that provide support for many Power View features.