← Back to work projects

Grant Application Dashboard

An Excel dashboard system integrating 24 grant programs so leadership could see application volume, status, and trends in one place.

About this project

The situation

Application reporting was spread across programs and ad-hoc requests, making workload planning dependent on estimates.

What I built

I built the relational data model and reporting views in Excel, Power Query, and Power Pivot across 24 grant programs.

Why it mattered

Leadership gained current visibility into volume, status, and trends without waiting days for each custom report.