Data processing the whole team can run and maintain.
I modernize how our team prepares and analyzes program data. Four pieces of work, each with what it changed for the team:
The process that prepares our reporting tables had no documentation, and few on the team could read it. I directed AI agents to rebuild it, ran it on the real data myself and tested every step against the old output.
Identical results, explained in about 550 pages.
Many of us built these tables and checked every number by hand. They are now rebuilt from the raw data and checked automatically, in English and French.
The team’s time is freed for analysis and writing.
Much of our reporting relied on data exported by hand into spreadsheets. I connected our analysis tools directly to the database, so a report can be produced by a program from start to finish.
Less manual work, fewer chances for error.
I set up our analysis tools on the department’s cloud platform, automated our first report there, shared what I learned with IT and trained colleagues to use it.
Room for our largest data, and a first report much faster to produce.