Pentaho

Pentaho breaks down the barriers that prevent your company from getting the full benefit of your data. The platform makes it easy to prepare and transform any data and includes a range of tools for simple analysis, visualization, research, reporting, and forecasting. Open, embeddable, and extensible, Pentaho is designed so that anyone on your team, from developers to business users, can easily transform data into something worthwhile.

Pentaho is a ROLAP implementation of OLAP technology, which means that all of the data we will be analyzing is stored in regular relational tables, except perhaps in some way pre-prepared. So all we need is to create the necessary tables.

Let me say a little bit about the subject area for which we needed statistics. There is a site, there are clients and there are tickets that these clients can write. Also with comments, yes. And all these tickets our helpdesk breaks down by different subjects, projects, countries. And here we needed, for example, to find out how many tickets on the topic “Delivery” came from each project from Germany for the past month. And all this broken down by admins, that is, to see who from the helpdesk and how many of these tickets handled, etc., etc.

OLAP technology allows to perform all such analyses. About OLAP I will not describe in detail. We will assume that the reader is familiar with the concept of OLAP-cube, measures and measurements and has a rough idea of what it is and what it’s about.