Case study: Pricing process optimisation

Problem:

A leading local retailer was struggling to adjust prices quickly enough to respond to changing market demands. As a result, they were losing revenue by failing to price promotional goods optimally during critical periods like Easter and Christmas. This was a significant issue, as over 80% of their annual profits were generated during these promotional windows.

Solution:

We conducted a deep dive into their promotional pricing process and uncovered that the primary bottleneck was the fragmented nature of their data—spread across multiple operational and supplier systems. Analysts were spending up to 80% of their time manually collating, cleansing, and transforming data in Excel spreadsheets, severely delaying decision-making.

To address this, we designed and implemented an Enterprise Data Solution that automated data integration, cleansing, and transformation across systems. This ensured timely and consistent data availability. We then equipped the pricing analysts with a suite of tools to develop, test, and deploy pricing models, allowing for data-driven and agile pricing strategies during promotional periods.

Result:

• Year-over-year profitability during promotion periods increased by 25%.

• The pricing team reduced manual effort by 50%, freeing up time for strategic decision-making.

• The business gained agility in pricing, helping them stay competitive and responsive to market trends.