PerformancePoint Services in Microsoft SharePoint Server 2010 (PPS) makes it easy and convenient to organize and share your business insights. Upcoming blog posts by Office BI pros will delve into the following topics: Efficiently organize PPS content in SharePoint Server Easily share up-to-date information Quickly preview PPS content in SharePoint Build impressive PPS scorecards based on SharePoint lists Stay tuned for more on these topics! If you have suggestions...

Today's "better together" post is by Poornima Hanumara, a program manager on the Office BI team. Thank you Poornima, and to our readers, have a great week! I want to quickly prototype a new dashboard to keep track of the products in my sporting goods store. PowerPivot is a great tool to create a data model. This model can be used as a data source for PerformancePoint Services to create a dashboard. Here's the simple dashboard I want to create: To get started I need...

PerformancePoint Services 2010 (PPS) provides a variety of ways to use data in analytic solutions. The usage of Analysis Services cubes and SharePoint lists in PerformancePoint is relatively well understood. Upcoming posts from the Office BI team will focus on some less well-understood aspects of getting and using data in PerformancePoint dashboards. Here are the topics that we plan to cover: Using Excel Services to create data that is presented in PerformancePoint scorecards...

Introduction The Excel Services Data Source in PerformancePoint 2010 allows you to create data using familiar Excel tools and methods that you can then surface in PerformancePoint scorecards. To demonstrate the use of the Excel Services Data Source, I'll walk you through creating a scorecard that shows information about U.S. state government finance. The data for the this scorecard will be in an Excel workbook in a SharePoint document library. My Example Workbook For...

One long-awaited and much-requested feature for PerformancePoint, Cascading Filters, is available in SharePoint Server 2010 SP1. I wanted to go through the deployment of a dashboard using Cascading Filters to show both the ease and a little of the power this feature provides. The concept of cascading filters is that the output of one filter becomes the input of another; or more precisely, the choices made in one filter limit the choices available in another. Typically, this...

In this post we're going to walk through how our favorite fictional company Litware uses PerformancePoint Services with SharePoint list data to do simple "under budget" KPIs. In Litware's party planning committee we log how much we spend on events using a SharePoint list. Corporate's creating a corporate balanced scorecard using PerformancePoint Services, and they've asked us to contribute a KPI showing how we're doing. For now our KPI will be based on the data we have, and...

Today’s post is by Denise Stendera, a writer on the SharePoint business intelligence team. Thanks Denise! Got Project? When you create a Project Web App in SharePoint Server, you automatically get a Business Intelligence Center. If PerformancePoint Services is configured, you can use Dashboard Designer to create project management dashboards. For example, you can create a dashboard to track project resource usage like the one shown in the following image: Using...

As part of the Office Content Publishing group at Microsoft, our team writes Help content about business intelligence capabilities in SharePoint Server. In this blog, we'll look at how you can reuse and share your business intelligence content in team sites and other convenient locations. Available in SharePoint Server 2010 is the Business Intelligence Center site template. You can use it to create and configure a place to store and organize your business intelligence content...

Two samples that work with PerformancePoint analytic reports are now available on MSDN. · PerformancePoin​t Services 2010: Change Analytic Report Data Source Sample lets users change the data source that an analytic report points to. · PerformancePoint Services 2010: Save Analytic Report Sample lets users save a copy of a navigated analytic report. Both are packaged as SharePoint features in Visual Studio 2010 solutions. Note : The samples were developed...

All the items you create when you build BI solutions using PerformancePoint are stored in SharePoint. PerformancePoint data sources are stored in specialized SharePoint document libraries. PerformancePoint content is stored in specialized SharePoint lists; all the scorecards, KPIs, indicators, reports, filters, and dashboards that are created as part of a PerformancePoint solution are stored in SharePoint lists. Explore In SharePoint with BI Center You can explore this by...