Commodity Light +

•Dataset with pre-built data model with over 70 tables and determined relationships

•Over 90 calculated measures designed for commodity reporting purposes

•Data HUB with backups and audit trail

•Send data from Excel to Data HUB with just one click

•2FA implemented for all logins

•Different report roles for different users (FO,BO,Mid,Admin)

• Input data with Excel

Static data with entities, c.parties etc.

Deals

Consumption curves

Price curves

Market values

Settlement plans

• Create and refine data inside commodity system with PowerApps

Change deal status (FO->BO)

Create settlement price

Update deal information

• Export data back from reporting to Excel

• User guide for all functionalities

• Intuitive user interface

• All Power BI functionalities & more

Navigation

Slicer Panels

Drill Down

Drill Through

Conditional selections

Conditional formatting

Edit mode

Print mode

• Reports for all commodities with mutliple tailored pages

Settlement & Price

Hedges

Valuation

Volume

Credit Risk

Rate details

• Analyze data with dynamically calculated KPI’s

Hedge ratio

Mtm (Positive/Negative Gross)

Open Position

Averages

Rolling/Yearly figures

• Client colors, logos and fonts throughout report

• Summary reports for further reporting purposes

• Browser based reporting service

Flexible

Have a spesific way of calculating certain figures? All calculations can be implemented to our commodity system with ease.

Want to see a KPI’s in a certain way? Changing report visuals and slicer selections is quick and easy.

Cost effiecent

Big and stiff commodity systems are expenssive and require big integration projects. Our system is a more cost effiecent alternative with all needed functionalities and fast implementation within days.

Transparent project progress

We have customer oriented approach to projects. We publish our work immidiately to clients who’ll see the progress in real time. No ”black box” deliveries.

Integration with Excel and Power Platfrom

Our system can funtion as supporting tool for existing systems or stand-alone system with integration to PowerApps and Excel. We use Microsoft Power Platform to enhance and automate reporting.

References

Contact us to find out more about our references