IoT Based Smart Water Supply Monitoring App

The project is about developing a Power BI-based software application for a popular department that manages the water supply and sanitation across villages, districts, and states. They oversee the monitoring of water supply activities across the nation. They focus on integrated demand and supply side management of water at the local level, including the creation of local infrastructure for source sustainability like rainwater harvesting, etc.

They were keen to design and develop a business intelligence solution that can track enabling all households to have access to and use safe & adequate drinking water within premises to the extent possible. They were keen to have custom visualization reports and dashboards that could give them almost real-time information based on the input parameters as desired by users. They wished to track daily water supply, Chlorine level, and water pressure insights for each location and look at the average daily LPCD (litre per capita per day) of each household in each location.

They were looking for a business intelligence application that could consolidate data from each location and portray it as a single output. An application that can manage error logs of all IoT devices.

Our Power BI-based software application provides daily water supply, water pressure, water chlorination, and devices online/offline insights considering each household. We developed dashboards related to the water supply that got embedded in the website & multiple POC dashboards as per requirement for more insights on the water supply to villages.

Key Components of Power BI Application

• Tap water supply in households (country map)
• Tap water supply in schools/AWCs
• Tap water supply in priority areas
• Sensor-based IoT pilots
• Water quality