Overview
When Nutricia, an international developer and manufacturer of Advanced Medical Nutrition products, needed a better systems for collecting and analyzing multi-product information, they turned to OpenBI, LLC to implement the Pentaho Business Intelligence Suite.
The Challenge
Nutricia employees had a difficult time collecting and analyzing information across product lines, time periods and geographies. The organization wanted a way to deliver common metrics through a web-based interface, and to automate manual data collection and integration tasks.
The Approach
Nutricia deployed Pentaho's commercial open source BI Suite to provide dashboard, data integration, and analysis capabilities. The Pentaho experts at OpenBI were able to deliver a complete data mart and dashboard solution in less than six weeks.
The Results
By implementing Pentaho’s open source BI Suite, OpenBI was able to provide a system that could effectively address Nuticia’s business and functional needs without the unnecessary expense of traditional proprietary software licenses or the overhead of deploying the physical hardware infrastructure typically required.
Benefits:
- The solution featured standardized web-based metrics and interactive OLAP analysis to allow business users to analyze key information at any level of detail.
- Nutricia was able to integrate its on-site Sage MAS90, Microsoft SQL Server data with the cloud-based implementation of Pentaho and the MySQL database on Amazon EC2.
- The Amazon cloud environment offered superior flexibility in pricing, capacity, and on-demand scalability.
