Tag: data management

Using IT Design Methods to Improve Software Tools

This is the third post in a three-part blog series on data management. This post will focus on user-centered design of Environmental Finance Center tools.

Post by Julia Cavalier, Senior Research Specialist at UNC EFC and Robin Haley,  Graduate Research Assistant at UNC EFC

As mentioned in the first and second part of this blog series, If you build the data platform, will they come? and Behind the Scenes of the Revenueshed Tool, the Environmental Finance Center (the EFC) project designers have to know the users, identify purpose of the project goal, and collect the data that exists to support this goal. With this comes documentation of the project, because without context it will be difficult to replicate actions and hard to understand from a user’s perspective. The EFC is revising some existing tools. The first step in revision is to understand and document how tools are used. The second step in revision is to set goals for what new tools should do. The goals will become the foundation of tool redesign.

Which EFC tools are being redesigned?

The EFC is redesigning the following tools:

  1. Water and Wastewater Rates Affordability Assessment Tool (the “Affordability Tool”). This tool shows the impact of rates on different customers. It looks not just at median household income but also other impacts on affordability like poverty rate.
  2. Financial Health Checkup Tool. This tool gathers input from five years of utility financial data and shows how key financial indicators compare to benchmarks.
  3. Rates Analysis Model. This tool lets a utility explore different rate changes – what would happen if I increased rates, added blocks, or changed the base or volumetric charges within some blocks?

Continue reading

If you build the data platform, will they come?

This is the first of a series of three posts on utility data management. The Environmental Finance Center collects all sorts of data for projects. The EFC uses data from regulatory agencies, financial reports, and data on area residents from the US Census Bureau.

 

The project design questions the EFC asks are:

  1. Know the users! Are they:
    1. Decisionmakers?
    2. Staff?
    3. The public?
  2. What should be shown?
    1. Decisionmakers need reliable data on cost and benefits
    2. Staff may need to drill down on details
    3. Overall, tell a story
  3. What data exists to support and analyze how can different data sources be connected?

 

For water and wastewater rates dashboards, the EFC’s primary audience is staff of utilities and the secondary audience are utility board members and decisionmakers. The EFC shows utility rates and, importantly, the context for those rates. Multiple dials show the user the balance between factors such as operating ratio and affordability. Comparison groups let the user look at their rates in comparison with other utilities in their watershed or with utilities serving similar numbers of customers. This year, the EFC has added dials for non-revenue water and for wastewater inefficiency to the North Carolina dashboard.

Continue reading