Business Intelligence for ETRM - Improved Company Performance Metrics
Business Intelligence -BI for ETRM- Improve Your Companies Performance Metrics
Chances are your ETRM system provides inadequate reporting? Chances are that your company has had to build a “data warehouse” on top of your ETRM to support management and additional reporting needs. Chances are that this step has required significant IT investments.
A typical ETRM system provides limited reporting usually in a linear form. Information such as Profit and Loss (PNL) can be reported and perhaps drilled down; however, drilling down has its limitations (i.e., portfolio hierarchy to deal level) which limit a company’s ability to gain real insight into required information such as profitability from a top down perspective. This is where companies often find themselves extracting data to build reports to achieve the business results/metrics that management often requires.
Does your reporting infrastructure provide the following answers on an ad-hoc basis quickly?
- Which trader made the most profits for the last quarter compared with the same quarter of the previous year?
- Which customers yielded the most profits and which charges (i.e., commodity charge vs. other fees) were most profitable?
Transactional data contains a wealth of information that can help you make better, more informed decisions about your business. The process of analyzing your data for that type of information, and the data three dimensional (3d) views that result, are collectively called business intelligence (BI). The goal of BI is to instantly provide improved insight by offering a true multi-dimensional view of a portfolio thus lowering the time and money it requires to extract and manipulate required information for management needs.
The solution is an analytical processing -On Line Analytic Processing- OLAP database, a specialized database designed to help you extract business intelligence information from your data. The OLAP database contains cubes (3d views) that allow you to query and visualize the data in multi-dimensional ways. The OLAP cubes can be thought of as extensions of two dimensional array of a spreadsheet. For example, a portfolio management group may wish to analyze actual and forward revenue by product, time period, locations, marketers etc. This is very difficult to attain with linear reporting and even more difficult to slice-n-dice without OLAP cubes.
To find out how our ETRM solution bundles Business Intelligence (cubes) for improved company’s business insight, please contact us at Pioneer Solutions.