If you can measure it, you can definitely dashboard it!
Dashboards can be used to show important KPIs (key performance indicators) for all sorts of industries and work processes. If you can measure it, you can definitely dashboard it! I’ve made a short list of useful KPIs along with the relevant industries. With a bit of imagination & Microsoft Excel techniques you can create endless variations of dashboards.
-
% of fraudulent insurance claims.
% of overdue premium.
Number of new insurance policies.
-
Return on Equity (ROE).
Internal Rate Of Return (IRR).
Net present value (NPV).
-
% of network bandwith used.
Number of SLA breaches due to poor performance.
% of virus incidents.
Learn more about our Excel training workshop: Creating Dashboards in Excel.
Related posts:
- Bullet chart in Excel A bullet chart is a relatively new kind of chart invented by Stephen Few. I was pleasantly surprised to see one in a recent copy...
- Ministry of Manpower Unemployment Dashboard in Excel MOM’s website (www.mom.gov.sg) contains a wealth of labor data. An example is on unemployment rates in Singapore. I took two sets of data: Unemployment Rate (Seasonally...
- How to design a Sales Dashboard in Microsoft Excel Sales activity is the life blood for all businesses. People who are responsible for sales must have their fingers on this vital pulse at all...
