Pentaho Reviews & Insights

Before working for Hitachi Vantara, I had experience using the Pentaho Tools for personal projects mainly. I had the chance to work directly with the teams that supported the Pentaho tools, and I can tell with much objectivity that the Pentaho tools are by far one of the best options in the market when it comes to all the ETL processes. Data science requires extracting data from different sources, organizing it, and transforming it according to each necessity. Machine learning is built on top of these concepts, and with the Pentaho tools, you can accomplish most of it. Since I supported the Pentaho tools while working for Hitachi Vantara, my perspective is kind of unique; I can tell that the tools were used to solve internal problems such as integrations with our release tools and some of our agile tools, so the tools were used to enhance the newer versions.

Solving problems such as extracting metadata from thousands of files, organizing this information, and filtering it to create release files, determining how to create meta information files is just an example of the ETL cycle that can be performed with the Pentaho tools.

Pentaho's BI stack is being used by our entire company. We use their tooling for ETL, delivering reports, and as a sort of end-point for a custom web app that we've built. The end point uses xaction and Mondrian to deliver data to our front end. We also make use of the community edition of the BI server--this houses several reports that our analyst team has built as well as resources necessary to support our custom app. In the near future we'll also be using the tool's big data plugins to ingest data into our data warehouse from hive/hadoop.

Pentaho is very well suited for organizations looking for end-to-end BI solutions without wanting to break the bank--particularly because the community edition has most of the functionality necessary to get you started, and it's free. Honestly though, if you have deep pockets there are probably more complete solutions out there in terms of functionality

We utilize the Community Edition of Pentaho across our organization for business intelligence. We use Pentaho Data Integration (PDI) to gather data from disparate data sources and perform ETL to populate our data warehouse. We also use PDI to deliver custom reports to various internal and external clients. We use Mondrian as a data engine behind our customer-facing website to process MDX queries from our customer reporting portal. We use Pentaho Report Designer to author pixel-perfect reports for internal and external audiences. We also use the Pentaho User Console for our business analysts to slice-and-dice the data for various departments. In summary, Pentaho is used to allow our internal and external clients to benchmark the performance of our products and services and gain visibility into customer behavior and activity.

As far as generating and maintaining a data warehouse, Pentaho does an excellent job and I would highly recommend it. For analysis and gaining insight into your data, Pentaho is excellent. For visualization, dashboarding, or executive grade reporting it may not be as beautiful or flashy as your clients require.

We integrate Pentaho with Odoo for complex, custom reports that allow us to query data from PostgreSQL database across multiple data models in Odoo. I have used it to connect to Odoo via JDBC as well as directly to the web client for an object-based report. I have found the report designer client to be a bit difficult to use and buggy on my WIndows 7 machine but I have seen it working well on a Windows 8 machine. We use version 3.9.1.

Pentaho is great for companies that don't have huge budgets but want a powerful reporting tool that they can get and use for free. It is great for developers that know SQL and can learn to use a non-intuitive interface and are motivated to work through a very outdated interface.

Our product intended to analyse Media and Communications data and provide decision making capabilities to our end users. Whereas we built the workflow management, transactional capabilities, Pentaho provided the BI layer for our product. Analysts were our end users. Everything from data ingestion to decision making was the scope of our product. We read data across disparate data sources/formats and using our business expertise provided decision making capability.

Integration is best with Pentaho. If you want to overlay your product capability with Pentaho's BI Server, Data Integration, Reporting Engine, Workflow capabilities then Pentaho is the only answer. Other tools provide each of these very well, but if you have already built your product and dont want to buy Informatica, Cognos/Microstratey and SPSS/SAS then Pentaho is the way to go.
Pentaho is Java based, so no shortage of skilled Java resources who can help you integrate. We did not spend time building our own reporting engine, Data Visualization layer, Security layer, workflow capabilities. We simply used our proven transactional product and used Pentaho to fill our gaps.

Pentaho is used as main ETL tool in the data analytics team. It solves the problem of processing and populating financial and ads related data.

Pentaho is well suited for ETL processing and database population. It is less appropriate for visualization and analytics. Key question is the benefit it can bring and the cost and robustness.

Pentaho serves several roles in our environment.

We use it for report design and delivery. The designer tool is fairly straightforward and once reports are complete they are immediately accessible to our end users.

Pentaho is used for Business Intelligence which includes totals, trends, and forecasts of sales and subscriptions of our services. Pentaho's web-based analysis tool allows our end-users to drag & drop measures and dimensions and instantly convert raw data into a variety of graphical representations. Before we had Pentaho, each view might have required a long query or static report that was hand-exported to Excel. With Pentaho's analysis tool, our sales, finance, and marketing teams have instant insight and infinitely flexible views of our data.

In the IT department, we use Pentaho as a scheduling engine for data maintenance jobs as its interface allows us to manage multiple shards from a single source.

Do you need to integrate data from multiple sources? Pentaho is great for this. Previously, we were SSHing files around and importing with numerous cron scripts.

Are your Finance and Marketing teams constantly asking for one-off queries? Pentaho puts this power in THEIR hands so they can pull and arrange the data they want into whatever view they want.

Do you want to pay too much for a full-featured BI solution? Pentaho is very reasonably priced, and even has a free version!