Microsoft Office Tutorials and References
In Depth Information
Chapter 2
PowerPivot at Work
Chapter 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
PowerPivot at Work ..................................... 17
We are now going to introduce some of the most interesting features of Microsoft SQL
Server PowerPivot for Excel. The goal of this chapter is to show the most frequently used
PowerPivot features for transforming a simple Excel workbook into a complex report that
helps you perform analysis on data. This is not yet the place for more advanced topics,
such as the DAX programming language or complex relationships. Nevertheless, after you
read this chapter, you will be able to perform complex analysis on a relational database
and—we hope—still feel the need to go forward in your reading to discover the most
advanced uses of PowerPivot.
Please note that we sometimes refer to the end user or the user experience as if we think that your
PowerPivot workbook might be used by somebody else. To make a good report, you always
need to think in this way. Even if you are the only user of a specific report, a user-friendly report
is easier to read and update even after some time has passed since its creation.
using the PivotTable to Produce Reports
Let us start with a very simple report, based on the same three tables that you loaded in the
previous chapter: Sales Order Header, Sales Order Detail, and Product.
If you create a PivotTable with PowerPivot and put OnlineOrderFlag and SizeUnitMeasureCode
on the Report Filter pane, Size on Column Labels, Color on Row Labels and the OrderQty as
the value to sum up, you end up with the report shown in Figure 2-1, which you can find in the
workbook named CH02-01-FirstSample.xlsx in the companion content.
FIguRE 2-1 A simple report using PowerPivot.
Search JabSto ::

Custom Search