Scorecard and KPI Overload?

Scorecards and Key Performance Indicators (KPIs) aren't limited to PerformancePoint Services. Multiple Microsoft products offer some form of KPI and scorecard support:

  • SQL Server Analysis Services (SSAS) 2005 introduced a way to define and group KPIs. This capability is still available in SSAS 2012.
  • SharePoint 2007 provides a simple way to define and display KPIs in a list, independent of both SSAS and PerformancePoint Services. This capability is still available in SharePoint 2010.
  •  SQL Server Reporting Services (SSRS) 2008 introduced gauge controls and status indicators. These controls and indicators are still available in SSRS 2012.
  • PivotTables in Microsoft Excel 2010 and Excel 2007 support the display of SSAS KPIs.
  • Microsoft's PowerPivot for Excel 2010 add-in provides a means to define and display KPIs.

With all of these options, how do you decide which products to use? My rule of thumb is for IT professionals to define KPIs in SSAS and display them through PerformancePoint Services. For business users, I recommend using the PowerPivot add-in for the definition and display of KPIs, with the possibility of "upsizing" to PerformancePoint Services for additional display options at some point in the future.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.