Database Reference
In-Depth Information
Ease of Development
rEPorTING TooL
PrEDEFINED CHArT TyPE
EASE oF DEVELoPMENT
Excel
No
PerformancePoint
Yes
Power View
No
Reporting Services
No
Silverlight/HTML5
N/A
Tool CHoICeS
Relationship analysis is an area in which the Microsoft stack is especially poor.
PerformancePoint has some native capabilities in the form of Decomposition
Trees and strategy maps, and there is an add-in for Excel, but outside of that,
any relationship analysis must be coded. The techniques necessary to do that
are covered later in this chapter.
PPS DECoMPoSITIoN TrEE
PerformancePoint is great for showing how a particular metric is broken
down—not just by predefined hierarchies, as in the drill-down capabilities,
but also with the Decomposition Tree, which allows for a continual drill down
by alternative hierarchies in a tree format.
You want to know the best part? The Decomposition Tree is available at any
time to you. All you have to do is right-click and choose Decomposition Tree,
as shown in Figure 14-6.
FI g u R e 14 - 6
Opening the Decomposition Tree
