Case Study: The Body Shop achieves 75% BI productivity gain and 3-month system delivery with WhereScape

Using automation software to increase development productivity

The Body Shop’s Indonesian franchise, running around 130 stores plus a local website, was struggling with disparate, hard-to-maintain data systems that hampered timely reporting of sales, stock, discounts and profits. To modernize information management and improve cross-department visibility, The Body Shop partnered with WhereScape and adopted the WhereScape RED Data Warehouse Automation solution.

WhereScape rebuilt a fully integrated data management platform (integrated with Microsoft SQL Server) that consolidated data, enabled real-time reporting and faster analysis of customer behaviour and inventory by store. Using WhereScape RED the team delivered a working system in three months (versus a 12‑month estimate), increased BI team productivity by 75%, and gained actionable, timely insights to improve stocking, promotions and profitability.

The Body Shop

Sutan Pati

Knowledge Management