Designing, Implementing, and Evaluating a Municipal Water Quality Dashboard

UNCW Author/Contributor (non-UNCW co-authors, if there are any, appear on document)
Lucas Layman (Creator)
Carson Monschein, Student (Creator)
Institution
The University of North Carolina Wilmington (UNCW )
Web Site: http://library.uncw.edu/

Abstract: At the Cary/Apex Water Treatment Facility in North Carolina, laboratory staff and sampling technicians perform over 100,000 water tests every year. This abundance of data is validated manually and analyzed with spreadsheets. This paper describes the process of designing, implementing, and evaluating a data visualization dashboard in PowerBI to help this water treatment facility effectively monitor the quality of the drinking water in their distribution system. The effectiveness of the dashboard was evaluated through surveys given to the project stakeholders. The feedback from these surveys showed that, overall, the users found the dashboard useful but would like to have real-time data updates.

Additional Information

Publication
Monschein, C., & Layman, L. (2024, March). Designing, Implementing, and Evaluating a Municipal Water Quality Dashboard. Proceedings of IEEE SoutheastCon 2024.
Language: English
Date: 2024
Keywords
dashboard, data visualization, PowerBI, water treatment monitoring

Email this document to