Our client was finding ways to enhance the consumer experience, minimize complaints, and improve their existing meter data management system performance. They had AMI/ AMR data, Billing data, CIS data coming in from multiple sources collected from distribution, residential, commercial and industrial areas. Their large & complex metering systems meant frequent data quality issues like missing or negative data getting recorded and stored. However, their existing MDM system lacked capabilities to process the collected raw metered data efficiently for analysis.
To overcome the inevitability of data quality issues, the client wanted a scalable & robust MDM system that helps in processing enormous volumes of meter data. They wanted to implement a standard data processing method called Validation, Estimation and Edit (VEE) to mitigate the risk of using unprocessed data for analysis. Thus, VEE process would simplify data processing efforts for assessment of utility consumption and accurate billing. They also wanted to generate analytics using VEE summary data to provide real-time visibility of water consumption. They wanted these smart data analytics capabilities to let utilities analyse water distribution & consumption patterns, provide accurate billing, and match supply-demand precisely.