Oil & Gas Dashboard

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.

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

Plugins and Scripts

• Switchable Dimensions (plugin)
• Animated Liquid Fill Gauge (plugin)
• Series with only data point in line chart (script)