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.

Get Full Tutorial

Learn this and more about TERR in our latest Ebook!

Download


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

How To Export Google Analytics Data into a Data Lake: Case Study

One of our clients recently presented a unique and advanced analytics challenge. Through an innovative approach, the Syntelli team successfully implemented a simple, yet effective solution, to satisfy several other business requirements. Ultimately, the team Read more…

blog

How To Unlock Analytics Maturity in Your Organization: 3 Skills For Success

This is our third and concluding post in the series of achieving analytics maturity for finance and accounting professionals. Read the first part here, and the second part here. As seen in our Data Science Read more…

blog

How To Become Analytically Mature in Accounting and Finance – Part Two

Refer back to part one for intro to Reporting and Business Intelligence for professionals in Accounting and Finance. How to Become Analytically Mature: Data Science Examples of Tools Considered: SAS, RapidMiner, Knime, SPSS, Rattle

 

Login

Register | Lost your password?