A global shopper insights programme, more than ten markets
From 20,000 lines of SPSS to a metadata-driven system
The programme had to change data platforms at short notice while still delivering to clients worldwide. A decade of SPSS logic, different in every market and held mostly in people's heads, was untangled into recode tables, naming conventions and documented derivations for the variables that matter most: category, brand and retailer.
Then came the automation. An R library turns those computations into functions the data operations team runs on its own. Weighting came in-house. Dashboards are now built at scale from structured metadata rather than by hand.
What changed. Stable datasets across markets, less load on analysts, faster and more consistent reporting, and room to build new products.
An analytics software platform, enterprise research accounts
Making dataset setup repeatable for large research clients
Each large client arrived with its own SPSS legacy and its own internal language, so setup was slow and every update carried risk. Datasets were rebuilt around clear derivations and naming conventions. The unwritten rules of data preparation became a stepwise guide new DP staff could follow. Success plans set out milestones, risks and ownership across DP, product, engineering and the client.
A set of diagnostic steps separated platform issues from data-structure issues, so the product team saw themes rather than the loudest client. A small R tool for cleaning metadata grew into a script builder that DP teams could run themselves.
What changed. Steadier high-risk accounts, more consistent DP output, a clearer product roadmap, and tools that are still in use.