Skip to main content
Arizona Department of Water Resources Logo

Arizona Department of Water Resources

Protecting & enhancing Arizona’s water supplies for current and future generations.

Search form

  • About Us
    • ADWR Strategic Plan and Annual Reports
    • Mission - Values
    • History of the Department
    • Arizona Water Facts
    • Small Business Bill of Rights
    • Career Opportunities
  • How Do I?
    • Apply For
      • Change of Ownership
      • New Well
      • Permit
      • Statement of Claimant, Assignments, Amendments
      • Well Driller's License
      • Funding Opportunities
    • Locate
      • A Surface Water Right
      • A Well
      • Statement of Claiment
    • Get Data
      • AAWS Interactive Map
      • ADWR Dictionary
      • GIS Data Center
      • Data Queries
      • Groundwater Levels
      • Imaged Records
      • Land Subsidence in Arizona
      • Wells 55
      • Wells Data
    • Pay For
      • Annual Report Fee
      • Invoice
    • Report
      • Complaint or Concerns
      • Water Use
      • Share or Report a Water Level - 3rd Party Water Level Data Portal
      • Report Dry Well Data
      • Civil Rights
    • Find Info On
      • Arizona Reconsultation Process
      • Conservation
      • Colorado River Shortage Preparedness
      • Drought Contingency Planning
      • Laws, Rules, & Policies
      • Public Records Request
      • Pinal Groundwater Supply Updates
      • Public Meetings
      • Public Notices
      • Water Levels
      • Wells
      • Legislative Affairs
      • Lower Hassayampa Sub-Basin Groundwater Model Report
  • ADWR News
    • ADWR News
    • Blog
    • Podcasts
    • Videos
    • Archive
  • Home
  • Programs
    • Active Management Areas
    • Adjudications
    • Assured and Adequate Water Supply
    • Colorado River Management
    • Community Water Systems
    • Conservation
    • Dam Safety
    • Drought
    • Engineering
    • Floodplain Management and Flood Warning
    • Governor’s Water Policy Council
    • Hydrology
    • Irrigation Non-Expansion Area
    • Laws, Rules, & Policies
    • Legislative Affairs
    • Management Plans Work Group
    • Recharge
    • Statewide Planning
    • Rural Programs
    • Surface Water
    • Wells and Permitting
    • Water Banking Authority
    • Water Protection Fund
  • Online Services
    • Annual Water Use Report
    • Application Forms
    • Hydrology Publications (eLibrary)
    • Land Subsidence Maps
    • ADWR Live Queries and Reports
    • Recharge Long-Term Storage Credit Balance
    • Imaged Records
    • eNOI
    • Online Notice of Well Capping
    • Pump Installation Completion Report
    • Online Driller's Log
    • Online Payments
    • Change of Ownership
    • Assured & Adequate Water Supply Pending Applications
    • Water Atlas
    • Surface Water Online Notices
    • Interactive Maps
      • Assured and Adequate Water Supply Interactive Map
      • Community Water System (CWS) Interactive Map
      • Groundwater Site Inventory (GWSI)
      • Well Registry Data (55)
      • GIS Data
  • Contact Us
    • Concerns
    • Human Resources
    • Contact Us
    • Public Records Request

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

Article Banner

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
Published: 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 Credit Summary through 2016

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 Active Management Areas

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

 

 

waves.png

Waves icon
  • Overview
  • News Articles
  • News Blog
  • Audio Podcasts
  • Video

 

telephone-icon.png

Telephone icon
  • [email protected]
  • (602) 771-8500

 

Follow Us

Contact Info

Arizona Department of Water Resources
1110 W Washington Street Suite 310
Phoenix, AZ 85007
Find in Google Maps
Phone: 602.771.8500 | Fax: 602.771.8689
File a complaint

Newsletter Subscription

Sign up to get breaking news and information about Arizona’s water industry!

Lists*

© 1980 - 2023 Arizona Department of Water Resources - Statements & Policies | Site Map