Operations Grant Database
An Excel and Power Query data platform that unified fragmented grant sources into a reporting backbone with 45+ interconnected pipelines.
Real data systems built around operational work.
These projects began with the problems every data analyst is familiar with: scattered information, manual workflows, and error-prone reporting that stymied leadership decisionmaking. This page showcases some of the work I've done at the Arizona Department of Education.
Selected work
Search by project, tool, or theme. Open a card for the problem, approach, and outcome.
Grant Application Dashboard
An Excel dashboard system integrating 24 grant programs so leadership could see application volume, status, and trends in one place.
Grant Evaluation Workflow Automation
A Power Automate Desktop and JavaScript workflow that extracted evaluation data from a legacy web system and eliminated roughly 320 hours of manual work per run.
Title I Comparability Evaluation
A Power Query rules engine that translated federal and state policy into a repeatable Title I comparability review workflow.
School District Boundary and Census Analysis
A QGIS workflow that reconstructed dissolved Arizona school-district boundaries and prepared corrected files for Census reporting.