Analytics Solution for Well Master Data for a Premier U.S. Oil and Gas Operator

The Challenge

The lack of a single view of well data can lead to delayed projects, underutilized production capacity, missed revenue opportunities, runaway costs, and regulatory noncompliance. Our client was struggling to create a unified view of their well master data. Data existed in Excel spreadsheets used by the engineering team for analysis. As the team grew, it was necessary to create a central data store of master well information populated from internal systems and augmented with publically available well data.

The Solution

We partnered with our client to implement SQL Server Integration Services (SSIS) to import data into a Microsoft Enterprise Data Warehouse (EDW). Industry data from IHS was implemented, which included well header data, well production data, and well test data. Formation data from the North Dakota Industrial Commission (NDIC) was imported as well.

The solution we provided regularly refreshed the data and merged it with internal sources. Our client’s engineering team was able to rely on a consistent and unified source of well data that could be exported from the data warehouse for analysis in TIBCO™ Spotfire©.

The Result

Our client gained a single and accurate view of well data that was consistent and unified, which provided authoritative master data for operational and analytic uses. Internally produced data and publicly available data from IHS and NDIC were able to be merged, allowing a consolidated view.