Volumetric reconciliation across terminals and refineries

Volumetric reports audited back to source across a network of terminals and refineries, then rebuilt in Power BI on figures that trace to their origin.

Sector

Oil and gas — downstream

Project type

Advisory and build

Practice

Energy commercial systems

Where it reached
  • People
  • Process
  • Information
  • Technology

Where they started

Volumes were reported across a downstream network of terminals and refineries, and the reports could not be relied on to trace back to where the numbers came from.

What we did

We did the advisory work and the build:

  • Review and audit. Reviewed the volumetric reports and audited them back to source, terminal by terminal and refinery by refinery.
  • New reporting. Built new reporting in Power BI on figures that trace back to their origin.

What changed

Volumetric reporting the business could stand behind: every figure traceable to its source, in one set of Power BI reports rather than a collection of spreadsheets.

Want a result like this?

Bring the situation you are in. We will tell you where we would start, and whether it is worth doing now.