OLAP Analysis of Water Formation Data

In the oil and gas industry, the available data regarding each well are very huge. With data and parameters are very numerous and complex, it is very difficult to analyze and process the data that will be used as a base of decision making. In this research, a technique used to process the data hierarchy formation water into an useful information. In this research, applications developed can analyze data from a wide variety of formats, such as in Excel format, txt, shp, and so on. This can be done because the data will be processed first into a standardized form before the display becomes information. Data processing is the process of ETL (Extract Transform Load), process metadata and processes OLAP (Online Analytics Processing). In this research we use a tool or software Pentaho. In addition, to display the information in the diagram we use the Weka stiff and java script. Results from the study showed that the technique we proposed this, then processing the data to be useful information is extremely easy. Similarly, to see the characteristics or create a footprint for each well in the form of stiff diagram becomes very easy and fast.