The Solution: Pentaho Business Analytics, Pentaho Data Integration
As a highly innovative and dynamic company, BOS relies on integrated business processes. The company therefore opted for the Pentaho business intelligence suite. Not only is it characterized by a wide range of enterprise features and a high degree of flexibility, the software also easily integrates with existing IT environments though its many interfaces. IT-Novum, as a Pentaho Enterprise Partner with extensive experience implementing the suite in both midsize and large companies, was an easy choice for BOS. Marcus Schablack, the head of the Application Development department, says this about the decision: “We chose Pentaho because it focuses on high-end business intelligence solutions. IT-Novum was the perfect partner for us because, in addition to their expertise in the area of business open source, they also have extensive experience implementing complex enterprise-level projects.”
Hitachi Vantara partner IT-Novum used Pentaho Data Integration and Pentaho Business Analytics to build a central management and reporting platform. A central evaluation and reporting component provides evaluations of BOS suppliers. From the aggregated data, ratings are automatically generated that support the purchasing decision-making process.
IT-Novum developed a Pentaho-based centralized management accounting and reporting platform for BOS, consisting of three components: a “project cockpit” for project-related data, an operations cockpit with over 30 metrics, and a system for supplier evaluations and reports.
Project Cockpit - A ‘project-cockpit’ component gives a central view of all project data resulting from the entire BOS product range. An ‘operations-cockpit’ component aggregates about 30 KPIs from BOS facilities. German headquarters uses the data for analysis and reporting on the status of its global production facilities. The project cockpit allows for a centralized view of all the data concerning BOS’ individual products. In order to integrate the company’s different data sources, their project database, SAP and Excel sheets, IT-Novum set up a data warehouse. With Pentaho, data across BOS’ various locations are loaded into the data warehouse and then aggregated into a consolidated data model. As a result, project managers can view and access all relevant project information, such as contacts, budgets, project and product costs, project phases and pictures of products in development.
Supplier Evaluations for the Purchasing Department - BOS evaluates their suppliers on a regular basis. Using Pentaho, IT-Novum developed an automated way to generate reviews of suppliers and, in turn, suppliers are informed during the process about the results of the assessment through an automated e-mail system. The content is based on the supplier’s classification, language preference, and country of origin.
Operations Cockpit - With business locations across three continents, having access to a centralized view of the state of production is absolutely essential. IT-Novum developed an operations cockpit that aggregates approximately 30 key business metrics from the various factories. The factories send their data in the form of Excel worksheets to the German headquarters, where it is loaded into the data warehouse so that it becomes available for reports and analyses.