Did you have a question in regards to using KPI with something? SSRS, Excel, PerformancePoint, etc.?
I do have a posting and video here in regards to using KPIs with SSRS 2008 utilizing the new gauge report item:
Did you know? SQL Server 2008 SSRS New Data Visualizations