Comparison of KPI Types in SharePoint Server 2007

SharePoint Server 2007 offers five different methods to create Key Performance Indicators (KPIs) 

  1. Using data from published Microsoft Excel 2007 spreadsheet.
  2. Using KPIs defined in SQL Analysis Service Cube.
  3. Using dashboard created in PerformancePoint 2007.
  4. Using data from SharePoint list.
  5. Using manual data entry.

This post compares the relative merits of methods 1-3 and suggests scenarios where a particular method is suitable over others. Continue Reading …