Case Study – SAP Data Analytics & Insights

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.