Go Green One tree
One life

Client’s Business Goals

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.

Key Challenges

The client was finding it difficult to visualize the business requirement into a unified report to get a consolidated view of all the locations. 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 Approach

Looking at the challenges faced by the client, SPEC INDIA followed the Time & Material process with the Agile approach to develop the roadmap and architecture of the product. We designed and launched the Power BI app in the app store, after identifying and researching various modern methodologies.

Our Solution

Our Power BI-based software solution 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.

We implemented the IoT infrastructure in pilot sites where each sensor device sends data to the Azure Cosmos database using local gateways available at the site, later used in the Power BI dashboards. These IoT devices are installed to get data of water supplied, pressure, chlorine value, water source depth, etc.

We used different layouts to consolidate data at different levels with a drill-through facility and page navigation functionality. With CosmosDB as the data source, a live dashboard has been created to monitor each site and its metrics.

Key Inclusions

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

Graphical representation of the progress of households with the supply of water

Status of water supply in districts, blocks, panchayats, villages

Status of households with tap water connection (as on date)

State wise villages with tap connections, villages certified

Tap water connection provided since the start of the mission

Status of tap water supply in rural homes

Government live dashboard/internal dashboard with KPIs

SLA Scorecards



Is a similar concept in your thinking?

If so, we are right here to assist you transform your idea into a software application

Let's Connect

Technologies & Tools

Microsoft Power BI
visual studio-cs
Visual Studio
HighCharts library

Our Process


Our detailed and accurate research, analysis, and refinement leads to a comprehensive study that describes the requirements, functions, and roles in a transparent manner.


We have a team of creative design experts who are apt at producing sleek designs of the system components with modernized layouts.


Our programmers are well versed with latest programming languages, tools, and techniques to effectively interpret the analysis and design into code.


Quality is at the helm of our projects. We leave no stone unturned in ensuring superior excellence and assurance in all our solutions and services.


We have a well-defined, robust, and secure launch criteria that offers us a successful implementation clubbed with detailed testing, customer acceptance and satisfaction.

Business Benefits

Better decision-making in enhancing water supply and water quality

Monitoring and management of water supply at all levels

Easy service and maintenance of IoT devices

Nationwide, district-wide, city-wide, and village-wide monitoring

Visually appealing dashboard and reports

Real-time information at one glimpse for all participants

Futuristic perception and insightful business decisions

Faster evaluation and better organizational efficacy


Looking for something similar?

Associate with us and transform your ideas into reality through software applications.

Let's Talk