Facebooktwittergoogle_plusredditpinterestlinkedinmail

Time Series Transformation for Oil and Gas Using TERR - Syntelli

Time Series Transformations For Oil & Gas

In this TERR tutorial, we will explore time series transformations often associated with oil and gas analysis.

Up to this point, we’ve only explored general use cases, now we get into some industry specific data and techniques.

For Oil and Gas, our focus is going to be public production data. We will explore techniques to combine data sets, manipulate text, and do some very industry relevant time series analysis all within TERR.

In short, we’re going to use a script to pull multiple oil production data sets via an API into TERR, use base TERR functions to truncate the output data to only return production data from peak output forward, and then normalize all the output data to be relative to our median output location.

We will transform this data:

TERR Oil and Gas 1

 

 

Into this data:

TERR oil and Gas 2

 

Data Sourcing

For the sake of easily accessible data, we are going to use oil field production data leading up to the recession in 2008. Fortunately, this data are in a similar exponential decay pattern seen in individual wells. The data are also available through online data api services, such as quandl.com, making it easy to access our data.

First things first, let’s grab some data.

Oklahoma:

https://www.quandl.com/api/v1/datasets/DOE/MCRFPOK1.csv?trim_end=2008-12-30

Utah:

https://www.quandl.com/api/v1/datasets/DOE/MCRFPUT1.csv?trim_end=2008-12-30

California:

https://www.quandl.com/api/v1/datasets/DOE/MCRFPCA1.csv?trim_end=2008-12-30


Download the entire tutorial below.

[button size=”small” color=”red” href=”http://go.syntelli.com/terr-time-series-transformations-for-oil-gas” ]Download[/button]


Learn this and more about TERR in our latest Ebook!

[button size=”small” color=”red” href=”http://go.syntelli.com/download-syntelli-terr-ebook-oil-gas-edition” ]Get TERR Ebook[/button]



Daniel-Smith
Daniel Smith

Principal Consultant
About Daniel: Using Business Intelligence platforms to bridge the gap between Advanced Data Analytics and the efficient effective principles of accounting, Daniel applies technology and mathematics to make business faster and smarter.

Daniel has managed solutions for diverse client sectors such as as advertising, military, insurance, and oil & gas. These solutions include Business Intelligence Platform management, online key performance indicator identification and tracking, to full predictive data model construction. Although the analytic solutions are often mathematically complex, Daniel’s presentation and academic background ensures any insights delivered by solutions are relevant and simple to understand.

Facebooktwittergoogle_plusredditpinterestlinkedinmail

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Posts

blog

Analytics For The ‘MAaaSes’: Solutions For A Competitive Edge

Managed Analytics as a Service (MAaaS) gives you valuable insights fast at a predictable price. In the era of ‘Big Data’, companies are eager to use data analysis technologies and procedures to gain valuable business Read more…

blog

Voice AI or Chat Bots?

Voice AI or Chat Bots was the subject of a very interesting dinner conversation recently! While significant cost efficiencies, particularly in call centers, will be driven by voice driven AI, chat driven AI should not Read more…

blog

Let’s Explore Big Data with Lawyers: Evidence Search Methods 101

The smoking gun. The needle in a haystack. Today’s tech-savvy attorneys need quick and efficient search methods to find key evidence in mountains of unstructured data. Otherwise known as Big Data, legal professionals may need Read more…

 

Login

Register | Lost your password?