Open Source Business Analytics Platform


The Pentaho Business Analytics platform provides enterprise-class reporting, analysis, dashboard, data mining and work flow capabilities that help enterprises operate more efficiently and effectively. The software offers a very flexible deployment options such as embeddable components, customized BI application solutions, and as a complete out-of-the-box, integrated BI platform.

Pentaho addresses the barriers that block your organization's ability to get value from all your data. It simplifies preparing and blending any data and includes a spectrum of tools to easily analyze, visualize, explore, report and predict. It comprises of various components which can be used independently or in a integrated fashion

1. Kettle Data Integration ETL

K.E.T.T.L.E (Kettle ETTL Environment) is a meta-data driven ETTL tool. (ETTL: Extraction, Transformation, Transportation & Loading). It is completely visual and it means that no code has to be written to perform complex data transformations. it is possible to create plugins to do custom transformations or access proprietary data sources

The features include

  • Completely visual with drag and drop capabilities
  • Big data integration
  • Powerfull administration of jobs and user security
  • Ability to manage Data Quality

2. Dashboards and Reports Designer

Interactive dashboards and reports allows business users to monitor the KPI in a highly graphical visual interface to improve organizational performance.

  • Web-based drag and drop design
  • Build custom dashboards in a graphical way
  • Portal and mash-up integration
  • Intuitive web-based interactive reporting for business users
  • Graphical report designer for power users
  • Output in multiple formats such as HTML, Excel, CSV, PDF and RTF
  • Support for NoSQL

2. Dashboards and Reports Designer

It is the tool that helps you create Mondrian OLAP schema. You can present your data multi-dimensionally and let users select what dimensions and measures to explore, interactively drilling into and cross-tabulating data.