3. Why Wouldn’t I Build Every Future Pivot Table in PowerPivot?

I am going to ask you to step into the WayBack machine.

Do you remember at the end of Chapter 2, “The Promise of PowerPivot,” somewhere around Figures 2.33 through Figures 2.37, where I showed you how to take a regular Excel data set through PowerPivot to enable the ability to use named sets to create asymmetric reports? When I realized that PowerPivot allowed me to create those types of reports, I asked the question, “Well then, why wouldn’t I build every future pivot table in PowerPivot?” By the end of this chapter, you will understand why you might not want to do that.

Now, let ...

Get PowerPivot for the Data Analyst: Microsoft now with O’Reilly online learning.

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