Energy Saving Management – Pentaho
Sigma’s web-based reporting solution, using Pentaho, helped in increasing portability, with over 5% saving in strategic analysis for a large energy company.
Client Challenge
Global generation of energy across various modules uses a big part of the database, making a large number of transactions every day. There were times when a heavy load on the database caused it to crash, hence abruptly terminating the data loading and fetching process.
Client Journey
Experts from Sigma worked closely with the client organization to design an Enterprise Business Intelligence Reporting Solution which enables real time information, to make data -driven decisions. The solution removed unnecessary caching problems in Pentaho Data Integration and, optimized the database and mondrian application for better performance., It also extracted data from JIRA and Google APIs and maintained heavy datasets of around 300 gigs. The next phase involves creating more reports and generating cubes for various sub organizations.