24/7 Data Analytics

Kantar Worldpanel is the world leader in consumer knowledge and insights based on continuous consumer panels. Running for over 60 years, their services cover 60 countries directly or through partners, delivering market monitoring, advanced analytics and tailored market research solutions in fields as diverse as FMCG, impulse products, fashion, baby, telecommunications and entertainment. Kantar Worldpanel is part of the Kantar Group, a division of WPP.

Kantar Worldpanel were looking to address scalability and supportability issues within their data layer. They needed a solution that was able to dynamically produce data schemas at scale while supporting all the existing (Microsoft-based) MDX queries powering thousands of dashboard designs. The solution required would need to scale across multiple servers and multiple instances of icCube. They needed a full load test across a broad sample of complex MDX queries.