Pells09/Transparency-in-Tracking-Maji-Ndogo-s-Water-Funds

# Transparency-in-Tracking-Maji-Ndogo-s-Water-Funds # Overview The *Maji Ndogo Water Project* focuses on improving access to clean and reliable water sources across the country through transparent tracking of public funds. This Power BI project visualises the flow of resources, project progress, and spending efficiency to ensure accountability and informed decision-making. The dashboard empowers: 1. Citizens – to see how and where funds are spent. 2. Decision-makers – to monitor project progress, costs, and identify optimisation areas. # Process 1. Data Preparation 2. Modeling & Calculations 3. Visualization Design 4. Interactivity # Insights * *Project Completion:* The Maji Ndogo National Water Improvement Project achieved *100% completion*, successfully upgrading all identified water sources across five provinces. * *Water Access Impact:* The initiative improved *basic water access for 18.36 million citizens, bringing overall accessibility to **100%*—a major milestone in reducing water scarcity. * *Budget Performance:* The project expended *$154.49M* against a planned *$146.74M, representing a **5.29% overspend*. The cost overrun was mainly driven by remote operations, longer project durations, and high logistics costs in rural regions. * *Provincial Cost Variations:* * *Sokoto* and *Kilimani* recorded the *highest costs per project*, largely due to difficult terrain and extended travel times. * *Amanzi* and *Akatsi* provinces demonstrated the *most cost-efficient performance*, completing projects faster and under tighter budget control. * *Vendor Performance:* Vendor costs ranged between *$12.6K and $15.2K per completed project*. Teams like *Wolof Plumbing Co., **Taita Tap Installers, and **Turkana Water Tech* demonstrated strong efficiency and reliability, while vendors in rural Sokoto and Kilimani faced unavoidable logistical cost spikes. # Recommendations 1. *Enhance Cost Forecasting Models* Future budgets should account for *geographical and lo …