Access to reporting dashboard and carbon data reporting incorporating “Well to Tank” (WTT) conversion factors.
Oxera wanted to be able to view data reporting online to enable them to see their travel spend activity per Oxera business entity as well as gaining visibility of WTT carbon data reporting for the annual travel booked by the company.
The company desire was to ensure that both tailpipe emissions and the emissions associated with generating a fuel or energy vector were fully captured to enable a fair comparison of all technologies and fuels.
OUR IMMEDIATE RESPONSE
The first item on the agenda was to provide user access to the Oxera customer data reporting suite through PowerBI. Grant multiple user access as requested by Oxera, thus allowing the nominated users to view all travel spend data dashboards within the reporting suite.
HOW WE SOLVED THE PROBLEM
In order to provide Oxera with a solution, I enlisted support from our data engineering team to develop the reporting suite to allow visibility of the powerbi dashboards. Additionally the next phase was to develop the reporting to incorporate WTT conversion factors in addition to the Defra calculations already provided as standard.
WTT conversion factors were sourced and used to reprogramme a bespoke edition to the carbon data reporting already in place. The WTT conversion factors change over time, therefore these need to be updated annually to ensure accurate reporting of Oxera carbon emissions moving forwards.
By providing the reporting access to Oxera, it has given them tangible access to their travel data through pre-designed reporting dashboards. Having this access also allows easy sharing of travel data and spend statistics within their business and also providing them with a facility to extract data at the click of a button.
In addition, by developing the WTT conversion factors within the carbon data reporting, it has now given Oxera full sight of the wider emissions outlay. As well at capturing the standard emissions from the business travel Oxera make, the great benefit of this for Oxera is that it now allows them to capture an average of all Greenhouse Gas emissions released into the atmosphere from the production, processing and delivery of a fuel or energy vector. Providing this comprehensive calculation of carbon emissions has allowed Oxera as a business to accurately report on carbon emissions based on their annual travel spend.
MORE CASE STUDIES
Partnered with Gray Dawes Consulting to identify realistic improvements across entire programme and achieve adoption through impactful change management initiatives and…
Our bespoke hotel booking systems and negotiated rate programme offer significant savings over well known, online and offline competitors. Explore these savings here …
The Club had diverse travel needs that varied from day to day business travel through to complex movements. Find out how we managed to go above and beyond for them …
JDX Consulting had no documented policy or defined process when it came to business travel. Find out how their decision to work with us ensured a seamless move to better travel …
Our task was to move the management of travel to a centrally managed process through while effectively managing costs, supplying a robust and comprehensive round the clock service …
ONLINE COST SAVINGS
Maximising travel savings through increasing online adoption. Gray Dawes identified opportunities for GAB Robins to make considerable savings by booking more online …
Red Bee Media wanted to consolidate their travel spend through a single travel management in order to maintain control and gain complete visibility of their travel spend …
On 22nd May 2017 Manchester became the subject of a co-ordinated terrorist attack which targeted a concert at Manchester Arena. Explore our processes which keep you safe …
Part of our Account Management service is to provide strategic ways in which cost savings can be identified and acted upon. We reviewed LEVC (manufacturers of the black cabs)…
Our initial key task was the management of the implementation of an online booking system for UK bookers and travellers within a very tight timeframe. Providing the necessary training to…
Our client has a diverse travel profile including overseas client visits, internal UK office travel as well as attending meetings and conferences. We maximised travel while maintaining spend …
Recently a travel booker of one of our clients encountered numerous challenges with their current supplier when trying to arrange travel for a student. Learn how we acted quickly …