Our project goal was to develop a methodology to improve the collection and storage of data regarding current and future Water Engineers for the Americas and Africa (WEFTA) projects which is currently collected and stored inconsistently. We created multiple dashboards, a database model, and a data entry form. We developed dashboards in ArcGIS and Tableau respectively. WEFTA is currently vested in ArcGIS, although they may consider exploring Tableau and a database management language, such as SQL, as more suitable options. Regardless of the software used, we recommend WEFTA display ten KPIs in the dashboard, including project location, costs, descriptions, and coordinators, as well as community population and number of healthcare facilities.

• This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.

Creator

• Brush, Andrew
• Doucette, Michael
• Lyle, Meghan
• Derrivan, Kristina

Subject

• Well-Being
• Project-Based Learning
• Water
• Computing

Publisher

• Worcester Polytechnic Institute

Identifier

• E-project-121323-200458
• 115124

Keyword

• Data Organization
• Dashboard
• Data Visualization
• Database
• Sanitation

Advisor

• Carrera, Fabio
• Solomon, Jeffrey S.
• Golding, Dominic

Year

• 2023

Center

• Santa Fe, New Mexico Project Center - IQP

Sponsor

• John DiRuggiero
• Gar Clark

UN Sustainable Development Goals

• 6 - Clean Water and Sanitation

Date created

• 2023-12-13

Resource type

• Interactive Qualifying Project

Source

• E-project-121323-200458

Rights statement

• In Copyright

Last modified

• 2024-02-08