Energy Markets Data Visualisation tool  Cost Advice - Energy Specialists

We built a HTML5 Data Visualisation platform for Cost Advice. Our solution allows Cost Advice to easily monitor trends in energy prices and generate personalised reports for their customers.

Business challenge

Cost Advice wanted a more efficient way to transform and visualise the key data they use within their business. They have used a data subscription service for a number of years to help them understand the detail of the Energy Markets and spot trends within the data.

Previously an individual had a daily task to take data from the service and manually add it to a shared Excel Spreadsheet. This spreadsheet included a number of graphs that gave Account Managers insights into market trends.

This manual process was labour intensive and didn’t offer the agility of reporting required by the business moving forward. In fact it was apparent that there was a lot more that could be done with this data. Cost Advice approached Magnifica for some help.

The solution

We worked with Cost Advice to fully understand the data available and came up with new ways to transform this into data that could be visualised.

Taking raw data from the Energy Markets we developed algorithms that calculate projections for 12, 24 and 36 month energy prices. The system generates the next 3 years price projections daily using that days UK Power Bsld (Electricity) and UK NBP Gas prices.

Data visualisations based on a number of filters and metrics can be easily generated and the graphs can be exported easily as images to be used in reports for customers.

Delivered using our Fibre Framework the system is securely hosted meaning all Cost Advice employees can access it via a web browser.

We automated the collection and transformation of data from the subscription service so when a user signs into the system they always see the most up-to-date prices available.

Also just in case Cost Advice need the raw data the system accumulates on a daily basis we delivered a simple data download tool that creates a spreadsheet containing the data.

Key outcomes

By continually sourcing and automatically transforming market data our solution provides Cost Advice with a competitive edge in terms of data availability and reporting capabilities.

Cost Advice no longer need to manage the data internally which saves them time. Account Managers can access and create new visualisations from any web browser - great for client meetings as you can save a graph for later!

The speed of access and quality of reporting has revolutionised how Cost Advice use this key business data to help their customers source the best energy prices.

Cost Advice - Energy Specialists Energy Markets Data Visualisation tool
What was previously a very manual task of importing and analysing data is now done automatically, saving hours of valuable time each month. Stephen Ball - Director and Company Owner

Bespoke Software Development Technical Consultancy Fibre Platform SSL .NET HTML5 Charting