Unlocking $225K in Value with a Data Mart in the Energy Industry
Overview:
A recent client of ours,
an energy company, partnered with Brewster Consulting Group and tasked our team with building a
Well Data Mart for better management and review of their portfolio. The company operates hundreds of wells and PUDs;
their data was scattered across multiple systems and reports, making it difficult to detect discrepancies and optimize financial performance.
The Challenge:
The company faced three major issues:
-Fragmented Data Sources: Critical well-related data was housed in different systems, including OGSYS, ComboCurve, Monday.com, and others creating inconsistencies and blind spots.
-Manual Processes: Reconciling information was time-consuming, error-prone, and often overlooked.
-Hidden Financial Risk: Without a unified data view, invoices and payments tied to wells could slip through the cracks.
With more than
400 wells in operation, even small errors could result in significant financial losses or missed opportunities.
The Solution:
Brewster Consulting Group designed and implemented a robust data mart, a centralized, subject-focused data repository, using:
-SQL Server: A database platform that securely stores and organizes large volumes of data.
-SSIS (SQL Server Integration Services): A tool that moves, transforms, and integrates data from multiple sources into the data mart.
-Stored Procedures: Predefined sets of instructions that automate complex queries and calculations, making data analysis more consistent and reliable.
-Database Views: Virtual tables whose contents are defined by a query, simplifying logic and table joins across the organization.
Brewster worked closely with the client to build custom interest comparison views, a mechanism that compared ownership interest data in the Well Data Mart against multiple external sources. This allowed for precise cross-checking of well data and financial transactions.
The Results:
During analysis, Brewster’s system
uncovered a $225,000 discrepancy tied to just two wells. The data mart revealed that two invoices had been paid incorrectly, and the company was owed that amount back.
This example highlights the tangible financial benefits of centralized data management:
-
Financial Recovery: The company now can reclaim $225K.
-
Scalability: With over 400 wells to review, the potential for further savings is substantial.
-
Confidence in Data: Automated, reliable processes reduce human error and ensure decisions are backed by accurate insights.
In addition to uncovering the $225K discrepancy, the biggest gains are noted below:
- Our client did not have a system of truth. Brewster worked closely with leadership to not only build the Well Data Mart, but to define primary systems of record and align business processes to ensure data is making its way into all systems.
- After making business decisions on primary systems of record, Brewster pulled data together from multiple, disparate systems into the Well Data Mart.
They no longer have to spend hours or days writing queries to pull this data together.
- Brewster created numerous views for the company’s users. Though it is beneficial for them to have all of their data pulled together into the Data Mata,
they needed recyclable queries for users to access. The guess work of joining tables together or having to write queries is gone. The views can be used as a data source in reports, and our client can easily apply filters as needed based on immediate reporting needs.
- Brewster is currently working on
incorporating logging to display user adoption rates for the Well Data Mart.
- As shown with the invoice cost savings, the Well Data Mart can be used in conjunction with other data sets for comparison.
Client Perspective:
"We found that there were two wells that we were invoiced for, and we paid the invoices. We didn't actually elect into the wells, so there was miscommunication...we shouldn't have paid it. Now we're owed that money and that's $225,000 that would not have been caught if we did not have this data mart...and that's just scratching the surface."
-Director of Data Strategy & Optimization
At Brewster Consulting Group, we recognize that managing data can be a daunting task for small and mid-sized enterprises. Allow us to assist you in harnessing the potential of operational intelligence! Reach out to one of our specialists today to refine your data strategy, optimize your processes, and establish solid governance. Ready to cultivate data analysis and propel scalable growth? Your journey begins right here!









