Microsoft Office Tutorials and References
In Depth Information
Authoring and Publishing PerformancePoint Solutions
In this section, we will create all of the PerformancePoint content objects necessary to implement a typical business
intelligence dashboard using data from the AdventureWorks sample database. Our solution will include the KPIs,
scorecards, filters, reports, and dashboards necessary to provide the user with a rich data analysis environment.
We will deploy this solution to SharePoint and explore the resulting user experience.
In the following section, “Advanced Report Types,” we will then expand on this solution by adding reports
to the dashboard based on Excel Services and Strategy Map report types.
this tutorial will make extensive use of the adventureWorks SSaS solution. You can download the
adventureWorks database from http://msftdbprodsamples.codeplex.com/ . take a look at Chapter 1 for details
about deploying the solution as an SSaS database.
Note
prOBLeM CaSe
author and publish a Bi solution that allows a marketing manager at adventureWorks to analyze the effectiveness
of his marketing campaigns by product and sales channel.
Solution
the solution for this case will be created in the following sequence:
1.
enable all necessary features in Sharepoint, and create a site using the Business intelligence
Center site template.
2.
Create a Dashboard Designer workspace in which to create the solution components.
3.
Create a data source from which to retrieve the business data.
4.
Create a set of Kpis representing the data.
5.
Create a scorecard to display the Kpis.
6.
Create a set of filters to control how the data is sliced by the user.
7.
Create a set of reports allowing the user to perform an analysis on the underlying data.
8.
Create a dashboard that integrates all of these components into an interactive analysis
engine designed to help the user make decisions.
9.
Deploy the solution to Sharepoint, and examine the user experience exposed
by the dashboard.
Before attempting to follow this tutorial, you should already be familiar with basic BI and PPS concepts such
as dimensions, measures, KPIs, scorecards, etc. If not, please refer to “Business Intelligence Solution Components”
earlier in this chapter for PPS components and Chapter 1 for dimensional-modeling concepts.
 
 
Search JabSto ::




Custom Search