update : 23/12/2020 Pentaho

Pentaho, published by the company of the same name founded in 2004, is a Business Intelligence Suite that distributes functionalities and business intelligence documents to a large number of people.

Pentaho is available in community edition (under LGPL licence) and commercial edition (under proprietary licence).

Pentaho provides all the functionalities of a BI suite:

• ETL (Pentaho Data Integration);
• multidimensional analysis (Mondrian OLAP engine, Analyzer interface in the commercial edition, Saiku Analytics plug-in available on the community edition);
• ad-hoc reporting (development of reports in drag and drop mode based on a data dictionary written in natural language and offering an abstraction) ;
• enterprise reporting (Pentaho Report Designer or BIRT plugin)
• dashboards (with Dashboard Designer in the commercial edition and C*tools plugins in the community edition);
• data mining (Weka).

The analytic and ad-hoc functionnalities from the community edition are less powerful than those from the commercial edition that ships with the Analyzer and Interactive Reporting tools but can be easily extended with additional community plugins such as Saiku (Analytics, Reporting) and the C*tools.

The latest release features a completely redesigned user interface. The ergonomics has been greatly improved and the web application can now easily be accessed on all devices (including tablets) in all editions.