Dates in the Oil & Gas industry data can be a little tricky.
Especially when aggregating data, such as production volumes, to a daily level, and trying to connect multiple tables with date columns.
Some tables, such as tank levels or production volumes, could be based on a Gauge Date (aka Report Date) since the data is measured, aggregated, reported or “gauged” on that date (today), but in essence it is yesterday’s data, or to be more accurate, it is the data for the 24 hour period that began yesterday at the contract hour (e.g. 6am) and ended today at that same time, or the Production Date.
Other tables could have actual dates, such as sales tickets, run tickets, operation logs, etc.
Continue reading “Calendar Table for Oil & Gas Data (Date Dimension)”