Database Reference
In-Depth Information
when to use Reporting Services:
uu
Specific visualizations, such as ranges and maps, are required.
uu
High visual fidelity is required.
uu
Reports need to be printed.
when not to use Reporting Services:
uu
Dynamic measures are required.
uu
Slice and dice capabilities.
uu
Anonymous access is required.
when to use excel:
uu
Interactivity is required.
uu
No cube is available (build one through PowerPivot).
uu
A higher level of control over individual chart elements is required (for
example, drag-and-drop positioning of chart labels).
uu
Possibly the fastest development using pivot tables and charts.
when not to use excel:
uu
Guided interactivity is necessary—it's better in PerformancePoint.
when to use Power View:
uu
Animation is required.
uu
Cross-filtering between charts.
when not to use Power View:
uu
When any control over chart formatting is required—it is even more lim-
ited than PerformancePoint.
InSTAllIng THe SAMPle DATABASeS
The two samples are in SQL server database format and in Analysis Services
tabular mode. You need SQL 2012 for both.