Real-Time Retail Sales Analytics Across 12,000+ Stores

Background The Client Challenge

Our client is the local branch of a global consumer goods group a business operating in 180+ countries, serving roughly 800 million customers, and employing 55,000 people worldwide. This particular branch handles distribution for 150+ products through a network of 12 major retail partners, covering more than 12,000 individual stores.

Running a network that size meant dealing with a constant stream of retailer data, none of it arriving the same way twice:

• Every one of the 12 retail partners sent sales figures in its own format, on its own schedule, so analysts spent most of their time wrangling spreadsheets instead of analyzing anything
• There was no single place to see stock levels, sell-in volumes, and sell-out volumes together across the full network of stores and products
• Spotting a sales trend, comparing one product or store against another, or estimating where growth might come from all required pulling numbers together by hand
• Growth metrics that should have been simple like how a store's sales had changed month over month took real calculation time and were an easy place to make mistakes
• Sales and marketing staff had no way to explore the data themselves; any new question meant a new manual request

The company partnered with Versich bringing 10+ years of expertise in data analytics and BI services to design and build a unified data analytics solution that would process and consolidate all retail sales data and deliver advanced sales analysis capabilities across the full store network.