"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.