katemwatu/public_dataset_relationship_tables

A Power BI data model built on public data from the Kenya National Data Archive, designed to surface equity-focused KPIs on fund allocation across counties, gender distribution, and special interest groups (youth, women, PWDs). # Kenya County Fund Allocation — Power BI Data Model A Power BI data model built on public data from the Kenya National Data Archive, designed to surface equity-focused KPIs on fund allocation across counties, gender distribution, and special interest groups (youth, women, PWDs). ## Business Context Public sector accountability depends on making complex fund data legible to non-technical stakeholders. This model turns raw, unstructured county data into a governance oversight tool. ## What I Built - **Star schema** with fact and dimension tables inferred from unstructured source data - **DAX measures** for equity KPIs: MCA distribution by gender per county, per-capita fund allocation by special group - **Drill-through pages** and dynamic slicers for county-level analysis - **Validation** against source documentation to ensure calculation accuracy ## Tools Power BI · DAX · Power Query · Star Schema Modelling · Kenya National Data Archive