Cross-program reporting
How I built NeighborImpact's first agencywide KPI dashboard without a data team or a consultant.

No single place to look
There was no single place leadership could see every program's numbers. Each of our programs tracked its own numbers its own way.
That made the job less about migrating data and more about helping program directors define what to measure, then making it easy for about 20 of them to report it every quarter.
What I tried first
I tried dedicated KPI platforms and spreadsheet tools. None fit our budget or our mix of numbers and yes-or-no compliance items. About a third of what we needed to track turned out to be compliance items: simple questions about whether something happened.
The bigger lesson was structural. Form tools add new rows; they don't edit a grid in place. Once I stopped fighting that and designed around it, the whole thing got simpler.
What I built
- Guided quarterly forms in Microsoft Forms, one per program area, with instructions pulled from each program's own KPI documents.
- One data table in Excel, where every submission lands as a new row stamped with the quarter and year.
- An Excel dashboard that reads the most recent submission, so leadership can see every program's numbers in one place.
- A quarterly PDF report for leadership, formatted with AI to set specifications.
I built it in-house, using approved AI tools as working partners for the parts that would normally need a data analyst.
What it opened up
Once the pattern worked for KPIs, it worked for other things too. I've used the same approach for enrollment tracking, customer feedback and a Jotform tracker for the agency's 2026 to 2029 strategic plan, following every goal and initiative, with reporting through Excel and AI-formatted reports.
I also pitched this as a conference session for NTEN: How we built cross-program reporting in-house without a consultant.
