This study presents a collaborative framework developed by the Water Futures team of researchers for the “Battle of the Water Demand Forecasting” challenge at the 3rd International WDSA-CCWI Joint Conference. The framework integrates an ensemble of machine learning forecasting models into a deterministic outcome consistent with the competition formulation. The water demand trajectory over a week exhibits complex overlapping patterns and non-linear dependencies to multiple features and time-dependent events that a single model cannot accurately predict. As such, the reconciled forecast from an ensemble of models exceeds the performance of the individual ones and exhibits higher stability across the weeks of the year and district metered areas considered.

Most water utilities have to handle a substantial number of customer complaints every year. Traditionally, complaints are handled by skilled staff who know how to identify primary issues, classify complaints, find solutions, and communicate with customers. The effort associated with complaint processing is often great, depending on the number of customers served by a water utility. However, the rise of natural language processing (NLP), enabled by deep learning, and especially the use of deep recurrent and convolutional neural networks, has created new opportunities for comprehending and interpreting text complaints. As such, we aim to investigate the value of the use of NLP for processing customer complaints. Through a case study about the Water Utility Groningen in the Netherlands, we demonstrate that NLP can parse language structures and extract intents and sentiments from customer complaints. As a result, this study represents a critical and fundamental step toward fully automating consumer complaint processing for water utilities.