SharePoint Reports is a comprehensive, server-based solution provided by Microsoft Office SharePoint Server 2007 that allows you to  build business intelligence dashboards. 

Key performance indicator (KPI) information can be retrieved from published Excel workbooks and other sources of data such as SQL Server. Typically, a KPI includes the current value of the indicator, a goal value, and a critical threshold value