Case study: Big Data Plaform

INDUSTRY
Energy, Oil & Gas
Challenge
The energy industry faces an array of challenges and in order to optimize their wind farms and turbines, they need tools and technology to measure performance, function, external data, and more. Our client needed a big data solution to enable better servicing and business decisions.
Solution
We created a “Big Data Platform” to address our clients challenges which includes real time data (from multiple data inputs), API integration into their ERP with failure codes, improved performance, enhanced data processing with new SAP HANA database and improved facility monitoring.
RESULTS
The Platform was able to reduce redundant processing, report times and data base size.
THE CHALLENGE
Renewable energy producers face an array of challenges from policy, regulatory, and market uncertainty, to lack of market access, and high operational and maintenance costs. In order to optimize their wind farms and turbines, they need tools and technology that allow them to measure, in real time, the performance, function, output etc. of the turbines while also taking into account external data sources including location and geospatial data, weather and forecasts, enterprise resource planning data (financial, purchase data, lease dates etc.), operational data, resource management etc. Our client sought a big data solution to optimize processing time, improve real time capabilities and intelligence about their wind farm, and enable better servicing and business decisions. Their challenges included:

  1. Multiple Data inputs
    • Operational SCADA data through PI
    • Financial, Contact & lease data from ERP (Enterprise Resource Planning Platform)
    • Asset & Maintenance data from EAM
    • Location & GeoSpatial data from ArcGIS
    • Syndicated sources like weather, OEM
  2. Massive Database (5.6 Million records and growing)
  3. Slow reporting and analysis
  4. Wind turbines failing or producing low energy not caught until opportunities lost
  5. No real time feedback or reporting
THE SOLUTION
To help overcome our client’s challenges, our ITHENA team created a “Big Data” platform. This platform was able to deliver real-time data from SCADA (Supervisory Control and Data Acquisition) / Sensors from Turbines and Windfarms. It also provided proactive identification of failure & low energy production. We provided API integration into ERP (Enterprise Resource Planning) for WO (Work Objects) creation with failure codes. To help with improved performance, we provided a solution for optimization of records within the database to reduce size for improved performance. Our solution also enhanced data processing with new SAP HANA database implementation. Lastly, our data platform improved facility monitoring with sensor technology.
THE RESULTS
The “Big Data” Platform we implemented for our client was able to achieve:
REDUCTION IN REDUNDANT DATA PROCESSING
BRINGING RECORDS FROM 500M TO 5.6M PROCESSED MONTHLY
92% REDUCTION IN REPORT TIMES
FROM 2.5 MINUTES TO 12 SECONDS
86% REDUCTION IN DATABASE SIZE
WITH HANA (SAP HANA) DATABASE