“Bolser have exceeded our expectations on every front. They really spent time understanding our needs and the data. Overall they made the process so easy for us and are a joy to work with.”

 

Sam Bunis, Director of Brand, Marketing and Communications

How we did it

We designed and built a reporting platform that turns complex datasets into polished reports at the click of a button — powered by AI and built for scale

 

Key technologies
AI (ChatGPT, Gemini, Claude, CoPilot, Perplexity)
AI was the driving force from start to finish — helping shape the concept, cleanse and structure complex datasets, and accelerate development. It allowed us to prototype quickly, automate data flows, and integrate AI-driven logic throughout the reporting process.


Data & APIs (MySQL + Prisma, Fastify): Clean, reliable data pipelines and fast APIs to serve accurate constituency data at speed.


Frontend (TypeScript, React, HTML, CSS): Dynamic interfaces and layouts to generate consistent, data-driven report pages.


Automation & Output (Node.js, Puppeteer, Vitest): Automated generation and testing of all 543 branded PDF reports at scale.


This architecture lets the Football Foundation regenerate every report on demand as new data comes in — keeping everything accurate, consistent, and up to date.

Smarter. Faster. Scalable. 

What used to take weeks can now be done in a single run.

  • 543 reports generated automatically
  • £30,000 annual saving on design and production costs
  • Centralised platform to manage and regenerate reports at any time
  • Future-ready codebase that can plug into public websites

Because the reports are built as HTML/CSS pages, they can evolve alongside the Football Foundation’s future digital ambitions - no throwaway tech, just long-term value.

 

Pushing boundaries with tech and learning  

This project shows how we use practical AI to solve complex problems and unlock real impact for our clients. We combined deep technical expertise with rapid experimentation, using AI to speed up delivery and push the boundaries of what’s possible. The result? A scalable platform that gives the Football Foundation the power to tell their national story - instantly, accurately and beautifully.

The Results

An AI powered reporting platform that:  

  • Demonstrates the Football Foundation’s impact across all Parliamentary constituencies
  • Saves time & money - reducing production time from a month to 10 minutes
  • Scales to meet future data updates and reporting requirements
  • Enables powerful personalised storytelling through data

This is what happens when technology, creativity and purpose align.