Case Study – SAP Data Analytics & Insights

Achieving a multi-dimensional data interrogation capability and business insight.

Read how Gauri helped Roper Rhodes Ltd, one of the UK’s leading independent suppliers of bathroom furniture and bathroom products to transform its business analytics capability from SAP.

The Goal

As part of Roper Rhodes’ initiative to take its analytics to the next level using the latest in technology, Roper Rhodes engaged Gauri as a trusted advisor to help them identify the appropriate technology and then help them in realising this vision. The mission was to implement a state-of-the-art analytics solution that would enable comprehensive, all-inclusive reporting for the business.

The Challenges

One of the UK’s leading independent suppliers of bathroom furniture and fittings embarked on a mission to implement a state-of-the-art analytics solution that would enable comprehensive, all-inclusive reporting for the business.

  • Maintaining data integrity while consolidating data from multiple sources involving:
    • ERP system (SAP)
    • CRM and store display system (Pepperi)
    • Warehouse Management System (Chess Emperica)
    • Inventory and Demand Management System (Slimstock)
    • Spreadsheets
  • Identifying appropriate visualisation tools for delivering the reports
  • Design of a staging area in SQL to feed into the Visualisation Tool and extraction of data with appropriate entity – relationships from the ERP system.

Our We Added Value

We were a trusted partner for Roper Rhodes from the start of their quest for identifying an appropriate analytics technology take their reporting experience to the next level.

Gauri architect worked as a part of the Roper Rhodes stakeholder team for the evaluation of various Analytics vendors and platforms and in finalising a platform – ThoughtSpot.

Once finalised, Gauri helped build the end to end solution architecture as a foundation for all analytics related initiatives, that included:

  • Design and build of data extractors from SAP ECC
  • Providing design for data extracts from other systems like CRM, Spreadsheets and Slimstock
  • Design and build of the SQL staging area to combine data from all the above sources logically
  • Integration with the visualisation tool – ThoughtSpot

Achieving Freedom for the business to query data as they please in a google-like fashion as opposed to having to use IT-built reports has been a great achievement of this delivery.

“It is astonishing.”

The accessibility of the data and the ability to interrogate it from so many perspectives represents an enormous step forwards.

If we can roll this out effectively, it will offer us significant insight.

William Steele

Operations Director, Roper Rhodes

Services & Technology

SERVICE OFFERED

  • Advisory – Choice of Analytics Platform
  • Technical Architecture – ERP Data Extraction, Staging & Consolidation Area, Integration with the Visualisation Tool
  • Business Value Realisation

TECHNOLOGY

  • SAP ERP
  • Microsoft SQL Server with SSIS ETL Orchestrator
  • Thoughtspot

Let's talk!

Drop us a line or two to tell us about your project and we'll be in touch.

12 + 2 =