Identify what you want to analyze
What problems need to be solved? What questions need to be asked? You need to ensure that metrics are linked to strategy and also that you are measuring and reporting with the goal of improving your company.
Here are some examples of areas that you can look at for creating your dashboards.
Customer Look at a measure such as billing accuracy, number of complaints, time to resolve a complaint, water outage time, delinquency rate. Track how keeping an accurate view of the customer through the merging of disparate systems and by implementing a data quality strategy can help you have a better view of the customer and help you serve them better.
Financial Providing KPI reporting on the financial aspect of the organization can provide quick insights to the executive level dashboard. Looking at a few examples: gross revenue, net revenue, costs, operating cash flow, current account receivables, current accounts payable.
Infrastructure Monitoring Aging infrastructure places heavy costs on the utility business. Look at the cost of planned versus emergency maintenance. The cost to fix leaks versus fixing breaks. The cost of the service and the lost revenue if that service is unable.
Operations Looking at the day to day running of the organization and making adjustments based on the real-time data presented to the subject matter experts, for example, the cost to complete a job, time to complete, crew productivity.
Regulation Because utilities are expected to conduct transparent operations and comply with stringent regulations, thorough reporting in areas such as health and safety issues, prevention and safe disposal of waste, environmental risk management during construction and operations, disposal of waste, drinking water quality and reductions in the number of complaints to regulatory body are a must to comply.