Tableau Forecasting in Operational Purchasing

Challenge

• The buyers of a railway company want to be able to guarantee a quantity to the suppliers by analysing the historical and forecast call-off quantities of a material number in order to obtain a better price and ensure security of supply

• The aim is to develop a dashboard to reduce the manual and non-standardised effort of data compilation for award preparation

Solution

• Aggregation and analysis of actual material consumption values

• Linking of the actual values for material consumption with the requirements planning on the basis of the material number in order to calculate the target values.

• Carrying out data quality checks and creating KPIs

Result

• Provision of actual data based on material (master data, consumption volume/behaviour, order prices, acceptance locations, allocation, framework agreements (expiry date, supplier, scales, MC)

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.