The Challenge
Industry : Oil & Gas
A Texas-based Oil & Gas firm sought to consolidate its field automation and surveillance operations into a unified, real-time analytics platform. The goal was to transform raw, high-speed streaming data from remote oilfields into actionable insights. The client needed:
- Aggregated reporting from diverse field devices.
- Integration of streaming video and SCADA data.
- Performance optimization of large-scale data reports.
- SharePoint portal integration for field users.
- Real-time analytics across multiple devices and systems.
The existing reporting structure lacked scalability, responsiveness, and interactivity. Reports needed performance tuning and better visual representation of production and incident data. BPL was doing UPS Market Serve based on current buyers, Potential Buyers.
Scope of Project
- Tableau Integration with SharePoint portal
- Tableau Server Authentication via Active Directory
- Big Data Hadoop connectivity for historical and streaming data
- Dashboard development for production analysis, loss code, and gas metrics
- Post-implementation support and training for internal teams
Solution
The engagement involved a full lifecycle implementation and integration of the client’s oilfield automation platform with Tableau to enable real-time visualization and reporting.
Key Deliverables:
- Developed Tableau dashboards for:
- Oilfield production by location
- Gas production metrics
- Loss code and event analysis
- Integrated Hadoop/HBase as a data source to manage large-scale field data.
- Designed efficient data schemas to enable scalable and performant queries.
- Created calculated fields, sets, parameters, and filters for deep-dive analytics.
- Embedded dashboards into the SharePoint portal for centralized access.
- Configured Tableau Server with user management, scheduling, and security.
- Enabled drill-down capabilities for teams to investigate root causes of incidents or downtime.
Business Impact
- Enhanced Operational Visibility: Real-time dashboards provided on-demand insight into oilfield performance and incident trends.
- Improved Decision-Making: Event management and emergency response teams could make faster, data-backed decisions.
- Scalable Reporting Infrastructure: Big Data integration ensured that massive datasets could be analyzed without latency.
- Streamlined Access: SharePoint integration allowed easy access for distributed teams.
- Reduced Downtime: Early detection of production issues helped minimize revenue losses.
Technology Environment
- Visualization & BI : Tableau Desktop, Tableau Server
- Data Infrastructure : Big Data Hadoop, HBase
- Portal & Collaboration : Microsoft SharePoint
- Authentication : Active Directory