Data Management Is The New Analytics
By Mike Skeffington
Yes, you heard me right. How many companies are hiring data scientists these days? I visit companies almost every week, and almost every company I meet with has hired one or a “team” of data scientists. But I ask you, “What are those scientists analyzing?”, and “How do they know what to look for?”
Most data scientists, I find, are from outside the industry. The initial cry is typically “Just give me all the data”, and they will make sense of it. In most cases, more data is better, so it’s a good request. However, because “more data” means getting data from multiple sources, including external or partner sources, knowing how the data is related is perhaps the most important thing. When you’re getting wellbore data from one system, completion data from another, well logs from yet another, it’s absolutely critical to be certain which logs are tied to which wellbores, and which of those have completions, and which of those are producing. Only when you understand the data relationships can you understand why one producing entity is performing better than another. All the data in the world doesn’t tell you what you want to know, if you don’t know how the data is related.
EnergyIQ has been, and remains, singularly focused on managing E&P data, and identifying and establishing the relationships within the data. Using innovative technology and a proven approach to implement a well master with a systematic identification matrix across the enterprise will empower your analytics (data scientists) to generate certainty in an uncertain E&P world, leading to better decisions based on better data.
- EnergyIQ Rendezvous User Group and Innovation Forum
- 2016.2 TDM and IQexchange are Released!
- Automated Directional Survey Processing
- EnergyIQ Technology Forum – A Recap
- Meet The Team: David May
- TDM Tips & Tricks: New to TDM 2016.2 – A Quick Way to Manage TDM Performance
- Where Can You Find Us?
EnergyIQ Rendezvous User Group and Innovation Forum
By Mike Skeffington
Get ready for the most exciting EnergyIQ Rendezvous ever! Our 5th annual Rendezvous User Group and Innovation Forum is scheduled for November 7th – 8th in Houston TX.
This year we have more to show and announce than ever before! More guest speakers, more innovation, more demonstrations, more interaction, and more everything!
As always, this is a FREE event, so please save the date now, tell your colleagues, and plan to join us at the EnergyIQ Rendezvous User Group and Innovation Forum on November 7th and 8th. Please click here to register.
2016.2 TDM and IQexchange are Released!
By Mark Baden
We released version 2016.2 of EnergyIQ’s Trusted Data ManagerTM (TDM) application suite and IQexchangeTM real-time data exchange platform. These latest versions add a number of new capabilities, and extend existing features to provide customers with the confidence they have the best data available, in a central repository, for every user across the well lifecycle.
There are many enhancements to TDM 2016.2, too many to go into details here. However, one important area of focus for this is extending the power and usability of the TDM Loader functionality. The TDM Loader user interface was revised to help simplify complex workflows and make it easier for users to perform everyday tasks. We also added new and exciting features which are highlighted by the ability to create user defined mappings for spreadsheet uploads, as well as providing users the ability to configure Dropbox settings through a new user interface. The Job Results have been redesigned to make it easier to find and interpret how the loader is processing files, as well as moving the monitoring functionality to its own page. Now the users can easily assess how the loader is performing, and also gives them the ability to clean database tables to help improve performance.
Additionally, we’ve given TDM users the ability to access the Reference Data Management functionality from the homepage. This now allows non-administrative users to access and view the data contained there. Another addition in TDM includes extending the functionality of the Well Auxiliary tables by adding access to those fields through the Well Editor, and also the ability to set the source preference and aggregation rules for those well auxiliary details.
2016.2 IQexchange is an exciting new release focused on extending the data transfer capabilities from TDM to client software such as Openworks and Geographix. The number of transfer data types supported was increased to now include: Well Header, Legal Locations, Directional Surveys, Digital Logs, Markers and Completions. Another feature added to 2016.2 IQexchange includes the ability to transfer a well set that is defined by an Area Of Interest (AOI) or polygon. The AOI/polygon transfers can also be scheduled for daily updates after the initial bulk load. Enhanced logging and error handling was also added so users can more easily conduct investigations when needed.
Overall, the 2016.2 TDM and IQexchange releases are something that we are very proud of as a whole. Not only did we add exciting new features and improvements, but we also modified our development process in order to introduce feedback much earlier in the development cycles, and use that early feedback to create a higher quality product and improved user experience.
These new releases provide more power and flexibility enabling TDM customers to deliver more certainty in the data used to make critical decisions, and to drive more effective workflows. To review the press release, please click here.
To receive the release notes, or more information about these important new releases, please contact your account manager.
Automated Directional Survey Processing
By Reggie Vair
EnergyIQ’s WML and Pirls data loaders upload raw directional surveys from IHS into the TDM database. Each survey can contain hundreds to thousands of individual station measurements. The data that is contained in a survey portrays the path of the wellbore to a target formation, but the raw data is not instinctively useful to users.
There are two components to a well directional survey, the survey header and the survey stations. The survey header holds information about the well that the survey is tied to. It contains location values, reference coordinate system ids, magnetic declination, and details about the service company that performed the survey. The survey stations record the data of the survey. Each measurement records the format of inclination, azimuth, and depth with a reference to the well-origin point (surface location). The stations are typically spaced out every 25 feet. Each individual station represents a downhole measurement. While these data points do represent the path of the wellbore, it is not easy for a human to take the raw data and visualize that path. For this reason, EnergyIQ has automated the processing of these raw directional surveys in order to create a user-friendly view of the well path.
EnergyIQ’s TDM automatically takes the ‘raw’ station data provided by IHS and processes the values using the Minimum Curvature Method. This method is the most accurate method for calculating northing and easting offsets. After a survey has been processed, new records are written to the database with the XY offsets, lat/long offsets, and the newly derived TVD for each station in the survey. The new Cartesian format for the survey simplifies integration with mapping software and other data visualization packages.
The TDM Loader will also allow users to input directional survey data from proprietary surveys and even select to promote one trusted survey over another. At EnergyIQ, we strive to provide data in a format that facilitates day to day work. The automated directional survey processing is one of the newest platforms that achieves this task.
EnergyIQ Technology Forum – A Recap
By Debbie Draudt
The 4th Annual Technical Forum was held April 25, 2017 and was generously hosted by Apache Corporation in Houston. The Tech Forum focused on strategic plans and technical direction for EnergyIQ’s Trusted Data Manager (TDM) application suite designed specifically for E&P companies. The event was extremely well attended. Among other subjects covered, three key topics that gained much interest from the audience included:
IQexchange Adaptors: architecture and independence
IQexchange is becoming a hot topic for companies as they look to automate connectivity and data transfer between applications and a corporate data store. In the session, we showcased the new application adapters, and discussed the overall architecture and how the adapters are evolving to work independently of the IQexchange platform, creating a simpler environment for implementation and management.
IQinsights: the architecture, integration and use of data objects
IQinsights is a new and strategic platform that we have spent a lot of time developing in the past 9 months. This platform is like the marriage of Google™ and Amazon™. This new solution makes finding well data an instant success Any user can now filter through millions of records of information about Wells, Production, Well Logs, Directional Surveys, and more… all in less than a second.
Workflow Automation: new ways to enable workflow efficiencies
This innovative technology was demonstrated during the event. These new solution components will be critical to every Well Master solution, as you look to automate the data flow between applications, using events to manage notifications, data transfers, and data transformation. Steve Cooper provided a powerful demonstration of this new technology and how it is being deployed at several customer sites today.
We are pleased with the interaction at this year’s Technology Forum, said Steve Cooper, President EnergyIQ. It was exciting to spend a day with our customers and prospects discussing both needs and solutions to their data quality and data management challenges. More than ever, E&P companies need to leverage information across the organization to drive efficiency and reduce costs. This year’s theme was all about data integration and transformation, which are critical to any successful data management strategy.
If you were not able to join us this year – we missed you! We hold this event every spring, so mark your calendars for early April 2018, and keep your eyes peeled for more information via email. Better yet, call us for the details.
Meet The Team: David May
David May is new to the Client Support team as a Data Analyst at EnergyIQ. He has held several roles in the Oil & Gas Industry over the last five years at both large and small companies. His experience in being surrounded by data has led him to begin to pursue a Master’s of Science in Information Communication Technology with an emphasis in Database Design and Administration. He hopes to best leverage his oil and gas experience, data work, and education to help EnergyIQ drive better data management practices in the evolving oil and gas industry.
Prior to EnergyIQ, David was a GIS Analyst with IHS Markit and before that, a lead Geological Technician at a Denver oil and gas start-up. Outside of work, David is an avid road and trail runner with his highlight being both qualifying for and completing the Boston Marathon. Between marathon training, he enjoys getting to the mountains and spending time in Northern Wisconsin. Recently engaged, he is planning an August 2018 wedding.
TDM Tips & Tricks: New to TDM 2016.2 – A Quick Way to Manage TDM Preferences
The new TDM Monitor displays the size of specified internal TDM tables which are growing in size – possibly impacting performance, plus a delete mechanism TDM Administrators may use to reduce the size of these tables. Cleaning up interim TDM tables after large database loads or significant activity is now as simple as selecting the TDM Monitor icon in the TDM Home page information bar, choosing a table to reduce in size, and a timeframe from which to remove records.
The color of the bars indicates whether a table is below (green), within 30% (amber) or above (red) the established threshold by table (shown in the threshold line) that your TDM Administrator has configured for the TDM Monitor. Hovering on a bar will display the table’s current record count and configured threshold, and clicking a bar will populate the table name and any filtered timeframe into the Delete Table Data section.
Filtering Data for a particular timeframe will display an additional amber bar representing the filtered timeframe’s record count. It may be good practice to set date range standards for using the Filter and Delete sections so that you do not remove interim data newer than ‘X’ days ago that may still be needed to diagnose or evaluate ongoing efforts.
For additional information about managing TDM Performance and more, please contact us at 303.790.0919 or firstname.lastname@example.org.
Where Can You Find Us?
We’d love to see you in person. EnergyIQ will be attending and sponsoring many coming events. Some of them are listed here. Please come by and say hello.
- September 24 – 29, 2017: Society of Exploration Geophysicists International Exposition and 87th Annual Meeting (Houston TX)
- October 17, 2017: Denver Energy Tech Showcase II
- October 18, 2017: PPDM Denver Data Management Workshop
- October 23 – 25, 2017: PPDM Calgary Data Management Symposium & Tradeshow
- November 7 – 8, 2017: EnergyIQ Rendezvous User Group and Innovation Forum (Houston TX)