TrustRadius
Pentaho Review 2 of 24
User Review: "Pentaho for your business"
https://www.trustradius.com/business-intelligencePentahoUnspecified7.5100101
March 19, 2018

User Review: "Pentaho for your business"

Score 8 out of 101
Vetted Review
Verified User
Review Source

Overall Satisfaction with Pentaho

Currently, Pentaho was using it for our internal IT Department. We are using Pentaho to address more specific needs to integrate and analyze the company data that resides on all systems. It is necessary to have a secondary system that runs for the same purpose to run small and simpler modeling tools for Data Warehouses and Business Intelligence. It also acts as a comparison system to build simple jobs and transformations.
  • Easy to create simple jobs and transformations
  • Mature data access and data transformation capabilities
  • Suitable for complex analytic use cases
  • Consume data from many sources
  • At first, one needs to learn the basic concept of this software before going for the implementation. Once you are an expert on this then you will rock it.
  • Some of the basic features need to be enhanced such as sharing and collaboration capabilities
  • Needs to support automatically generated analytic visualizations or models
Since the Pentaho platform offers a range of broad functionality across data preparation and advanced analytics, it also can be easily integrated to support many data sources and machine-learning frameworks. Based on that fact, we selected Pentaho to be used in our internal department. It also supports many of our BI use cases as required by company management or the business user. Last but not least, the Pentaho license is cheaper than their competitor.
Pentaho is able to read from SQL engine or many data sources with the additional capability to use the available plugin. The plug-in is bundled with all servers and allows users to create new data sources for use throughout the system from other databases or CSV files uploaded to the server while using a setup wizard. During the steps of creating a data source users also are given a chance to create a data model describing how columns or fields relate to each other creating hierarchies of relationships like Time: Year, Quarters, Months, Weeks and Product Division, Category, Type etc. It also supports NoSQL system.
Pentaho provides the full support of different and many roles for access control capabilities. The features to share the data or report across team or different role in the organization and company. It includes features for managing security, running reports, displaying dashboards, report bursting, scripted business rules, OLAP analysis and scheduling out of the box.
Pentaho will work great to embed analytic content with full features of Machine Learning capabilities. It supports many machine-learning frameworks and can be easily integrated. So, you also can connect with many data sources and have no worries about it. In our case, we are using it to help us create many day-to-day jobs and transformations that our internal users need. But to achieve this, we need to train our team to be able to understand the main concepts of how this software works.

Pentaho Feature Ratings

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