About this dashboard
A working demonstration of what an oil and gas operator's leadership team can see when the operational and financial systems are joined properly, rather than reconciled by hand once a month.
What it shows
Production and uptime by field and by well. Revenue, realised prices and the cash netback bridge. Capital against budget, with AFE variance measured as spend against per cent complete rather than spend alone. The balance sheet, borrowing base, hedge book and reserves. Headcount, fully loaded labour cost per barrel, safety and flaring.
Past, present and forward: twenty-four months of history, the closed month, the month running now, and a nine-month projection that shows its own assumptions.
The data
All of it is synthetic and generated. 187 wells across five fields, 3924 well-months over 24 months, drawn from 7 modelled source systems. No real operator, well, employee, price or contract appears anywhere in it.
It is deterministic — the same calendar month produces the same numbers on any machine — and it moves the way an oilfield actually moves: hyperbolic decline, gas-oil ratio drifting up with age, water cut rising faster, completions overrunning more often than drilling does.
How it is built
Every headline number is computed from the well-month rows the tables are drawn from. None is typed in. A test suite re-derives each headline independently from the underlying rows and fails if the two ever disagree — so the dashboard cannot quietly drift away from its own data.
The charts are SVG rendered on the server. No chart library, no CDN, no third-party script. The page draws identically with JavaScript switched off or a corporate proxy in the way, it prints correctly for a board pack, and there is no outside party who could see the data.
Read-only throughout. There is nothing to submit and no endpoint that writes.
Why the joins are the point
The charts are the easy part. The reason an executive cannot get cost per barrel on a Tuesday is not that nobody can draw a bar chart — it is that the barrels live in production accounting, the dollars live in the ledger, the ownership percentage lives in land, and none of the three agree on what to call the well. That crosswalk is on its own page, because it is the actual work.
Built by Mayank Roy. A second demonstration applies the same approach to accounting operations.