Power BI Dashboards — 1,953 DAX measures across 8 models
BCHPR · clinical, operational & executive reporting · 2023 – present
Production Power BI estate with 8 major semantic models totalling 147 tables and 1,953 DAX measures — underpinning clinical decision-making, operational tracking, and executive reporting across every BCHPR research programme and the Admin Team Request Management System.
Highlights
- WAVE 11 DASHBOARD — 29 tables · 427 measures · bilingual cultures (en-US + fr-FR, 284 translations); TB care cascade from Screening → Eligibility → Specimen → Lab Results → BAC+ → Treatment Initiation.
- GHIT FL2 DASHBOARD — 21 tables · 763 measures; the largest semantic model in the estate, covering dual-country diagnostic-accuracy study analytics.
- NPOC DASHBOARD — 18 tables · 276 measures; TB / asthma / COPD eligibility branching and LC-NAAT diagnostic comparison.
- CROSS-PROJECT DASHBOARDS — 19 tables · 233 measures; unified view across Xpert, Truenat, Pluslife, and Outcome Logs.
- INVENTORY MANAGEMENT DASHBOARD — 25 tables · 112 measures; Manager.io supply-chain analytics with COA, deliveries, inventory locations, write-offs.
- REQUEST MANAGEMENT DASHBOARD — 16 tables · 61 measures; stored separately under the Admin Team repo, powering the end-to-end Request Management System.
- VIRAL LOAD DASHBOARD — 8 tables · 55 measures; HIV viral-load pooled-testing monitoring.
- IMAGE QUALITY STUDY DASHBOARD — 11 tables · 26 measures; DICOM + AI score differencing across X-ray machines.
- PBIP (Power BI Project) format with TMDL source control — every model version-controlled and diff-reviewable.
- Row-level security and shared workspace architecture saving $1,000+/month in per-seat licensing; report turnaround cut from days to minutes.
Related projects
Designer & Lead Engineer
QR-Code Patient & Specimen Tracking System
Operational innovation deployed across 365+ primary health facilities and 25+ GeneXpert laboratories — now under active consideration by Cameroon's National TB Programme as national best practice.
Architect & Lead Developer
Request Management System — Power Platform End-to-End
Production-grade Microsoft Power Platform solution running the full lifecycle of financial and operational requests at BCHPR — submission, document validation, executive approval, payment, issue tracking, and reporting — built on SharePoint Lists, Power Automate, Teams Approval Cards, and a Power BI semantic model.
Architect
Inventory & Asset Management — Manager.io + M365
Manager.io-integrated inventory and asset-management system for CHPR logistics across multiple Cameroon sites — with Microsoft 365 ecosystem orchestration (Lists, Power Automate, Power BI) and automated procurement workflows.