"Which?" conducts tests on over 4,600 products annually across 150+ categories, generating large volumes of complex data. Manual processes and spreadsheets meant staff were spending too much time on admin, and error-checking had become a formidable task. Partnering with Telefónica Tech, Which? implemented a low-code, scalable solution using Power Platform and Azure Data Factory.

The new system automates workflows, centralises data through Power Apps, and integrates with a CMS for online publishing. Staff can now monitor the test lifecycle in real-time, search historical product data, and generate insights for reporting.

This solution enhances visibility, reduces manual admin by 150 hours per month, and safeguards "Which?"’s reputation as the UK’s trusted consumer voice.

Highlights of the success story

150 hours saved per month through automation

Manual tasks have been significantly reduced, allowing staff to focus more on product research and expert analysis.

Real-time product lifecycle visibility

Teams can easily track the status of each test, search historical results and manage processes from one source of truth.

Seamless content publication

Integration with Which?’s CMS streamlines the process of making test results available to UK consumers.

Improved data quality and fewer errors

The centralised system removes dependency on spreadsheets, ensuring consistent, accurate and reliable test data.

Scalable, self-service architecture

The solution supports category-specific workflows and is flexible enough to grow with future testing demands.

What they say about us

    "Telefónica Tech quickly developed a PoC, which led to the full project. The project was delivered on time and within budget and has facilitated significant improvements in the end-to-end process, allowing "Which?" to focus on delivering value by reducing the admin burden."

    Martin Ogden - Head of IT and Corporate Systems, Which?