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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
