Discover the advantages of Power BI for tailor-made reporting

For demonstration purposes we use data from TFM (Treamo Finance Monitor – www.tfm-now.com), our solution for cash reporting and cash flow forecasting.

We will show you how easy it is to create individual reports with Power BI from scratch, starting with a blank page. Within just a few minutes, you will see where (geographically) the cash is, whether accounts are pooled or not, with which banks or bank group accounts are held and many more options how to visualize data in a very convenient way, as well as for the day-to-day work and for management dashboards.

We will also demonstrate how easy it is to share such reports within an organization and even with recepients not having Power BI installed on their computer or smart device.

In the course of the demonstration, we will (among other features)

• provide an overview of Power BI and how it can be connected to a wide range of different data sources,
• show you how to structure your data in Power BI using features to create additional columns with calculated values,
• demonstrate Power BI's brilliant geo-location features and provide tips how to reach optimal results using geo-information,
• show how to make the best use of a variety of chart templates, applying various filter options.

Data visualization has never been so easy.

Discover the advantages of Power BI for tailor-made reporting

Data from EMIRate (www.emir-ate.com), our EMIR reporting solution, serve as the basis for creating a Power BI report from scratch. Our webinar will demonstrate the various data visualization options while using preset elements, and how these elements can be modified with just a few clicks. You will be surprised how easy and intuitive it is to create a report, starting with a blank page, within just a few minutes.

In the course of the demonstration, we will (among other features)

• provide an overview of Power BI and how it can be connected to a wide range of different data sources,
• show you how to structure your data in Power BI using features to create additional columns with calculated values,
• show how to make the best use of a variety of chart templates, applying various filter options.

Identifying FX payments, hedging and monitoring FX exposures

Do you hedge and manage your group subsidiaries' FX exposures at group treasury level? Our tool facilitates the import and analysis of data from various sources. For demonstration purposes, we use data from TFM (Treamo Finance Monitor – www.tfm-now.com), our solution for cash reporting and cash flow forecasting. The tool can also interact with other data sources.

Once data have been imported, the tool will identify all cash flows in non-functional currencies at entity level. Since not every single cash flow in a non-functional currency is necessarily 'at risk', further parameters can be set to make sure that only cash flows that are 'at risk' will be selected for further analysis. Optionally, hedge ratios can be defined by currency pairs, on which the tool will calculate the necessary hedging demand for group-internal transactions. Transactions, e.g. forward contracts, can then be re-exported to a trading platform and back to the forecasting system which the original cash flows came from. Once set up, all this, as well as the regular monitoring of net exposures and the implementation of adjustments of already existing hedging transactions, can be done at the press of a button.

In the course of the demonstration, we will (among other features)

• present the entire workflow from the import / query of source data to the generation of output files
• show you how easy incoming data can be mapped to a table structure needed for the further analysis
• present a couple of really helpful Excel features (e.g. data tables, charting, etc.)

Transforming budget figures using individually definable parameters into a cash flow forecast, reconciliation with actual figures, generation of recurring cash flows, etc.

The treasurer's dream (and more often a nightmare): Take the budget, press a button and transform it into a cash flow forecast. The number of reasons why this will often not work is far higher than the number of reasons why it will work. Nevertheless, depending on your business and the framework defined by e.g. seasonality or other parameters, such a transformation is sometimes possible. But one little question still remains: How?

In order to cope with the related requirements and challenges, we have developed an Excel-based tool that facilitates this transformation by providing a parameter section that aims to represent at least the majority of rules that can be applied to transform a budget value into a cash flow or a series of flows, distributed over the following months.

A relatively easy task was the development of the part that helps generate recurring cash flows, also using various parameters, including mapping function, in case a calculated cash flow falls on a Saturday or Sunday.

On top and if necessary, free form series can be captured, e.g. for long-term projects with cash flows in multiple currencies.

If your system can also provide actual figures, you can import these and reconcile them with the forecast data.

The often cited 'press of a button' will ultimately generate files that can be imported into any cash flow forecasting or treasury system.

Are you expecting more? The icing on the cake? Then we will also show you our tool for simulations and scenario calculations. It is technically as convenient and flexible as the so-called 'Cash flow generator'.

In the course of the demonstration, we will (among other features)

• present the entire workflow from the import / query of source data to the generation of output files
• show you how easy incoming data can be mapped to a table structure needed for the further analysis
• present a couple of really helpful Excel features (e.g. data tables, charting, etc.)