Water touches everyone

Water is the most common substance found on earth, yet some observers predict that it will become as precious and contentious as oil is today. With only one percent of the world’s supply available for drinking, and roughly 11 percent of the global population lacking access to potable water, it’s easy to see why.

But before water can flow through new or repaired systems, the world has to turn on the financial taps.

“There is a backlog of water development projects, estimated to be about $1 trillion,” says Rajasekar Krishnamurthy, a research manager at the IBM Almaden Research lab. For example, the state of Texas has a water plan that shows $53 billion is needed for water-supply projects ranging from reservoirs, wells and pipelines to desalination plants.

Determining water’s cost

One reason for that log jam is the difficulty in obtaining financing for water projects, in part because no one knows the real cost of water in a given area.

Developed in the Accelerated Discovery Lab at IBM Research in San Jose, CA, the Water Cost Index is designed to fill that gap. “We’re building benchmarks and determining real costs, region by region,” says Krishnamurthy. But that process is not as simple as it sounds. It involves Big Data and advanced analytics.

Rajasekar portrait against a gray backdrop


A truly uniform global benchmark supports apples-for-apples comparisons across different regions.

Water on earth

in oceans and seas

frozen and unusable

is actually drinkable

Water usage

supplies farming and irrigation

supplies the industrial sector

supports domestic usage

Analytics parse the text reports and estimate missing data

The first step is to amass and then analyze cost data. “We analyze publically available financial reports that agencies make available,” says Krishnamurthy. Those agencies include not only water suppliers and distributors, but also government and non-governmental agencies that subsidize water in some way.

And even that process is not as simple as it sounds. “Agencies report in different ways and at different frequencies,” says Krishnamurthy, noting that for some agencies the latest available reports may be six months to a year old. “We need to account for the variation, and in some cases even extrapolate to fill in missing data.” The reports are typically in PDF or HTML format, and are designed for human consumption. The cost variables and subsidy information are hidden in various sections of these large, 100+ page documents.

Additional analytics challenges arise since agencies occasionally change, over time, their reporting formats or the way in which they break down specific financial details. It is critical that the analytics ensure that everything extracted is correct – what Krishnamurthy calls the “veracity aspect.” They also have to acquire the “variety aspect,” which is data from different geographic areas and sources.

The goal is to analyze some 500 agencies around the planet, representing areas that account for about 25 percent of the world’s gross domestic product. “Right now the focus is on representative agencies in seven geographical regions,” Krishnamurthy says.

The unprecedented level of transparency will be a great asset in attracting private sector funding.

Hon. Professor Ephraim Kamuntu, Minister of Water and Environment, Uganda

Working with Waterfund

IBM is working with Waterfund, a company that provides financial risk management to the water industry. In May 2013, the two entities announced their first project: an agreement with the Ministry of Water and Environment of the Republic of Uganda that makes the country the first in Africa to become a member of the Water Cost Index.

Krishnamurthy foresees the water-index process being applied in other areas. “The establishment of the benchmark is now going to help in development of secondary financial products for both water producers and investors, and also insurance companies will start to incorporate it in their risk modeling, another place where advanced analytics are going to come into play.”