Database Reference
In-Depth Information
In addition, Reporting Services and Power View are the only two tools that
include mapping capabilities, and Reporting Services allows for much greater
customization of the maps.
Reporting Services is often used where inclusion of specific formatting ele-
ments, such as logos, time of running reports, and so on, are required—for
instance, in a monthly board pack that needs to be printed.
Figure A-2 shows an example Reporting Services front page.
FIguRe A-2
A report showing the progress of initiatives in a government department
eXCel/eXCel SeRVICeS
Excel is and has always been the domain of the analyst—someone who wants
to interact with his data and have a dynamic visualization rather than a static
one. Pivot tables and pivot charts, with slicers, enable a user to build an inter-
active dashboard, and the ability to publish on the web using Excel Services
allows for the sharing of the analysis while preserving the interactivity. The
inclusion of PowerPivot (in Excel 2010) and Power View (in Excel 2013) advances
this interactivity greatly.
Figure A-3 shows an example of an Excel dashboard.
