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

Analysis Services OLAP cubes are built and processed from data stored in the Operations
Manager BI database.

4.

Data from the OLAP cubes is used to populate PerformancePoint Server scorecards,
dashboards, and analytic reports. These components are originally created by using the
PerformancePoint Services 2013 Dashboard Designer.

5.

Scorecards, dashboards, and analytic reports are made available to the user community
through SharePoint Server. After the scorecards, dashboards, and analytic reports are initially
created and deployed, they should not need to be deployed again. These components are
refreshed as new data becomes available in the OLAP cubes.

6.

7. Alternatively, data that is stored in the tabular database is made available to authoring tools

such as Excel 2013 and Power View in Excel 2013.

The IT Operations scorecard on the right side of Figure 1-5 reveals (flagged by the red diamonds)
that free-space targets for the database are not being met.

Power Pivot and BISM Model: A Fulfillment Report for
Tracking Products
This example demonstrates the ease and simplicity of creating an interactive Power View report. But,
don't misunderstand; getting to trusted data is not as simple as this example might illustrate. The data
that supports it has been massaged, reviewed, and more over the course of several months. This is a
high-level view of the process and steps for getting to a successful product fulfillment dashboard.

The story and report requirements
A team at the call center for Lucerne Publishing manages the fulfillment of orders; specifically, high-
end user-created topics. These topics are created online with existing family pictures in the form of
images and often content from individual social networking sites. The team needed an interactive
report with which it could manage the fulfillment of orders by monitoring the various states of an
order as they relate to the fulfillment of that order. This helps it manage third-party vendors who
assist in fulfilling a book order.

Choosing a tool, introducing self-service BI, and planning for adoption
After having an understanding of the team culture, existing infrastructure, and having chosen a tool-
set for BI, as described in Chapter 2, the IT team chose to set up self-service analytics by using Power
View and underlying data from their data systems, imported into PowerPivot in Excel 2013.