About the Customer
Industry: Oil & Gas
The client is from the Sales & Marketing department of the world’s leading oil & gas company. This department leverages multiple sales & marketing dashboards to gauge current sales, forecasts, and comparisons between different parameters. Based on these dashboards, they can get a detailed insight into future trends. The technology being used is Microsoft Power BI.
Key Challenges
Power BI is a modern-day technology with almost all major functionalities embedded within. But there is a component needed for dashboards, not present in Power BI.
The needed component is supposed to portray the lower and higher range of area, with the current and forecast figures lying in between.
The team searched hard in the marketplace to get this component in Power BI but could not manage. They even tried to customize some chart options, search for paid options but could not find a matching solution.
Our Solution
Looking at the challenges of the client, SPEC INDIA helped the customer by offering them two solutions, with Power BI as the main technology, to showcase a variety of dashboards:
- Custom Built Chart
A chart with requisite details and format can be built with certain .js libraries available in the market like D3.js. It would be a customized option with complete control but the efforts to build this component and its integration with Power BI would be quite high.
- High Charts
The provision of using the High Charts component is available in the high chart library. The license must be purchased and there is integration effort involved to plot dimensions automatically and map with the high chart values. The main advantage of this option is the availability of advanced charts, which makes integration of high charts with Power BI much easier and effortless as compared to a customized chart option.
SPEC INDIA offered both these solutions to the client and the client chose to go ahead with the high chart integration with Power BI. Following are the key features so this solution:
- Element custom chart component effort
- Elegant / customizable look as compared to other options
- Offers more chart options in Power BI, to be included, if needed
Our team integrated the high chart component into Power BI so that it could be used for any number of dashboards as an individual component, not restricting it to a single use component.
Our team integrated the component with PBVIZ, npm and modified the visual.ts to adapt to the changes owing to the high chart library.
Showcasing these dashboards with the new component in the Power BI unit offered a lot of satisfaction to the client, since it showed what they needed.
Tools & Technologies
Business Benefits
- Required chart available as an inbuilt component in Power BI library
- Availability of needed information in the desired format
- Usage of the chart library in multiple dashboards
- Highly customizable and has the benefit of an external library