NouhanDoumbouya/Water-Access-Monitoring-Dashboard-Power-BI-Maji-Ndogo

# Water Access Monitoring Dashboard (Power BI) — Maji Ndogo A Power BI monitoring dashboard designed to support stakeholders and decision-makers tracking **water source improvement** work in **Maji Ndogo**. The report focuses on **project progress**, **spending transparency**, **budget monitoring**, and **drill-down analysis** across geographic levels (national → provincial → town). --- ## What This Dashboard Answers This project was built to provide clear visibility into: - **Current project progress status** - **Total expenditure to date** - **Spending breakdown by location** - **What funds have been used for** - **Budget forecasting** (whether allocated budget will cover project completion) - **Potential cost reduction areas** - **National / provincial / town-level views** - High-level insight into what field teams are doing on the ground --- ## Demo / Evidence Choose one (or include both): - **PDF Export (recommended for quick review):** `alx_power_4_1.pdf` --- ## Key Skills Demonstrated - **Power BI data modeling:** multi-table relational model for analysis-ready reporting - **Interactive dashboards:** slicers, drill-down, and stakeholder-friendly navigation - **KPI tracking:** progress and cost tracking using KPI visuals - **DAX measures:** cumulative/running budget and cost measures for time-based monitoring - **Reporting for decision-makers:** clear visuals structured around stakeholder questions (status, impact, budget, accountability) --- ## Core Features (What Reviewers Should Look At) ### Monitoring & Finance KPIs - Progress tracking visuals - Total spend vs. budget tracking (including running/cumulative measures) - Spending breakdowns by geography and category (as designed in the report) ### Drill-Down Reporting - National overview, then drill into provincial and town-level insights - Filters/slicers to quickly isolate areas of interest ### Transparency & Accountability - Clear breakdown of **where funds went** and **what impact is bein …