Today, Grundfos is the largest pump manufacturing company in the world. Their mission involves providing safely managed water services to developing countries that are currently not on track to meet the United Nations Sustainable Development Goal on clean water and sanitation, specifically in Sub-Saharan Africa. Currently, Sub-Saharan Africa remains with low water coverage over the region at only 60%, which means that hundreds of millions of people are still left without accessibility to clean, reliable water sources. 5 UC Berkeley students driven by improving water access and having a positive impact spent the semester focusing on how to delve deeper into understanding the water pumps in these regions and using data driven analysis to gather information about how Grundfos should be allocating these water pumps in the future.

The general approach of this team was to analyze water usage and optimize water payment in Sub Saharan Africa using data-driven techniques, such as creating data visualizations on customer usage behavior, where pumps were located, and other such key information. Next, the team presented key insights in a Tableau dashboard delivered to the Grundfos innovation team, as well as created an interactive map on Carto to display population and pump density.

 Tableau dashboard

They used data analysis and visualizations to understand the distribution of water pumps and its efficiency, how it can be improved for the future, and how Grundfos might better understand the payment methods of its users to better fit their needs.

Ultimately, these findings will help Grundfos continue tackling UN Sustainable Goal #6, and help create a cleaner tomorrow!

*GitHub repo private to student team and teaching team 

Project by Calvin Chen, Camilla Nawaz, Nirmol Kaur, Shan Lu, and Ananya Raghavan