TrustRadius
Pentaho Review 3 of 24
Review: "Pentaho can be a great solution for a company"
https://www.trustradius.com/business-intelligencePentahoUnspecified7.5100101
February 23, 2018

Review: "Pentaho can be a great solution for a company"

Score 9 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Pentaho

We are currently using this application for all the companies. We have managed to develop a lot of reports and dashboards and also bursting reports. Until now we have been able to meet the requirements of reporting in the company in all departments. Pentaho is a good BI solution to also provide the option of creating many operational reports if you don't have a good option in your ERP.
  • SQL query + scripting will help you design different objects, tables, pivots, dashboards, linked t other reports.
  • Organizing in which way you want, synchronizing with AD is very helpful to set security/folder/group of users/single users.
  • By using Eclipse you can set another layer of security by filtering information users's need to access.
  • Sending reports y email also can be set up by security, by groups or list of users.
  • Design seems pretty secure, from time to time can fail when there is too much design.
  • Would like to have a format copy for different objects, tables, cross-tabs, grids, it would make design much more easier. Of course, we use template and CSS design for these objects, from time to time we design something different and it makes it much harder to do this manually for each similar object.
  • Possibility to use multiple DB in the .xaction.
  • direct query in excel
In comparison with Excel, that can also work with queries pivots and dashboards, Pentaho offers much more stability from a database point of view, more security options and provides a more stable table, pivots and dashboard designs. We are also completing the business intelligence experience for our users with Kyubit.
Usability for previous day data.
Pentaho offers the possibility of sending to XLS, PDF or CSV, once saved on your local computer you can share with anyone. Reports used for PDF must have a special design from the start. Also, a special schedule to send report can be created in the .xaction and is working fine.
  • Operational reports, big lists of COs, POs, DOs, master information and details. Bursting reports by email and scheduling tasks are interesting and very useful.
  • Complex aggregations are useful to use in cross tabs and calculated functions in the tables. I would recommend a new tool if the purpose is dashboards, but they still can be created in Pentaho as well.

Pentaho Feature Ratings

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