Mbashas/bataanno

Multi-country WASH Performance Dashboard — Water & sanitation analytics for Uganda, Cameroon, Lesotho, and Malawi with AI-powered insights, KPI monitoring, and exportable reports. Built with Streamlit. # Multi-Country Water Services Performance Dashboard **Comprehensive Water & Sanitation Analytics for Uganda, Cameroon, Lesotho, and Malawi** A powerful Streamlit dashboard empowering utility managers with data-driven insights for operational efficiency, financial sustainability, service quality, and equitable access. --- ## 📋 Table of Contents - Overview - Features - Quick Start - Default Credentials - Managing User Passwords - Data Dictionary - Key Performance Indicators - Project Architecture - Deployment - Security Notes - Contributing - License --- ## 🎯 Overview This dashboard enables water utility managers to monitor, analyze, and optimize water and sanitation service delivery across four African countries. It provides: - **Real-time KPI monitoring** with industry benchmarks - **AI-powered insights** using Google Gemini - **Multi-currency support** (local currencies + USD conversion) - **Role-based access** (Admin vs Country Managers) - **Exportable reports** in PDF and CSV formats ### What can you do with this dashboard? 1. **Monitor Performance**: View key metrics like Non-Revenue Water (NRW), Cost Recovery Ratio, Service Coverage, and more 2. **Compare Countries**: Analyze performance across Uganda, Cameroon, Lesotho, and Malawi 3. **Identify Issues**: Spot underperforming zones, payment risks, and service gaps 4. **Generate Reports**: Export data and insights for stakeholder presentations 5. **Get AI Insights**: Ask the AI assistant questions about your data --- ## ✨ Features ### Five Analytical Domains | Domain | Description | Key Metrics | |--------|-------------|-------------| | 📊 **Overview** | High-level KPI scorecard | 10 summary KPIs with benchmarks | | 🏭 **Production** | Water production operations | Production volume, Service hours, NRW | | 🚰 **Service** | Service quality metrics | Water quality, Complaints, Metering | | 🌍 **Access** | Coverage and equity | JMP ladder, Zone coverage gaps | | 💰 **Finance** | Financial sustainabilit …