Databases Reference
In-Depth Information
Use of trusted locations limits access to PerformancePoint Services content types, Excel Ser-
vices, and Visio Services files.
■
When security and data source connections are established, publishing to a SharePoint web-
site is a quick way to share BI assets that ultimately help employees make better decisions,
faster.
■
In SharePoint Server, with Analysis Services SharePoint Mode and PowerPivot, Excel Services,
Visio Services, and PerformancePoint Services functioning as service applications, Visio Web
Drawing files, Excel workbooks, and PerformancePoint dashboards and dashboard items are
stored and secured within SharePoint lists and libraries, providing a single security and reposi-
tory framework.
■
The BI stack: SQL Server + SharePoint + Office
The architectural diagram presented in Figure 1-4 (described in detail on the Microsoft TechNet site
in “Architecture for Business Intelligence in SharePoint Server 2013”) provides another, more technical
visual aid for how each of the pieces work together.
The following is a very brief summary of what's new for BI in SharePoint 2013.
Ad hoc report authoring in the browser by using Power View
■
In Excel 2013, the SQL Server 2012 code base for the latest ad hoc reporting tool, Power View,
is included. Also, PowerPivot is no longer a separate download but is an integral part of Excel
2013.
■
Report authoring is discussed in the next section. Report viewing can occur in just about any
browser, in Microsoft Office, on Windows 8 phones and other table devices (such as Surface and
iPad), and in SharePoint Search.
Search WWH ::
Custom Search