Despite the availability of advanced software, spreadsheets are still the default data analytics tool for operations managers at many municipal water systems and water distribution companies. The problem with using them is the significant effort it takes to collect and format the information to make any sense of it.

Because spreadsheets require a prohibitively large amount of time to spot problems and find efficiencies, crunching the data often happens much less than it should. An investment in analytics technology can pay for itself quickly by providing a relatively easy method to extract process data from various sources and then by performing an analysis to provide answers to previously difficult questions.

The software also enables improvement decisions to be made based on data, as opposed to hunches, and provides managers with a tool to lean into predictive analytics instead of taking a reactive view of data.


Publication: Water Online

Issue: August 2020

Reprinted with permission of Water Online.