High Level Design

Overview

One of the most important aspects of the oil, gas and water production industry is monitoring and control. The wells should yield enough to meet the market needs, but also should not be overused to save those important resources for time of need. In addition, the maintenance of each site is very expensive and therefore, the up/down time of each well should be carefully reviewed.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

oil and gas dashboards - energy dashboards

Goals

Monitoring the oil, gas and water production in different countries and by different companies.

Objectives

  • Monitoring oil, gas and water production.
  • Increase production by understanding which wells, countries and companies do not produce enough.
  • Increase the production cost-effectiveness by monitoring the wells up/down time.

KPI Architecture

Objectives KPIs Measures Data Source
Monitoring oil, gas and water production total oil production Sum(Oil Production) Production Data
total gas production Sum(Gas Production) Production Data
total water production Sum(Water Production) Production Data
Increase production by understanding which wells, counties and companies do not produce enough. Average monthly production by company [Total production] / [Total production months] Production Data
Average yearly production by company [Total production] / [Total months] Production Data
Average monthly production by county [Total production] / [Total production months] Production Data
Average yearly production by county [Total production] / [Total months] Production Data
Increase the production cost-effectiveness by monitoring the wells up/down time. Average number of production months by county Average(Months Prod) Production Data
Average number of production months by well (drill-down) Average(Months Prod) Production Data
Average number of production months by company Average(Months Prod) Production Data
Well Count vs. Production Months count unique (wells) Production Data

Entities Relationship Diagram

oil and gas dashboards

Plugins and Scripts