Hitachi Vantara

Pentaho Business Analytics


4 / 5
30 reviews

Who Uses This Software?

Any firm seeking to utilize and integrate data mining and analytics for the betterment of their business.


Average Ratings

30 Reviews

  • 4 / 5
    Overall

  • 4 / 5
    Ease of Use

  • 4 / 5
    Customer Service

Product Details

  • Starting Price
    Not provided by vendor
  • Deployment
    Cloud, SaaS, Web
  • Training
    Documentation
  • Support
    Online
    24/7 (Live Rep)

Vendor Details

  • Hitachi Vantara
  • www.pentaho.com

About Pentaho Business Analytics

Pentaho is building the future of business analytics. Pentaho's open source heritage drives our continued innovation in a modern, integrated, embeddable platform built for the future of analytics, including diverse and big data requirements. Powerful business analytics are made easy with Pentaho's cost-effective suite for data access, visualization, integration, analysis and mining.


Pentaho Business Analytics Features

  • Ad hoc Analysis
  • Ad hoc Query
  • Ad Hoc Reports
  • Benchmarking
  • Budgeting & Forecasting
  • Dashboard
  • Data Analysis
  • Data Visualization
  • Key Performance Indicators
  • OLAP
  • Performance Metrics
  • Predictive Analytics
  • Profitability Analysis
  • Strategic Planning
  • Trend / Problem Indicators
  • Data Analysis
  • Data Filtering
  • Data Quality Control
  • Job Scheduling
  • Match & Merge
  • Metadata Management
  • Non-Relational Transformations
  • Version Control
  • Customizable Dashboard
  • Data Source Connectors
  • Drag & Drop
  • Drill Down
  • Financial Reports
  • Forecasting
  • Marketing Reports
  • OLAP
  • Report Export
  • Sales Reports
  • Scheduled / Automated Reports

Pentaho Business Analytics Reviews Recently Reviewed!


Once you understand the basics of this program it is very, but very easy to use

May 22, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: "higher visual interface to processes, has a good number of functions (and very easy to understand) for data reporting, integration, data mining and ETL.. very simple but effective Big data transform You can build many dimensional model and load the results of the transformation into a database to develop any report whit low margin of error through a dimensional model and load the results of the transformation into a database to develop specialized reports , low margin of error-Automate the steps for execution"

Cons: Its a great tool to use, nothing to dislike about the product. Nothing to dislike, everything is good. All the features are really good.

Pentaho, a great open source BI suit with strong community support

Jun 16, 2017
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 7.0/10 Not
Likely
Extremely
Likely

Comments: One of the best opensource BI tool, also well integrated with existing platforms. It will be interesting to see how will it get integrated with fast evolving Big data technologies. Pentaho 7.1 is step in right direction.

Pros: - We mature DI (Data integration) module - Easy to learn design console (Spoon) - wide community support - Very well integrated with different platforms - Innovating fast in Big data world specially Pentaho 7.1

Cons: - Not very well documented for latest releases one of the reasons is many innovation are happening very fast

Riding a Wild Horse - Community Edition

Apr 18, 2017
3/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

2 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Many features. I like to use the reporting PRD, I think that it is the best. I use Spoon/Kettle that is a ETL tool to process data.

Cons: Many bugs. Maybe is because of Community Edition. We have many difficult to install in cloud. The layout of some report that run in developing, don't run in production.

Saves me not only hours, but DAYS

Feb 23, 2017
5/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Pentaho has nice schema browsing features whereby one not need know anything about the underlying schema in order to design a transformation. Automatic multi-threading by default.

Cons: When outputting to a table, Talend has an option to Drop if exists, and create. Pentaho has a Truncate [prior to load], but no option create the table as part of the data flow nor an option to drop an existing table.

Capterra-loader

I love this tool, because it has minimized data preparation time by filtering the most interesting d

Apr 10, 2018
3/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

3 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: It allows to extract the information from an OLTP database, transform the information through a dimensional model and load the results of the transformation into a database to develop specialized reports which Pentaho also has. It includes tools to perform queries, generate reports and reports, interactive analysis, dashboards, extraction, transformation and data loading, data integration.

Cons:

It requires a large investment, because its correct implementation is not an easy task and these systems consume many resources.

Overall: Represents the solution to meet the needs of extraction, manipulation, validation and data loading from multiple sources of origin and in different environments can solve many problems. For the creation of the Dimensions Tables. Transformation of these data and Upload of that data in another site.

Pentaho Review

Apr 04, 2018
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Once you understand the basics of this program it is easy to use. The bonus with this program is that if someone write a report, they can share the script with you. The updated 6.1 version is definitely an improvement.

Cons: If you are not at all familiar with writing script, this program can be very challenging. No real user manuals are included.

Best Data integration and business analytics tool

May 28, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: Best product for reporting and analyzing.

Pros: Best reporting tool.Features like data reporting, integration, data mining and ETL. Provides easy and good insights of business. Provides intuitive interface for most advanced users

Cons: Sometimes Pentaho Spoon(GUI) crashes.sharing and collaboration capabilities need to be enhanced Other all features are really good.

Practical, versatile and objective

Mar 11, 2018
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: -Automate the steps for execution

- It has a friendly graphic environment

- Easy to use

- Wide range of tools

Cons: -High basic requirements for execution.

- lack of detailed comments in error messages.

-It does not have documentation in Spanish language.

Overall: Fast execution of ETL processes in the case of massive data migration with a very low margin of error

The best tool for data integration

Oct 05, 2017
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Ease of use and abundant features to get things done. Helps a lot in filling the various gaps in data sources.

Cons: Not so user friendly, takes sometime for new user to get around the application and figure out the various tricks and tools available

Gives me the ability to use clicks instead of code.

Feb 02, 2018
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

2 / 5
Customer Support

5 / 5
Value for Money

Pros: Penatho brings a visual interface to processes which would traditionally only be accomplished by many, many lines of code (which it can also do). Many powerful inputs from servers, software, and CRM systems. It also has very detailed error handling, which makes it easy to troubleshoot.

Cons: Support is mostly wiki/community based, with instructions for particular steps being lacking, outdated, or missing completely. Outputs could be simplified as well, with even a basic CSV output being slightly more complex than it should be, compared to other steps.

Pentaho is a user-friendly open source ETL tool

Dec 05, 2014
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

3.5 / 5
Customer Support
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: I like its ease of use; it is very easy to build an ETL pipeline after the initial learning curve. I also like the variety of modules. There are a lot of powerful modules, and you will mostly find the module you want. User-defined code is very flexible; it's possible and very easy to plug in user-defined Java code. When there is no module implemented for desired function, this feature comes handy. Multithreading is also easy. The transformation can be set to run multiple copies in parallel.

Cons: Occasionally, Pentaho Spoon (GUI) crashes, and a restart is required.

Recommendations to other buyers: It is easier to learn from examples. Pentaho has examples with the installation.

It is definitely the solution to carry out all the projects successfully!

Apr 18, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: This software is wonderful, with it you can obtain performance and scalability. As well as manage and schedule reports. It is very efficient which means that you save a lot in daily reports...

Cons: This software is potentially amazing. Has it all! Your free trial is as complete as the paid version. It's very complete.

Overall: Everything is organized better using this software. It is quite efficient and easy to use...

Pentaho is amazing...

Nov 09, 2017
4/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Comments: It's a great platform, congratulations ... is the only one compatible with the bank I use, only a more robust documentation is missing.

Pros: The only BI software that is compatible with Firebird SQL, I have not found any other compatible BI.

Cons: Particularly I found it difficult to start learning, the documentation regarding the data integration (spoon) is scarce.

PDI Community Edition is amazing.....the rest is mud

Mar 20, 2018
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: - Free PDI tool....its free so no discussions with finance - PDI is actually very effective ETL application with a easy to understand flow - Community is actually helpful

Cons: - Free BI tool is just slightly easier than building a website from scratch but a lot harder than using any other BI tool. - You need to know how to hack java to use. - The paid version does not have competitive pricing for the incremental value.

cool tool for your web app

Dec 13, 2016
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: It provided an intuitive interface for most advanced users.

Overall: I was impressed with the ability to integrate this into an existing web app. It allowed our users to start looking at operational data and learning from it.

Good business analytics tool

Oct 23, 2015
5/5
Overall

4 / 5
Ease of Use

4.5 / 5
Features & Functionality
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Fetures like data reporting, integration, data mining and ETL capabilities

Cons: nothing to dislike, everything is good. All the features are really good.

Recommendations to other buyers: Must use for business analytics related operations. Good and very helpful tool for analytics related to operations.

An easy BI tool with a POWERFULL ETL inside

May 10, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

3 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Pentaho BI Solution is nomilly a BI Open Source solution that can compete with the most important players of this area. Pentaho is easy to manage and has a powerfull ETL inside that can be managed itself as a product.

Cons: The "Open Source Philosophy" is not away true.... I mean that if you want a full support from Pentaho it will be not-so-cheap

Very ergonomic ETL tool

Nov 03, 2015
5/5
Overall

4.5 / 5
Ease of Use

5 / 5
Features & Functionality
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Really helps to solve complex business solutions with its cool features and like their contribution to open source.

Cons: Its a great tool to use, nothing to dislike about the product.

Recommendations to other buyers: It is very easy to learn and has good support service.

Capterra-loader

Pentaho is integrated set of tools for business intelligence

May 17, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Data in Pentaho can be easily import from nearly any type of source including .csv, excel etc to create single report.

Cons: Pentaho itself is too much resource hungry as compared to other BI softwares. Configuration after installation is required that will be difficult for non-techies.

Overall: I have transformed multiple databases from different sources and formats into one single format and recognizable database set. After single database operation, I need to summarize report for that purpose i used Pentaho report designer tool to summarize and design report.

A great data analysis tool

Mar 26, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: personally I think it is a very powerful tool, powerful, very robust and also free

Pros: A very well designed platform, of great cost benefit, as well as the integration and reports, even better than when we analyze the costs, Pentaho is a free tool, incredibly, because when you work on it, you realize the robustness by handling a lot of information in just seconds

Cons: In addition to its great design, the learning curve is quite high, and its platform is not very intuitive

Pentaho review

Dec 08, 2016
4/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Comments: Pentaho features pixel-perfect reporting, subreports, parameterized reports, and OLAP. The OLAP tools let you perform ad-hoc views, reports, and views through MDX queries. Pentaho puts more effort into data integration, ETL, and workflow automation.

Pros: · Very powerful integrated tools · Better user interface · Best report design wizard · Fastest growth and improvement · Better dashboard capabilities

Cons: · Doesn't seem to have a wizard for creating charts · Weaker support community

Requires training before actual use

Oct 07, 2015
4/5
Overall

2.5 / 5
Ease of Use

4 / 5
Features & Functionality
Likelihood to Recommend: 6.0/10 Not
Likely
Extremely
Likely

Pros: Pentaho Data Integration has lot of functions to fulfill the requirements. Functions dealing with running shell script to creating and reading from Excel spreadsheets were quite useful for creating an ETL flow.

Cons: Requires the training to actually understand the product. It is hard to figure out several aspects like declaring variables (global) within the product.

Recommendations to other buyers: Very useful for enterprises, since Pentaho provides active support in case of software issues.

Its a great Experience.

Nov 03, 2015
5/5
Overall

5 / 5
Ease of Use

4.5 / 5
Features & Functionality
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: This product has good features including data mining, integration. This product also has features for data reporting. Learning curve for the product is less.

Cons: Not Really. I don't think there is anything I dislike. This product has all good features.

Recommendations to other buyers: I would definitely recommend this product to other students specially if they are working on big data related projects. Really useful features in product and easy to use for new user.

Very intuitive

Mar 09, 2018
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: It is intuitive for beginners, what makes it easy and quick to learn. Also, it's a free platform, and it has one large community.

Cons: The bugs are usually not so easy to solve, and the errors shown sometimes don't give you a clue of what is wrong.

customization is key

Feb 26, 2017
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money

Comments: Provides much-appreciated flexibility for us to customize KPI reports as well as client reports that we don't offer on platform.

Sep 13, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

Jan 09, 2018
1/5
Overall

Great business product. Easy to use

Nov 02, 2015
5/5
Overall

4.5 / 5
Ease of Use

5 / 5
Features & Functionality
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Great analytics and results are very useful. Provides good insight of the business.

Cons: Nothing much to dislike, in fact haven't seen so many applications supported by a single software

Recommendations to other buyers: Services they provide and the results are astonishing !

Sudhakar from VMware

Nov 03, 2015
4/5
Overall

4 / 5
Ease of Use

4.5 / 5
Features & Functionality
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

Pros: Features like data reporting, integration, data mining and ETL capabilities

Cons: Nothing, Everything looks good to me. All features meet expectations.

Recommendations to other buyers: Use it for real-time business analytics. All your data can be analyzed properly.

Nov 04, 2016
4/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely