Automation and data quality
HEDB Submission Pre-Checker
Turned the Ministry's HEDB 2026 Data Dictionary into automated rules for all 44 datasets, 1,236 fields and 81 code lists. Files in SharePoint are checked before submission, and each data owner gets an email with exactly which rows to fix.
Built with Python, Office Scripts, Power Automate, SharePoint, Excel
View on GitHub





