Built To Last
By Mike Skeffington
Did you know that both the iPhone and EnergyIQ turned 10 years old last year? Remarkable, right? The iPhone continues to be one of the most innovative handsets available, and EnergyIQ celebrated our 10th anniversary in December 2017, and is still providing powerful data management solutions for E&P companies.
The iPhone is commonly considered the first ‘Smart Phone’. When the iPhone was released in 2007, the competition was tough, with companies like Nokia, LG, Motorola, and Sony. For the most part, those other companies couldn’t adapt fast enough to keep up with the pace of innovation, and have since failed, were acquired, or left the market.
EnergyIQ has also outlasted many other companies (you know who they are). We’ve made many innovations, a few of which are: implementing PPDM’s “What Is A Well”, blending multiple well version records into a single ‘Gold’ version of trusted data, providing the first Well Master solution specifically for E&P companies, automating MDM business processes, and implementing our patent-pending approach to building and managing the Well Hierarchy. Over the years, we’ve grown to provide a full suite of powerful applications, employ teams of people in three locations, and see our software being used across the globe.
Maybe more importantly, we’ve stuck to our original vision “To help E&P companies realize more value from huge volumes of information and to increase the return from massive investments in exploration and production”. These days we call that ‘Information Certainty’, which is the only way to have greater decision confidence and lower decision risk.
We started EnergyIQ in a downturn. Now, after a second downturn, we’re bigger than ever in all dimensions. EnergyIQ is built for the long haul, and we’re preparing for exponential growth in 2018. Will you join us on the incredible journey?
- Well Lifecycle Automation
- IQinsights Just Keeps Getting Better
- EnergyIQ Technical Forum 2018 Recap
- Meet The Team: Jacob “Jake” Yelton
- TDM Tips & Tricks: Create Custom Mappings to Load Spreadsheet Data into TDM
- Where Can You Find Us?
Well Lifecycle Automation
By Mike Skeffington
We hosted our first 2018 webinar in February. The topic was all about Well Lifecycle Automation and our new product release that expands on the IQlifecycle E&P Master Data Management (MDM) solution. We are also very pleased that Hunt Oil Company will be sharing the stage with us at the PPDM Houston Professional Petroleum Data Expo in April to present their Well Lifecycle Automation journey with EnergyIQ.
Why bother automating the Well Lifecycle? The Well Lifecycle is the collection of business processes that a company executes throughout a Well’s life – from planning to divestiture. There are many applications that are used across the life of a well for lease and title, planning, drilling, etc. A huge challenge for companies today is to know for certain that each of those applications has the current and correct data. Implementing a Well Master Data Management solution helps solve that challenge by synchronizing data across applications. Well Lifecycle Automation takes that one step further by institutionalizing the business rules used to create, update, and move master data across the enterprise. For example, when a well is ready for drilling, the Lifecycle Automation platform will create a record in the Drilling application and pre-populate with the correct Master data. This creates tremendous efficiency, reduces time and errors, and creates Information Certainty for analytics and dashboards by automatically synchronizing information across critical applications throughout the Well Lifecycle.
Some of the key new Well Lifecycle Automation enhancements include:
- MDM Configuration – This is really the heart of MDM Automation, and is completely configurable. This is where you define the business rules for your enterprise MDM. For example, you configure the rules that synchronize data between applications, which system is the source of record for a given attribute, system subscribers, attribute definitions, notifications and templates, and much more.
- Application Agents – An Agent is a small application that provides two critical functions: 1) it monitors enterprise applications for ‘Events’ (see below), and 2) it transfers data between an application and the Master Data Store in IQlifecycle to update and synchronize Master Data. We have developed a number of Agents for applications such as Landmark’s Aries™, Peloton’s Wellview™, IHS Market’s Kingdom™, AFE Navigator™, LMKR’s Geographix™, and many other enterprise applications.
- Event Monitoring and Management – The Agents monitor for events that occur in critical applications that cause master data to be created or updated. A simple example is when a Spud Date is established in WellView, that needs to be stored in the Well Master, and the Master Well Status needs to change to ‘Drilling’. The IQlifecycle solution is monitoring for these types of events across all your critical applications.
- MDM Event Queue – Once an ‘Event’ happens, the Agent is configured to write specific information to the MDM Event Queue. The IQlifecycle MDM solution, including the Agents, are monitoring the Event Queue for events of ‘Interest’ as defined in the MDM Rules Configuration.
- Notifications – IQlifecycle can be configured to send alerts, emails, text messages, and more based on the Event that has occurred. For example, when a new well is created, the solution can send an email to the asset team.
IQlifecycle and Well Lifecycle Automation continue to be of extreme interest to both new and existing customers. We continue to invest a great deal of our overall research and development to enhancing IQlifecycle, and helping our customers realize more efficient and effective business processes, enabled by more certainty in corporate well information.
IQinsights Just Keeps Getting Better
By Jimmy Kirk
While we’ve introduced several features over the last year for IQinsights, the core of the product has not changed. Sub-second searches and aggregations across hundreds of millions of records and several data types is the engine behind the scenes. We’ve spent the last few development cycles revising workflows and extending the imagination of what we can do with the performance of IQinsights.
For example, one workflow improvement the new feature has is to upload a text file of UWIs or E-keys or simply pasting a list of values into a textbox. This allows users with areas or wells of interest to simply pull that data and all associated data with those wells into a list which they can then refine using the bucket filters in IQinsights.
Using the raw speed, API and report engine from IQinsights, we have been able to combine multiple data types inside visualizations. In our new wellbore viewer, we are able to combine a survey and stations along with completions, production information, formation picks, well tests, perforations and pressures to provide a detailed look at the wellbore(s) of a well.
Lastly, we have expanded the functionality to capture data from TDM’s well lifecycle automation solution IQlifecycle. By capturing this data in IQinsights, a user can visually represent the status of all wells, a set of wells or individual wells using roll up dashboards, such as our Well Lifecycle Dashboard or our Production Finance dashboards. We will continue to evolve.
EnergyIQ Technical Forum 2018 Recap
We just wrapped up our 5th annual EnergyIQ Technical Forum on March 6th, that was generously hosted by Apache Corporation in Houston. The Technical Forum focused on strategic plans and technical direction for EnergyIQ’s Trusted Data Manager (TDM) platform and our family of solutions: IQlifecycle, IQgeoscience, and IQinsights. The event was extremely well attended.
Topics covered this year included:
- Data Exchange Architecture
- Master Data Management and Workflow Automation
- Data Visualization and Dashboards
- Big Data and Data Warehouse
- Data Quality and Data Governance
- Emerging Technologies
- Cloud Computing
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 2019, and keep your eyes peeled for more information via email. Better yet, call us for the details.
We hope to see you at next year’s EnergyIQ Technical Forum!
Oh yes – and save the date for the EnergyIQ Rendezvous, our annual user group meeting, scheduled for October 2-3, 2018, in Houston TX.
Meet The Team: Jacob “Jake” Yelton
Jake joined the EnergyIQ team in September 2017 with experience in geospatial research and analysis spanning numerous GIS technologies: remote sensing/collection, image processing/extraction, field surveying, Python geoprocessing automation, and land management cartography. From a primarily public-sector background, Jake welcomes the change of pace at EnergyIQ. Interpreting the world as data is his passion, both personally and professionally.
Jake grew up in Wyoming’s Big Horn Mountains and remains to this day an avid and passionate mountain sportsman. He is convinced that powder skiing is the last vestige of true happiness in the modern world. Ski mountaineering, alpine climbing, and the occasional bike trail tide him over in the “off season.” Jake’s faithful sidekick Max–a 6-year-old English Springer Spaniel–generally works from home but visits the Littleton office from time to time.
TDM Tips & Tricks: Create Custom Mappings to Load Spreadsheet Data into TDM
When necessary to map data from tabs in a spreadsheet format that you have not yet loaded into TDM, upload the spreadsheet into a Loader Working Session, checkmark the spreadsheet and click the Mapping button to bring up the Spreadsheet Mapper.
For spreadsheets that are similar to others already loaded into TDM, choose a nearly matching mapping from the Excel Mapping droplist, and Save before clicking the Mapping button, and select Create Copy.
The TDM Spreadsheet Mapper can build a completely new mapping suited to the format and content of most spreadsheets or can customize a copy of a similar mapping applied to the spreadsheet.
Define the spreadsheet format in each spreadsheet tab – note the rows:
- to be skipped
- with column headings
- where data begins
The Well_header tab in this spreadsheet fits the default mapping model of headers in row 1 and data starting in row 2. However, the Stations tab has survey header data (in green) above the station detail in rows 1-13, so use the Worksheet Advanced Settings to define column headers in Row 14, and data starting in Row 15.
It is possible to connect more than one staging table with a tab, but not to use the same staging table more than once across the entire spreadsheet with all its tabs. The Mapper will identify all tabs as eligible for mapping, whether or not you choose to map those tabs’ data.
In each spreadsheet tab, select the staging table(s) from the Add Staging Table droplist to define where the Mapper will load tab data. Each time you select a staging table, before making any changes, click (Automap) to evaluate which spreadsheet columns headings already match with staging table columns to jumpstart the mapping process. Accept those that match and represent the same data attributes. The Mapper will allow you to define or default the others.
In the example above, the Stations tab has been defined to map survey header data (in green on the spreadsheet) to the STG_WELL_DIR_SRVY table and the three columns of survey station data to STG_WELL_DIR_SRVY_STATION. Since the spreadsheet does not provide Units of Measure (UOM), use the Defaults menu at the right to set the UOM in STG_WELL_DIR_SRVY_STATION for each value, to set the Source, and define the survey UWI as the government_id provided in the Well_header tab.
Select STG_WELL_DIR_SRVY from the Staging tables droplist to define the discrete addresses of the spreadsheet cells containing those values. Using the droplists next to each value in the Defaults column, select “Sheet Value” and specify the column and row location for each value. For Worksheet Column Name, select the value in the headings column defined at the start of the mapping process – Row 14.
The end result of these mappings is as follows:
To set STG_WELL_HEADER mappings highlight the Well_header tab to see what columns have been mapped by the Automap. UWI must be defined, so map WELL_LEVEL_TYPE to LEVEL_TYPE, and the Government_ID to UWI using the droplist so that Loader’s target mappings will match that UWI to an Ekey during processing.
Use the binocular View Icon to preview the mapping and ensure that values will map appropriately.
If you are satisfied, click Save, and if this is a modification of an existing mapping, click Apply. Once you apply a mapping to a spreadsheet, those settings will be used each time that spreadsheet is loaded.
For additional information about creating Custom Mappings 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. We’d love to see you!
- April 5, 2018: PPDM Data Management Luncheon, Midland TX
- April 11, 2018: PPDM Data Management Luncheon, Oklahoma City OK
- April 17 – 18, 2018: PPDM Houston Professional Petroleum Data Expo, Houston TX
- April 24 – 25, 2018: DUG Rockies Conference, Denver CO
- May 8, 2018: Denver Energy Tech Showcase, Denver CO
- May 9 – 10, 2018: ESRI Petroleum GIS Conference, Houston TX
- May 22 – 24, 2018: PNEC 2018, Houston TX
- May 30 – 31, 2018: Data Driven Production Conference, Houston TX
- June 5, 2018: PPDM Data Management Workshop, Oklahoma City OK
- June 12 – 14, 2018: Global Petroleum Show, Calgary AB
- July 23 – 25, 2018: URTeC 2018, Houston TX
- July 26, 2018: PPDM Data Management Luncheon, Houston TX
- August 15, 2018: PPDM Data Management Luncheon, Denver CO
- October 17, 2018: PPDM Denver Data Management Workshop, Denver CO