RRC Oil & Gas

Texas Production Analytics Dashboard

A full upstream analytics suite built from raw Texas Railroad Commission data — production trends, well activity, drilling permits, and operator performance in a single interactive view.

Back to Projects

Snapshot

Status: In Development

Stack: Power BI · SQL Server · DAX · Python ETL

Data: 2000 – 2026 · Monthly

Records: ~15M+ rows across facts

RRC Dashboard

Overview

Built directly from official RRC datasets, this dashboard surfaces macro production patterns — statewide oil and gas volumes, gas vs. oil balance, and well activity — while enabling drill-downs into operators, counties, fields, and drilling permits across 33 years of Texas upstream history.

Data Source

rrc.texas.gov · Data Sets

How to Use

1. Filter by year: Use the year slicer to focus on specific production cycles.
2. Read the KPIs: Start with total oil, gas, and active wells to understand scale.
3. Follow the trends: Use the time-series charts to spot structural shifts and inflection points.
4. Hover for detail: Tooltips expose exact values and help compare specific periods.
5. Navigate tabs: Switch between Production Trends, Field Analysis, Top Operators, County Map, and Drilling Permits for different analytical views.

Case Study

Show

Technical Overview

Show