Making data useful: Interactive technology helping give public access to huge datasets

Making data useful: Interactive technology is helping make enormous datasets more and more valuable to the public
March 10, 2020

In this data-heavy “Age of Information” in which we live, agencies like the Arizona Department of Water Resources constantly struggle with how to make information we collect more easily available to the public.

And, at the same time, we work to assure the accuracy of our datasets and to present them in a meaningful and useful way.


Long-term storage credits


The Department collects tons of data. Data about water stored behind dams. And on water flowing between dams, like Glen Canyon and Hoover dams on the Colorado River.

We collect information about wells. About how water is used by cities, farms, golf courses and myriad other uses.

We collect reams of data on the amounts of water stored in aquifers underground – water that is both naturally and artificially recharged into those aquifers.

How does the Department make that data useful to the public? One increasingly useful tool is known as “Power BI,” a business analytics service produced by Microsoft. As described by Microsoft, the service provides “interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.”

The Department of Water Resources is making increasing use of Power BI. Its most recent application can be found on the Department’s Underground Water Storage, Savings and Replenishment webpage (click on “read more” ), where an interactive Power BI program is used to illustrate how Arizona accumulated 11 million acre-feet of long-term underground water-storage credits, as of 2016.

This straightforward, click-able tool for analyzing underground storage over the years actually represents 12 years of effort.


The initiative to provide the “Active Management Area Recharge and Demand and Supply Dataset” to the public in an interactive tool began in 2008, not long after staff was tasked with compiling that dataset annually for various planning efforts in the State’s five Active Management Areas, or AMAs.


Water use in the AMAs


Originally, the datasets were developed as water-budget tools in Excel spreadsheets separated according to which of those five AMAs the water was stored in.


It quickly became apparent to ADWR staff, however, that to make all the data about these millions of acre-feet of stored water valuable to the public, the data needed to be stored in a single “container.”

That allowed users to find answers to more general questions. Like: “How much CAP was used by each of the sectors in all the AMAs in the last three years?” Or, “What was the total amount of reclaimed water used, or surface water?”

The sort of questions that the public may wish to have answered, in other words.


The combination of a substantial amount of accurate data combined with a power mechanism like Power BI for presenting it is making complex and dense datasets of information more accessible, transparent, and accurate than ever. And, as a result, more valuable to the general public.

And, for that reason, the Department of Water Resources is committed to making more and better uses for it.

AMA Overdraft Dashboard