Microsoft Excel 2013: Building Data Models with PowerPivot

Chapter 11. Shaping the reports

In the previous chapters, you have learned some data modeling techniques that greatly help in the building of reports. Data modeling is very important, and we cannot overstress the fact that, although you will not need to become a master in data modeling, you need at least to understand the basic techniques to achieve optimal results using Microsoft Excel to create complex reports. But data modeling, alone, is only useful to compute numbers. Once a number is computed, it still needs to be shown to the user in a report so that it is easy to understand and leads to good insights in the data.

You have learned the tools available in Power View to design a report; now, it is time to merge the two topics and learn some ...