I work for a medium to large-ish sized local government utility and I'm looking for some advice on how I can better my dashboard or redesign my dashboard to better serve our department.
I've uploaded a screen shot of the dashboard and I'm going to try to describe how it works below.
All the layers in this dashboard are dynamically updated nightly as our GIS is updated, so everything should be pretty much up to date. Across the top are 4 filters, the map will filter by fire districts, pressure zones, pipe diameter, and or pipe material. Multiple filters can be engage at the same time and the map will update with each filter added.
Down the left hand side of the map are indicators for length statistics for water mains, transmission mains, and a counter for back flow control valves. Starting at the top left is an indicator for the Total Active City Water Mains then you can click on an arrow on the tab below it that allows you to see the Total Feet of Water Mains Added Last Year. Just below that is the Total Active Private Waters in the network and below that is the Total Active Transmission Mains, followed by the Total Back Flow Control Valves in the system.
Down the right hand side starting at the top is a length indicator for Total Filter Water Mains. This indicator adjusts based on the the filters that can be used on the top of the map or if the user chooses to select mains on the map itself. Below that is a counter for the Total Active City Fire Hydrants and just below that on the same indicator there is a counter for the number of hydrants that can be found when different Fire Districts are selected. Below that is a Details display that shows each of the 9 water facilities we have along with their attributes (water tanks and treatment plants). There is also a tab on this Details indicator that allows a user to toggle to view the 6 major water bodies for our system that each have links to the current level of the water body.
Finally, across the bottom is a chart, albeit ugly at first, that will show filtered data in a chart form that shows the number of mains filter by material and diameter.
I'd like to update this dashboard and make it more functional so it gets more use by our department. Currently, it doesn't get much use at all and I'd like to to change that. I know that redesigning it might not be the answer and the best answer is probably adding data more people are looking for. I've tried to do that with the data that I've included, which includes data for some questions we're asked every year on state and local surveys. I'm open to any idea(s) and or examples anyone has!
Thank you for your feedback!
Mark
