Business intelligence in SharePoint - Business Intelligence in Microsoft SharePoint 2013 - page 12

Authoring in Microsoft BI tools
When it comes to SharePoint and BI, the essential objective is to have the ability to create insights in
the authoring tools that are spread among Office, SharePoint, and SQL Server (see Table 1-1) and then
to share the results in charts, reports, dashboards, and KPIs. These insights can be shared with the
organization, the team or community, or with the individual via a browser.

TABLE 1-1 Microsoft BI authoring tools and platforms

Product or platform Authoring tool Comments

Microsoft Office 2013 desktop
applications

PowerPivot and Power View in Excel
2013, Visio 2013 (Professional or
Premium)

Before publishing a worksheet to
SharePoint using Excel Services or
Visio Services, you must have al-
ready authored and—if applicable—
connected to a data source.

SharePoint Server 2013 Dashboard Designer and Web Parts

that offer KPIs

You start Dashboard Designer from a
SharePoint website.
BI Web Parts are available to use
individually to create simplified KPIs.
Each client tool also provides Web
Parts to extend your ability to render
reports.

SQL Server 2012 SQL Server Reporting Services

Report
SQL Server Data Tools (Visual
Studio with same functionality as
PowerPivot but deploy to SSAS)
Excel: consumes Analysis Services/
Tabular data via an ODC or BISM
connection file.
PowerPivot for SharePoint

Report Builder and Report Designer
was originally designed to help you
create reports.
PowerPivot for SharePoint is a
SharePoint shared service that
integrates PowerPivot into your
SharePoint environment.
Access a deployed SSDT project via a
connection file.

Examples of BI in SharePoint 2013

The following sections look at ways that you can take advantage of SharePoint 2013 features for
developing and strengthening your BI capabilities.

PerformancePoint and the BI stack
Figure 1-5 demonstrates how a solution using PerformancePoint Services in SharePoint 2013, inte-
grated with SQL Server 2012, provides KPIs that drive decisions in an IT department. The IT Opera-
tions scorecard shows how simple it is to see where database space, as a percentage, is not meeting
its target. After the following illustration is a brief explanation that maps what is going on under the
hood.