One tree One life
India
Microsoft Power BI, Azure Cosmos DB, R
Water & Sanitation
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.
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.
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 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.
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
If so, we are right here to assist you transform your idea into a software application
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.
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
“SPEC House”, Parth Complex, Near Swastik Cross Roads, Navarangpura, Ahmedabad 380009, INDIA.
+91-79-26404031, 32, 33, 34 
[email protected]
“SPEC Partner”, 350 Grove Street, Bridgewater, NJ 08807, United States.
+1 908-450-9862
[email protected]
This website uses cookies to ensure you get the best experience on our website. Learn more
