What-If-Analytics on Trade in Tableau

The Commodity Trading Market deals with the commerce of commodities of any sorts, such as oil, soy, milk and cheese. With ERP-system Oracle JD Edwards and the Cadran add-on CTRM (Commodity Trading & Risk Management) an organization has the full ERP-solution that can help a trading company with these complex back-office processes. The contracts that often represent very high volumes – and therefore very high values – are entered into the system and then processed both logistically and financially.

Interactive Dashboard gives insight in mark to market

The commodities market can fluctuate significantly and always involves risks. Successful trading relies on the ability to predict changes in prices and exchange rates. The interactive Tableau dashboard in this blog shows how Tableau helps traders understand their financial position. With it, you can test scenarios, such as: what happens to my profit if the exchange rate to US dollars changes by 1%, or if the market price drops by 2%? The effects on the profit margin become immediately visible.

Minimize risk and maximize profit

By linking this dashboard with the CTRM tool, traders can manage and hedge their contracts, reducing risk and increasing profit.

There are, of course, many other factors that can impact the outcome, such as:

  • Interest rates
  • Exchange rates of other currencies
  • Market fluctuations
  • Even environmental factors like temperature and humidity

Utilize Machine learning

The analysis becomes even more powerful when considering the likelihood of different scenarios. Machine learning can help by using these factors in intelligent models, providing, for example, an accurate forecast of the most likely scenario.

For more information about our CTRM solution for JD Edwards:

Jelle Huisman managing partner

Jelle Huisman

Managing Partner