Optimizing Store Assortment for Multinational Beverage Company

A global beverage company needed to strengthen product assortment as it rapidly expanded. Decisions were often based on intuition, which created inefficiencies—overstocking in some stores, understocking in others, and ultimately, lost revenue and market share. The Challenge - Reliance on manual, judgment-based decisions vulnerable to turnover - Disconnected data sources across regions - Limited tools for non-technical teams to manage complex assortment needs The Solution Compass Analytics delivered a low-code/no-code platform using Alteryx and Tableau to: - Standardize and integrate store-level data into a single, reliable model - Apply advanced clustering techniques to group similar stores and optimize product placement - Provide business leaders with clear, interactive dashboards for decision-making The Impact - Consistent, scalable, and data-driven assortment strategies across all markets - Empowered business teams to manage assortments without technical expertise - Improved revenue protection and market share resilience during rapid growth - A sustainable framework that ensures agility and continuity despite organizational change