Each year, IWSR collects beverage data stored in thousands of Excel files from over 160 markets. These tend to arrive in different file structures and formats which requires team members to manually copy, match, and reformat data before taking a step back to analyse what they collected.
Read on to discover how CloverDX helped IWSR streamlined these processes...
The challenge: Making large volumes of Excel files easier to manageHandling thousands of Excel files each year created a workflow that was cumbersome, risky, and put strain on valuable team resources, specifically across the IWSR research teams. Additionally, the research team realized that this process had to change because manual tasks had become.
Off the back of this, the ISWR team wanted to overcome two main challenges:
To streamline their workflow and free up time for higher-value tasks, IWSR used CloverDX to simplify how they handle data from clients.
CloverDX Wrangler helped the team take all their different Excel files and turn them into a consistent format. Researchers didn’t need to write code—they could drag, drop, and map columns so the data was ready for analysis. No more spending time organising inconsistent spreadsheet data.
Time-consuming tasks, such as standardizing incoming files and matching data to the correct categories, were automated. CloverDX Data Manager then enabled automatic validation and reuse of past decisions, which freed researchers from manual work, reduced errors, and ensured a faster, more consistent data ingestion process.
David Green, Chief Technology Officer at IWSR says:
“Wrangler was key in allowing non-technical users to describe how spreadsheets were structured, helping us handle different formats reliably.”
- Sam Landers, Head of Product & Programs at IWSR
As one team defined the rules—how the data should look, how categories should align, and what validations mattered—the technical team ensured those rules were built into scalable pipelines that handled data in the right sequence. Together, they created a process where expertise and CloverDX automations worked hand in hand.
IWSR is the world’s leading provider of data and insights for the beverage alcohol industry.
Trusted by global brands, they collect and analyze data from over 160 markets to provide strategic intelligence, benchmarking, and trend forecasting.