PerformancePoint Services Resource Center. Roger Doherty's SQL Server Evangelism Blog. 47 minutes, 18 seconds 39 minutes, 9 seconds 5 minutes, 18 seconds 10 minutes, 57 seconds 14 minutes, 48 seconds 6 minutes, 31 seconds 12 minutes, 19 seconds 5 minutes, 17 seconds 4 minutes, 43 seconds 11 minutes, 9 seconds.
Intro to Excel Services Data Sources - PerformancePoint Services. 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. For this example, I've created a sample workbook containing data about U.S. state government finances and population. The data in my workbook came from the site I downloaded three workbooks from this site containing information about US state revenue, expense, and population in 2008. I consolidated this information into one workbook and then created a summary table called "StateFinances2008" containing simple metrics for each state like Revenue per Person and the Debt to Cash and Securities ratio. Here's the workbook in my BI Center document library:
Creating simple budget KPIs from SharePoint Lists - PerformancePoint Services. 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 the rules will be >100% budget is warning, >120% budget is bad. Later we can swap in other sources of information, for example employee anticipation around the next golf scramble, into the KPI's definition to make it a more accurate or more predictive metric, and the changes will flow into the higher level scorecard that uses the KPI. Here's a sample of our spending history list.
I launch Dashboard Designer from the Business Intelligence site template homepage. Now we're ready to build the KPI and a test scorecard. PerformancePoint Server for developers. Create a Reporting Services report by using Dashboard Designer. Published: May 29, 2010.
Getting acquainted with PerformancePoint dashboards and Web Parts - SharePoint Server. PerformancePoint dashboards and their Web Parts can offer you a world of information about your organization.
Because PerformancePoint dashboards are continually connected to their data sources, the information in them is up-to-date and it is usually interactive, too. PerformancePoint Services Architecture in SharePoint Server 2010 - SharePoint in Pictures. PerformancePoint Services in SharePoint Server 2010. Learn about fundamental PerformancePoint Services concepts, procedures, and code samples, and find getting started information, troubleshooting tips, and other PerformancePoint Services resources.
Last modified: June 03, 2011. How to navigate PerformancePoint dashboards and explore data - SharePoint Server. When you look at a PerformancePoint dashboard on a SharePoint site, you might see one or several items on it.
Typically, but not always, the dashboard contains a scorecard, and some filters, charts and grids. Each scorecard and report is placed on the dashboard as a Web Part. You can navigate within a report or perform actions on the Web part itself. Dashboard can include more than one page. The dashboard in the example below shows a filter, links to more pages, a scorecard, an analytic bar chart, a KPI details report, and a pie chart. In some cases, the actions that you take in one Web Part affect the results that you see in another Web Part. PerformancePoint « Dan English's BI Blog. Last year I did a posting on Using PowerPivot with PerformancePoint Services (PPS) 2010.
I thought it would be a good idea to do an updated posting with the new release of PowerPivot that will be coming out this year to show the new features that you will be able to take advantage of now. Before we get started I need to point out that if you setup your SharePoint environment with a fresh install of SQL Server 2012 that you will also need to download and install the Analysis Services ADOMD.NET (version 10.5) data provider from the SQL Server 2008 R2 SP1 Feature Pack. I had previously tried to reference PowerPivot SQL Server 2012 in the “Denali” CTP3 and in RC0 release and received the following error message when trying to configure the connection string in the PerformancePoint data source setup: An error occurred connecting to this data source. Please check the data source for any unsaved changes and click on Test Data Source button to confirm connection to the data source.
Using PowerPivot with PerformancePoint Services (PPS) 2010 « Dan English's BI Blog. UPDATE (6/20/2011): Modified table layout of step-by-step walkthrough to be two columns instead of three.
Added a downloaded PDF file as well. UPDATE (2/24/2012): I have a blog for using PowerPivot 2012 with PerformancePoint Servers here - Using PerformancePoint Services (PPS) with PowerPivot SQL Server 2012 RC0. Analysis Services was one of the primary data sources with the previous version of PerformancePoint to get the most functionality out of the product. Using Reporting Services in SharePoint Integrated Mode with PPS 2010 with SQL Server “Denali” CTP3 - PerformancePoint Services. The SQL Server team has made a small change to the location of the web service that PPS calls in order to render SQL Server Reporting Services reports when running in SharePoint Integrated mode.
In this blog post, I’m going to go over how to work around that problem and get your reports rendering again. The changes in Denali now have SSRS running inside the SharePoint Shared Service architecture, which in the long term will make management of this service a lot easier for the people responsible for making sure the service is up and running. As a consequence of this change, the web service that PPS relies on (ReportExecution2005.asmx) changed location. It is now located in the _vti_bin folder along with the other SharePoint web services.