Go Green One tree
One life

Client’s Business Goals

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.

Key Challenges

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.

Our Approach

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 Solution

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.

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



Do You Want To Make Data-Driven Decisions For Your Project?

We have helped a number of global clientele with our analysis and reporting services to drive better performance based on data

Let's Talk

Technologies & Tools

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

Our Process


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.

Business Benefits

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


Do You Need Assistance With A Similar Solution?

We are here to provide you with an opportunity to leverage our expertise for your project. Contact us right away!

Connect With Us