© The Author(s), under exclusive license to APress Media, LLC , part of Springer Nature 2021
A. MurrayAdvanced Excel Successhttps://doi.org/10.1007/978-1-4842-6467-6_6

6. Power Pivot – The Internal Data Model of Excel

Alan Murray1  
(1)
Ipswich, UK
 

Power Pivot is a feature that takes us beyond the Excel spreadsheet. We can do things with Power Pivot that are unheard of with traditional Excel techniques.

This chapter will walk through the creation of a Power Pivot model from start to finish. We will produce different reports to showcase the power of this internal data model of Excel.

What Is Power Pivot?

Power Pivot allows us to surpass the limitations of an Excel spreadsheet and perform powerful data analysis.

We can load tables from different sources ...

Get Advanced Excel Success: A Practical Guide to Mastering Excel now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.