In addition to the articles below, do see the new Camwells Business Performance Management blog. This talks about KPIs and the other aspects of driving improved business performance.
For dashboard reporting of KPIs, there is a free trial of these gauges that can be easily incorporated into Excel. A veriety of styles of gauges are available. Do take a look.