Improved customer convenience through Sigma’s web based reporting system.
The client has been a leading provider of information on crude oil and natural gas prices to customers, ranging from industrial consumers, marketers, oil and gas operators, investors, litigation support, etc. The client combines multiple data sources into a single repository system.
Due to the scale of the client’s information sources, the database exponentially grew to a size of more than 100 million records. Since, the client never organized the database, Pentaho’s reporting tool took 15-20 minutes to compile one report. However, conditioning the database to improve search results, while reducing the report compilation time to a few seconds was challenging. Adding to this, Pentaho’s pagination functionality was not serving the client’s business need. Therefore, this system could not give real-time information to the users, thereby impacting the business.