With the proven expertise in the field of Data platform & Analytics for Utilities, Saviant has developed a highly scalable Water Meter Data Management (MDM) & Data Analytics solution that addresses our client’s business needs. A range of cloud services such as No SQL (Cassandra), Azure Blob, Azure Event Hub for data ingestion, and Tableau for data visualization were leveraged to build this utility analytics solution.
Our experts developed an integrated MDM solution that allows to ingest AMI/ AMR data, Billing data, CIS data to generate analytics. We have customized the Validation, Estimation and Editing (VEE) process using various algorithms and implemented the standard process to enhance the quality of smart metering values. This VEE process includes a data quality check, value estimations and edits to clean the data for reasonableness, before it is transferred to the billing system. The system performs data validation check that includes a series of tests, such as missing interval, zero, negative value, spike, static value, high/low usage, and sum check. This ensured to detect meter data errors raised due to improper operational conditions, hardware/software malfunctions, load profile limits, etc., This data cleansing process helped the client to rectify the erroneous as well as missing reads with valid estimations & edits to ensure zero billing errors. Thus, the multitenant PaaS solution built on Microsoft Azure platform helped ensure data accessibility, scalability, reliability & security.
The simplified data is then used to generate various analytics like Meter to Cash, Constant Consumption, Negative Consumption, Abnormal Consumption, etc. These reports help the client to get deep insights on water consumption patterns and trends. The system enables visualization of data coming-in from 1.2 Million water meters installed at various locations. It processes more than 1 Bn+ records per day. The Real-time intelligence architecture helps utilities understand water usage pattern to take the right decisions at the right time. This system also allows the utilities to take preventive actions as against reactive for leakage, abnormal/ over usage, mal-functioning of assets, etc.