SirYgee/Maji-ndogo-dashboard

# Maji Ndogo Power BI Project ### 1. Introduction The Maji Ndogo project is a nationwide initiative aimed at improving access to safe drinking water across five provinces: Akatsi, Hawassa, Sokoto, Kilimani, and Amanzi. The dashboard provides a data-driven overview of progress, spending, coverage gaps, and distribution of improvement projects. ### 2. Purpose of the Report * Monitor water infrastructure improvements * Evaluate cost efficiency * Analyze project reach * Support evidence-based decision‑making * Strengthen transparency ### 3. Goals of the Dashboard * Measure progress in water access * Visualize cost and project distribution geographically * Recognize provincial funding disparities * Compare cumulative cost vs. budget * Assess timelines and completion patterns * Identify high‑impact improvement types ### 4. Key Findings **People Helped:** 4M people have benefited. **Project Completion:** 22% completed, 78% remaining. **Basic Water Access:** 48% of the country has basic access. **Most Expensive Improvement Type:** Installing RO filters (~$10M+). **Cost by Province:** Sokoto holds the largest share (~32%), followed by Kilimani, Akatsi, Hawassa, and Amanzi. **Cumulative Cost:** $33.79M vs. $25.31M goal (33.51% over budget). **Water Sources Tracked:** 19,910 sources. **Geographic Distribution:** Strongest improvements in central and northern regions; weaker in the south. ### 5. Strategic Interpretation * Progress is measurable but insufficient * Certain provinces require urgent support * Overspending requires procurement reforms * Filtration systems are costly but necessary * More time and resources required to reach nation‑wide coverage ### Screenshot/demo example ### 6. Conclusion * The Maji Ndogo dashboard provides clear insights that support policy decisions, highlight disparities, and expose areas needing intervention. The findings guide prioritization, funding allocation, and long‑term planning to help the nation achieve universal ac …