JoyceAbache/maji-ndogo-part4-powerbi-public-dashboard

# Maji Ndogo Water — Part 4: Public Dashboard (Fund Transparency) Fourth project in a multi-part Power BI series on Maji Ndogo's water access crisis. This one shifts from internal analysis to a **public-facing accountability dashboard**, built to satisfy a real stakeholder brief: show citizens and an international funder exactly where water infrastructure money is going, while giving decision-makers the operational detail to act on it. ## The Brief The project sponsor requested a single dashboard that could serve two audiences at once: **As a member of the public**, I want to see: - How the project is going — which sources have been completed - How much money has been spent, where, and on what - Details specific to my own town **As a decision-maker**, I want to see: - Overall project progress and whether the budget will hold - A cost breakdown by location and improvement type - Where costs can potentially be cut - All of the above at national, provincial, and town level Rather than building two dashboards, the two user stories were merged into one, with room for drill-throughs where the decision-maker view needed more depth than the public view. ## Page 1: National Overview - **47.31%** of the population now has basic water access, **4M** people helped so far - **$33.79M** spent against a **$30.52M** budget — currently ~10.7% over - **22% project complete**, ~19,910 water sources still to go - Cost breakdown by province (pie chart) and by improvement type (RO filter installation vs. infrastructure repair) - Province selector for drilling into town-level detail ## Key DAX Measures Built The dataset didn't have pre-built fields for most of this — they had to be calculated as DAX measures so the numbers stay accurate under every filter combination (national, provincial, town, and date range) rather than being frozen calculated columns: - **`total_improvements`** — total project count, filtered correctly by town using `ALLEXCEPT` so a province selection does …