Creation of an SAP Data Lake archtecture and data visualisation

With the help of a dashboard, call-off quantities on framework agreements can be compared with the agreed scale quantities and prices and optimisation potential can be identified.

Challenge

  • An internationally active group wants to make better use of its purchasing levers and optimise volume discounts

  • The master contract data recorded in SAP and the associated call-offs are not yet meaningfully merged

  • There is no overview of the level of potentials at framework agreement level

Solution

  • Loading the data into a data lake, preparing and providing the data for visualisation

  • Creation of a dashboard with the involvement of relevant stakeholders to present the ACTUAL data in a comprehensible way

  • Development of algorithms to propose optimal scale quantities and prices

Result

  • Purchasing can quickly identify optimisation potential and implement it in contract discussions

  • The users get an overview of how they can improve their call-off behaviour in order to make optimal use of volume discounts.

Are you interested in your own use cases?

Challenge

An automotive company would like to visualise various market-specific data in order to create a Competitive analysis for the US market.

Solution

There will be a interactive and Flexible application, including of different maps with two different views implemented.

Result

Relevant markets are identifies, analyses and visualises. The dealer or the respective sales department have the possibility to compare the direct competition with their own product and to visualise the relevant data.