TrustRadius
Pentaho Review 1 of 24
Pentaho Review: "A great tool, but falls under the shadow of the larger players."
https://www.trustradius.com/business-intelligencePentahoUnspecified7.497101
June 28, 2018

Pentaho Review: "A great tool, but falls under the shadow of the larger players."

Score 6 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Pentaho

We rolled out Pentaho within one of our business units as a way to get at trapped data from an old home-grown CRM system that had been recently updated to .net. Pentaho quickly got us access to the data and the built-in ETL tools were easy and quick to use and learn. It enabled a team of two to provide enough data, reporting and analytical dashboards to support over $1.5B in sales.
  • The built-in ETL tools are easy to learn, and can quickly import and transform any data you have.
  • The excellent visualizations and charts are pleasing to the eye, and looks are important in sales and marketing presentations.
  • The rollout was fast, we installed the software and were building dashboards within minutes.
  • I think the relative obscurity of the tool is a downside, not as many developers, consultants or peers you can tap into.
  • Lack of a solid user community held us back, looking at Power BI and Qlik, they have huge user communities that help each other out. Would have liked that here.
  • Smaller company means smaller sales force, and the lack of a local presence made it hard to only interact online with the account rep. Other companies have someone local who often stops by with pre-sales developers to just pitch in free of charge when they have time.
Pentaho ranks #3 out of the four. I would always choose Qlik Sense overall since it is so incredibly fast and adaptable. It also has built-in ETL and has a much greater community. If you don't like Qlik, Tableau would be a second choice but the company is difficult to work with. Power BI would be last, it looks cool on the surface, but you need an army of low-level analysts to crank out tabular models to feet it, so the TCO is way out of line with other solutions.
Good. The built-in ETL allows you to connect to most sources and types of data. It is nice that you don't need any special ETL tool to do the work, but when you get into an implementation like this you'll find you do still need tools like Informatica or Snowflake to stage data to a warehouse so you can access it faster with less transformation.
Not a lot to say here, nothing above and beyond what any of the other tools offer. You can control, share or restrict data by data points such as user ID's or by roles tied to those IDs. Better interfaces with the suite of Microsoft products would make it easier to report out your data findings on, but not even Microsoft's Power BI can talk to its own products very well in this category.
The tool is fast, visually attractive and intuitive to use, but we also have an implementation of Qlik Sense and Pentaho pales in comparison to the overall capabilities. I recommend the tool, but everyone’s solution need is unique, so it may not be the right fit. Larger tools like Qlik are more versatile and easier to recommend. More expensive, yes, but you usually get what you pay for.

Pentaho Feature Ratings

Pixel Perfect reports
8
Customizable dashboards
8
Report Formatting Templates
6
Drill-down analysis
7
Formatting capabilities
7
Integration with R or other statistical packages
5
Report sharing and collaboration
5
Publish to Web
5
Publish to PDF
7
Report Versioning
6
Report Delivery Scheduling
6
Delivery to Remote Servers
5
Pre-built visualization formats (heatmaps, scatter plots etc.)
6
Location Analytics / Geographic Visualization
6
Predictive Analytics
5
Multi-User Support (named login)
6
Role-Based Security Model
6
Multiple Access Permission Levels (Create, Read, Delete)
6
Single Sign-On (SSO)
6
Responsive Design for Web Access
6
Dedicated iOS Application
6
Dedicated Android Application
6
Dashboard / Report / Visualization Interactivity on Mobile
6
REST API
7
Javascript API
6
iFrames
5
Java API
5
Themeable User Interface (UI)
5
Customizable Platform (Open Source)
5