What’s So Special About SharePoint’s December Update?

Just in case you didn’t already know, a cumulative update for SharePoint Server 2010 was released in mid-December, and it’s a big deal for business intelligence. Cumulative Update 2011-12 (CU 2011-12) for Microsoft SharePoint Server 2010 is exciting because it enables people to view PerformancePoint reports, scorecards, Excel Services reports, and other items on Apple…


You Can Use SQL Server "Denali" PowerPivot Models as PerformancePoint 2010 Data Sources

Since SQL Server Denali hit the public download space, several people have tried using it to create PowerPivot models as data sources for PerformancePoint 2010. And why shouldn’t they? PerformancePoint works just fine in the scenario where you specify the reference to a PowerPivot model in the data source connection string for an Analysis Services data source….


Finding the Latest PerformancePoint 2010 Services Updates

Sometimes it’s difficult to find the latest updates for SharePoint 2010 and for PerformancePoint Services, specifically. The easiest way to see these latest updates is to visit the Microsoft Office Update Center or subscribe to the Updates for Microsoft Office and Related Products RSS feed. You can visit any of the individual cumulative update pages as a way to…


How to Highlight Table Rows Based on Slicer Selection

When you connect Slicers to Pivot Tables or Pivot Charts, their effect on the data is obvious: changing your Slicer selection causes data values to change and in some cases, rows to disappear.  However, rather than excluding rows with a Slicer, sometimes you want to highlight the rows that correspond to the Slicer Selection. When…


Choose the Right Business Intelligence Style for your Project

The Office Business Intelligence group gets the occasional question about why we offer several different BI solutions when our competitors often only offer one. Microsoft offers its customers no shortage of choices when it comes to BI solutions. We do this because, like anything else, there is no single solution for any problem. The hammer…


Poll Your Friends with Photo Vote

Poll Your Friends with Photo Vote In this post, we’ll introduce you to Photo Vote, a new app created by the Office Business Intelligence team in partnership with the Microsoft Office Labs team. With Photo Vote, you can create quick polls in Facebook, gather input from your friends, and then geek out on your results…


Intro to Excel Services Data Sources

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…


Getting Data in PerformancePoint

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…

3

Creating simple budget KPIs from SharePoint Lists

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…

18