Business Intelligence System Pentaho BI

Pentaho BI is a business intelligence system, providing two types of analysis:

  • Adhoc-analysis is building analytical reports by business-user on the basis of the data warehouse systems without exporting and conversion. On creating a report, users operate standard business notions (fig. 1,2);

p1

Fig. 1 — Building up an analytical report

p2

a) An example of built-up report

p3

 

b) An example of possibility to represent and download a report in different formats changing the meanings in the Output Type field (in particular, available formats: PDF, XLS, TXT and others).

Fig.2 (a,b) — Examples of ready reports (Adhoc – enquiries)

  • OLAP – building up analytical reports on the basis of the data exported from the datamanagement systems into the storages (Fig. 3) The preliminary exporting and data aggregation allows building up ad-hoc analytical reports using the data of the current accounting period and the budget as well as historical data.

p4

Fig.3 – Building up reports on the basis of OLAP-cube

Data Sources

As a source can be:

  • Any database with JDBC-driver;
  • CSV-file.

Visual Data Representation in Pentaho

Pentaho can represent data in different ways:

  • Information panels with different interactive graphs.
    Let’s study the example: 10 top customer rating with a regional breakdown (Fig 4). On pressing «Region» button, the pie graphs shows 10 top customers related to this region.

p5

Fig.4 – An example of linked graphs

  • analytical presentation on the basis of cubes for analysis of historical data (Fig. 5)

p6

p7

Fig. 5 – Historical data analysis with a breakdown by years.

  • interactive tool for creating pivot business-tables online by the users (fig. 6).

p8

Fig. 6 — Pivot table on the basis of OLAP-cube. The report can be exported into XLS and CSV files.

  • Possible to incorporate information panels such as Google Maps to show sales outlets with the territory breakdown, e.g., shopping centres with territorial distribution with key indicators. (Fig 7)

p9

Fig.7 – Possibility to incorporate Google Maps for visualizing the breakdown of the business structure