Go Green One tree
One life

Project Overview

The project is about developing Power BI-based software applications for one of the global leaders in commodity and oil product negotiation. It is recognized for its expertise from Singapore to Houston, via Geneva and Paris. They are financial and logistics experts for the oil markets, with involvement in all international energy flows.


They were keen to design and develop a business intelligence application that can track the daily stocks of oil-related categories and forecasted values of stocks based on different parameters. They were keen to have custom visualization reports and dashboards that could give them almost real-time information based on the input parameters as desired by users.

Our Power BI-based software solution aims at providing detailed insight into daily oil stock values by creating custom visualization for Power BI. We have implemented a range area and line chart, in which the range area is shown for an average number of years that is dynamic and the line chart is for the current year.

Key Components of Power BI Application

  • Customizable visualization charts
  • Direct import from Excel files
  • Variety of range areas and line charts
  • Daily oil stock values

Core Features

We have created multiple custom visualizations as per the needs of the client in HighChart.js, by using the open-source library and offering features to change the parameters as needed, showing the actual and forecasted values.

Reports and custom charts can be generated based on a range of years input by the users, that are based on a drop-down list. Customization can be done based on axis, tooltip, range or any other parameter, as desired by the users. Unpivoted data is imported from excel files and then the range is calculated by custom charts without any need for a DAX or Power Query.

Key Inclusions

Forecast line charts and range area charts

Custom charts

Range of years report

Customization based on axis, line, tooltip, range etc.

Range calculation by the custom chart


Technologies And Platform We Use

Microsoft Power BI
visual studio-cs
Visual Studio
High Charts library

Business Benefits

The business gained the following benefits from our project solution

Better stock investments and decision making

Easy reach to certain customers for specific products

Boosted sales for a range of products belonging to a specific area, category etc.

Further reach to clients and potential buyers

Visually appealing dashboard and reports

Real-time information at one glimpse for all participants

Futuristic perception and insightful business decisions

Faster evaluation and better organizational efficacy

Enhanced decision-making for better sales tracking


Are you planning for a similar project?

Our consultants are here to hear all about it and provide you with an instant viable solution

Let's Discuss