The client is one of the global leaders in commodity and oil product negotiation and is recognised 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. It markets crude oil productions or company oil products and ensures supply to refineries and subsidiaries worldwide. It has its main trading hubs in Geneva, Houston, and Singapore.
They were keen to design and develop a business intelligence solution 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.
The client was finding it difficult to visualize the business requirement and move beyond the native chart capability of Power BI. They were looking to offer the best response to the imbalance of the oil chain and respond promptly to the increasing demand for energy all the while, globally.
Looking at the challenges faced by the client, SPEC INDIA followed the Time & Material process with the Agile approach to develop roadmap and architecture of the product. We designed and launched the Power BI app in the app store, after identifying and researching on various modern methodologies.
Our Power BI-based software application 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.
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 the 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.
Forecast line charts and range area charts
Range of years report
Customization based on axis, line, tooltip, range etc.
Range calculation by the custom chart
Our detailed and accurate research, analysis, and refinement leads to a comprehensive study that describes the requirements, functions, and roles in a transparent manner.
We have a team of creative design experts who are apt at producing sleek designs of the system components with modernized layouts.
Our programmers are well versed with latest programming languages, tools, and techniques to effectively interpret the analysis and design into code.
Quality is at the helm of our projects. We leave no stone unturned in ensuring superior excellence and assurance in all our solutions and services.
We have well-defined, robust, and secure launch criteria that offer us a successful implementation clubbed with detailed testing, customer acceptance, and satisfaction.
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