# Pentaho Reviews **Vendor:** Pentaho **Category:** [Analytics Platforms](https://www.g2.com/categories/analytics-platforms) **Average Rating:** 4.1/5.0 **Total Reviews:** 50 ## About Pentaho Pentaho is a modular, enterprise-grade platform that makes it easy to manage complex data—on-premises, in the cloud, or in hybrid environments. Whether structured or unstructured, your data becomes a trusted asset that teams can use to operate with confidence, agility, and control. ## Pentaho Reviews ### 1. Very easy to setup to build Snowflake reports and dashboards **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Retail | Small-Business (50 or fewer emp.) **Reviewed Date:** January 08, 2021 **What do you like best about Pentaho?** It was so easy to build reports and dashboards on our Snowflake warehouse with Pentaho Business Analytics. We basically setup the Snowflake JDBC driver, created a data source using the Data Source Wizard and was doing ad-hoc analysis and dashboarding within an hour. The visualizations also look very nice like the heat grid and map. Seems like there are a lot of tuning and configuration options available. **What do you dislike about Pentaho?** There are a lot of tools/options to consider when trying to solve the basic problem of building a report. I suppose it may take some time to figure out which tool (i.e. Analyzer, Reporting, CDE, etc.) is the best one based on needs. **What problems is Pentaho solving and how is that benefiting you?** Building marketing campaign dashboards on data in Snowflake. We need to compare campaign results for Control/AB vs. promotion variations. We've been able to get up and running very quickly. ### 2. Pentaho to work with external IT services **Rating:** 4.5/5.0 stars **Reviewed by:** Andreas W. | Information Technology Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** December 20, 2019 **What do you like best about Pentaho?** Pentaho Business Analytics is a very advanced, hardware-compatible ETL system which can handle large amounts of data rapidly, while using information from a variety of sources. It's so customer-friendly that, even though you're not aware of SQL, you are going to be able to learn it quickly. Basic jobs and changes can quickly be generated with Pentaho, asi t provides advanced information access and processing capabilities. **What do you dislike about Pentaho?** It would be nice to have a replication template on objects, tables, bridge-tabs, maps, which would help the layout. I think many core elements, such as communication and working ability, must be improved. Also, the marketplace has a rapid JSON output stage, but I feel I'd be better if Pentaho could be able to render JSON processing even more rapidly. **Recommendations to others considering Pentaho:** Pentaho is quick, eye-catching and straightforward to use. In our particular instance, we use it to build a number of tasks and changes that our office assistant users need every day. It also has numerous bulk loaders and, in contrast to overall capability, it allows the implementation of Qlik Sense and Pentaho Sales. However, it is less flexible than broader devices like Qlik. **What problems is Pentaho solving and how is that benefiting you?** Pentaho Business Analytics currently is used this for our external IT services. A second framework must be built to operate small and simple software for modeling information warehouses and market intelligences. Also, Pentaho allows our project managers to cut data for different departments through the Pentaho User Console. ### 3. Get assistment on the production and management **Rating:** 4.0/5.0 stars **Reviewed by:** Callum F. | IT Support Specialist, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** November 21, 2019 **What do you like best about Pentaho?** The automated Pentaho solutions are simple to learn and can insert and convert information that you have easily. Pentaho Analyzer is a versatile and straightforward analysis tool built on the Enterprise software of Pentaho. Also, it lets you link to almost every data source as long as you have a JDBC socket, REST API and any other endpoint of the Network. **What do you dislike about Pentaho?** Pentaho does not have a large community of users, so the feedback is very limited. We have some user groups that are helping each other out, but that's it. Also, more guidelines need to be provided in order to set analytical diagrams or create models manually. In general, Pentaho needs some improvements, as it has all the potential to become a genuinely side-to-end BI solution. **Recommendations to others considering Pentaho:** Pentaho Business Analytics is well suited for companies that need assistment on the production and management of their warehouses. It can effectively be applied and follows most machine learning applications. **What problems is Pentaho solving and how is that benefiting you?** This software is being used in the IT deparment of my organization. We use it to provide personalized information to several internal and external clients, to handle MDX requests on the consumer feedback platform behind our homepage and it also acts as a tool of evaluating employment and transitions, but the area of expertise of Pentaho is the treatment of tables. Pentaho quickly gained us access to the information and the integrated ETL tools were quick and simple to use. ### 4. Capture stuck information from a updated CRM program **Rating:** 4.5/5.0 stars **Reviewed by:** Conrad G. | Information Technology Specialist, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** November 18, 2019 **What do you like best about Pentaho?** Pentaho is extremely fast when working with any form of RDBMS from data entry to data charging. You can also link to many information sources in a very easy way. The powerful graphical coding tool of Pentaho Data Integration is amazing too. Syncing with AD is very useful to set protection for a directory or group of customers whenever you want. Also, Pentaho does have an accessible-source version that delivers a large part of the Business Version features with no license fees. **What do you dislike about Pentaho?** I would like to see Conceptual model Workbench's feature for the pier tables because they form part of the star scheme, and PDI reads JSON files slowly. **Recommendations to others considering Pentaho:** Pentaho is also a popular BI tool for the production of a vast number of complaints if your ERP does not provide you with a good alternative. Before implementing this solution you need to know the basics requirements for your company. While usig Pentaho, I recommend you to integrate it with Amazon RedShift because it is a server that is quantitative and almost any other database can be linked to free. **What problems is Pentaho solving and how is that benefiting you?** In one of the business segments, we have established Pentaho as an incentive to capture stuck information from a newly updated, house-grown CRM program. In all the company we have several Pentaho users, who make good use Pentaho Analyzer to produce the reports. Also, the author of the pixel-perfect reports to internal and external public is using Pentaho Report Designer. ### 5. Data analysis to your greatest excellence. **Rating:** 5.0/5.0 stars **Reviewed by:** Elaine C. | Operations Analyst, Internet, Small-Business (50 or fewer emp.) **Reviewed Date:** November 13, 2019 **What do you like best about Pentaho?** Pentaho is multiplatform uses standard technology, it is easy to install and configure, it has basic environments and it is a flexible solution that allows to create functionalities or modules that adapt to the needs of any organization. It is relatively stable, robust and reliable. This is a free platform, so you can realize an incredible perspective to start using Pentaho and discover the full potential of this tool. Pentaho has many different features and an intuitive design that help create several reports and panels. **What do you dislike about Pentaho?** So far it is a great tool to use, all its features are excellent. **Recommendations to others considering Pentaho:** Pentaho does an excellent job if you want to generate and maintain a data warehouse, it is an excellent tool for new companies, data integration is fantastic. A novice user can catch up quickly and the GUI is intuitive and very reliable. It has a platform that has a very intelligent architecture, which provides ease of use to the user when necessary. The platform has a very intelligent architecture and is believed to be extensible and offers the ease of use that the user needs. **What problems is Pentaho solving and how is that benefiting you?** Pentaho is used as a BI tool to improve the analysis and decision-making capacity, since it offers solutions that are mainly composed of an infrastructure of analysis and reporting tools. It is excellent for creating PDF reports, as well as interactive analysis reports where users can write their complement reports. Pentaho is used to allow our internal and external customers to compare the performance of our products and services and gain visibility into customer behavior and activity. ### 6. Cut data with Pentaho **Rating:** 4.0/5.0 stars **Reviewed by:** Carole L. | Information Technology Staff, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** November 11, 2019 **What do you like best about Pentaho?** Pentaho is a very advanced, hardware-compatible ETL system which can handle large amounts of data rapidly, while using information from a variety of sources. It's so customer-friendly that, even though you're not aware of SQL, you are going to be able to learn it quickly. Basic jobs and changes can quickly be generated with Pentaho, asi t provides advanced information access and processing capabilities. **What do you dislike about Pentaho?** It would be nice to have a replication template on objects, tables, bridge-tabs, maps, which would help the layout. I think many core elements, such as communication and working ability, must be improved. Also, the marketplace has a rapid JSON output stage, but I feel I'd be better if Pentaho could be able to render JSON processing even more rapidly. **Recommendations to others considering Pentaho:** Pentaho Business Analytics is quick, eye-catching and straightforward to use. In our particular instance, we use it to build a number of tasks and changes that our office assistant users need every day. It also has numerous bulk loaders and, in contrast to overall capability, it allows the implementation of Qlik Sense and Pentaho Sales. However, it is less flexible than broader devices like Qlik. **What problems is Pentaho solving and how is that benefiting you?** Pentaho currently is used this for our external IT services. A second framework must be built to operate small and simple software for modeling information warehouses and market intelligences. Also, Pentaho allows our project managers to cut data for different departments through the Pentaho User Console. ### 7. Incorporate and evaluate the corporate data with Pentaho **Rating:** 4.5/5.0 stars **Reviewed by:** Tyla W. | IT Consultant, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** November 04, 2019 **What do you like best about Pentaho?** The delivery process was super fast. We just downloaded the program and within seconds we started creating analytics. Then, we discovered that Pentaho could be built into all kind of tech and framework, and have incorporated it readily and effectively with various RDBMSs when there is too much layout. Also, the model and CSS layout allow us to build something unique, although it may sometimes become a challenge, but it can still be done quite fast. **What do you dislike about Pentaho?** One of Pentaho's main problems was its company licence because some of us, as customers that understood what is given in the large community edition, felt that its corporate features were far too big. Also, we have stopped switching to Tableau licenses for much of our inner dashboarding and investigating because we must go to the XML folder to add the new items to do this, which was a very long process. **Recommendations to others considering Pentaho:** Pentaho is suitable for advanced scientific uses or operational claims with major listings of POs, DOs and COs. However, if you need to work with pivot tables, I would suggest you to use another tool, although in Pentaho it can still be done but you will need to do some extra work. **What problems is Pentaho solving and how is that benefiting you?** Pentaho is the business analytics main source for the IT department. To incorporate and evaluate the corporate data on all structures, Pentaho is always capable to resolve more special needs. It has also been able to fulfill the many regulations for the business. ### 8. Conduct ETL with Pentaho Business **Rating:** 4.5/5.0 stars **Reviewed by:** Franky C. | IT Specialist, Internet, Mid-Market (51-1000 emp.) **Reviewed Date:** October 30, 2019 **What do you like best about Pentaho?** Pentaho Business Analytics allows us to sort the data the user needs to enter and to create a further layer of safety to send reports or e-mails through security, classes or the list of users. Even non-technical consumers may easily produce reporting and graphs if presented with a well-specified web application schema by using Pentaho. It is also user-friendly and it helps several of our programmer users to learn PUC's user interface. **What do you dislike about Pentaho?** There are team tables, but it becomes very difficult for programmers to modify this system when Schema Workbench is used to model a cube. Also, because of licensing issues, the modeling software of Pentaho has a very high price of technology. It also has relatively poor resources, maybe lower than designers and advisers may need. I wish Pentaho could seek to integrate quantitative material with all the functionalities of artificial intelligence. **Recommendations to others considering Pentaho:** Pentaho is an outstanding platform for evaluation and visibility into your results. If you constantly need to work in crucible tabs and measured columns, you can use Pentaho to read complicated linear regressions. **What problems is Pentaho solving and how is that benefiting you?** In the IT department, we mostly use the Pentaho Analyzer and Schema Workbench on BI side to collect data from various sources and to conduct ETL in our data storage factories for organizational intelligence. There are many accounts and Dashboards and bursting reports that we have managed to produce. In short, Pentaho lets our domestic and foreign partners evaluate our goods and services' quality and gain exposure in the activities and industries of their consumers. ### 9. Pentaho Business Analytics **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** August 26, 2020 **What do you like best about Pentaho?** Visualizations, Dashboards and flexible analytics **What do you dislike about Pentaho?** I haven't come across anything that turns me off. **Recommendations to others considering Pentaho:** Take a good look at Pentaho Business Analytics. It simplifies the process of analyzing, visualizing and reporting. **What problems is Pentaho solving and how is that benefiting you?** Taking security related organizational data and extracting value. ### 10. It is great. **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Telecommunications | Mid-Market (51-1000 emp.) **Reviewed Date:** June 22, 2020 **What do you like best about Pentaho?** The routing , looping , calling child jobs in the package is great. **What do you dislike about Pentaho?** The data loading from source to target is bit annoying . **Recommendations to others considering Pentaho:** Will recommend to use . **What problems is Pentaho solving and how is that benefiting you?** We are solving BI related things . Doing ETL and loading transformed data and then building reports on top of it ## Pentaho Discussions - [Are there apps for Pentaho that will allow me to access my information on my mobile device?](https://www.g2.com/discussions/2165-is-there-a-mobile-version) - 1 upvote - [Workshops and consulting?](https://www.g2.com/discussions/does-pentaho-offer-training-or-classes) - 1 upvote - [View Pentaho pricing details and edition comparison](https://www.g2.com/products/pentaho/reviews/pentaho-review-23597?section=pricing&secure%5Bexpires_at%5D=2026-05-20+21%3A18%3A16+-0500&secure%5Bsession_id%5D=8c3d593c-e1a6-4b80-9dec-0f6b2f2beaca&secure%5Btoken%5D=0c51d596bfcd33ef7da4a42e6f309aef519c8ff276d7186cb2a313481e9fcd86&format=llm_user) ## Pentaho Features **Reports** - Reports Interface - Steps to Answer - Graphs and Charts - Score Cards - Dashboards **Data Preparation** - Connectors - Data Governance **Data Modeling and Blending** - Data Querying - Data Filtering - Data Blending **Generative AI** - AI Text Generation - AI Text Summarization **Agentic AI - Analytics Platforms** - Autonomous Task Execution - Multi-step Planning - Cross-system Integration - Adaptive Learning - Natural Language Interaction - Proactive Assistance - Decision Making **Self Service ** - Calculated Fields - Data Column Filtering - Data Discovery **Deployment & Integration - Analytics Platforms** - No-code Dashboard Builder - Report Scheduling and Automation - Embedded Analytics and White-labeling - Data Source Connectivity **Advanced Analytics** - Predictive Analytics - Data Visualization - Big Data Services **Performance & Scalability - Analytics Platforms** - Large data handling and Query Speed - Concurrent User Support **Advanced Analytics & Modeling - Analytics Platforms** - Data Modeling and Governance - Notebook and Script Integration - Built-in Predictive and Statistical Models **Agentic AI Capabilities - Analytics Platforms** - Auto-generated Insights and Narratives - Natural Language Queries - Proactive KPI Monitoring and Alerts - AI Agents for Analytical Follow-ups **Personalized Intelligence - Analytics Platforms** - Behavioral Learning for Contextual Query Refinement - Role-based Insight Personalization - Conversational and Prompt-based Analytics **Building Reports** - WYSIWYG Report Design - Integration APIs **Platform** - Mobile User Support - Customization - User, Role, and Access Management - Internationalization - Sandbox / Test Environments - Performance and Reliability - Breadth of Partner Applications ## Top Pentaho Alternatives - [Looker](https://www.g2.com/products/looker/reviews) - 4.4/5.0 (1,576 reviews) - [Sisense](https://www.g2.com/products/sisense/reviews) - 4.2/5.0 (974 reviews) - [Strategy One (formerly MicroStrategy ONE)](https://www.g2.com/products/strategy-one-formerly-microstrategy-one/reviews) - 4.2/5.0 (529 reviews)