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 ...