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.
- Insurance
- % of fraudulent insurance claims
- % of overdue premium
- Number of new insurance policies
- Investment
- Return on Equity (ROE)
- Internal Rate Of Return (IRR)
- Net present value (NPV)
- Information Technology
- % of network bandwidth used
- Number of SLA breaches due to poor performance
- % of virus incidents
About Aeternus Consulting
Related Link: Aeternus Consulting Excel Training Courses Singapore
Aeternus Consulting offers an excellent workshop Create Executive Dashboards in Microsoft Excel. This master level workshop aims to teach you how to create professional information dashboards in Microsoft Excel that is beautiful, concise and clear.
Related Link: Create Executive Dashboards in Microsoft Excel