Cost Advice

Mission

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.

Project

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.

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.

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.