Database Reference
In-Depth Information
used throughout the topic, and indeed the industry, so this will be a useful
section. The terms are:
uu
Pivot
uu
Drill down (Drill up is the reverse)
uu
Drill through
uu
Drill across (not to be confused with cross drill)
uu
Slice
Pivoting
Excel popularized the pivot table, an indispensable tool for any analysis.
Pivoting refers to the ability to drag any field into rows or the columns, and
then view the data aggregated across those fields. Figure 13-3 shows a typical
Excel pivot table and pivot chart beside each other.
F I g u R e 13-3
A pivot chart in Excel
Ease of Development
rEPorTING TooL
PrEDEFINED CHArT TyPE
EASE oF DEVELoPMENT
Excel
Yes
PerformancePoint
Yes
Power View
Yes
Reporting Services
No
Silverlight/HTML5
N/A
