TrustRadius
Pentaho Review 10 of 24
Review: "Pentaho- An adequate BI solution for users on a budget!"
https://www.trustradius.com/business-intelligence-biPentahoUnspecified7.5100101
Ivan Miller profile photo
February 26, 2016

Review: "Pentaho- An adequate BI solution for users on a budget!"

Score 7 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Pentaho

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.
  • ETL, fairly wide support for a number of different data sources, a good API for writing plugins, and great out-of-the-box functionality.
  • Community support and great documentation for using their tooling.
  • Mondrian/OLAP, great engine for processing MDX queries.
  • pentaho's analyzer tool/front-end. This doesn't come close to competing with products like Tableau.
  • Pentaho Report Designer, this looks like something that was built in the early 90's and is extremely clunky to use for new-users
  • Schema Workbench, would be nice to see better support for snowflake type schemas
In terms of price, pentaho seems to be the clear winner for functionality that you get--especially with the community edition. If you don't need to license anything out, even the enterprise edition is fairly reasonably priced. With this in mind, it's a winner in the sense that it provides 95% of the data integration functionality that these other tools do without having to spend a fortune to do so.
This is one of the areas where I think pentaho has done a great job--and with every iteration of the product they seem to include more and more data sources to connect to. Given the data we've been working with, I don't think we've come across a situation yet where we haven't had a relatively simple connector to use.
The access control capabilities are generally sufficient, but not stellar. Most of the data sharing and access control is managed completely through pentaho's BI server, and there doesn't seem to be super strict security around the configuration and setup of permissions, who can view what reports, etc. The dashboarding capability of "putting a bunch of reports together" is extremely clunky, it's something we steer clear of trying to implement where possible.
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

Pentaho Feature Ratings

Pixel Perfect reports
6
Customizable dashboards
3
Report Formatting Templates
3
Drill-down analysis
2
Formatting capabilities
2
Integration with R or other statistical packages
3
Report sharing and collaboration
6
Publish to Web
6
Publish to PDF
5
Report Versioning
Not Rated
Report Delivery Scheduling
5
Multi-User Support (named login)
5
Role-Based Security Model
Not Rated
Multiple Access Permission Levels (Create, Read, Delete)
6
Responsive Design for Web Access
3
Dashboard / Report / Visualization Interactivity on Mobile
4