Try our new research platform with insights from 80,000+ expert users

Pentaho Business Analytics vs Pyramid Analytics comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 1, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Pentaho Business Analytics
Ranking in BI (Business Intelligence) Tools
20th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
44
Ranking in other categories
Cloud Operations Analytics (4th), Reporting (16th)
Pyramid Analytics
Ranking in BI (Business Intelligence) Tools
16th
Average Rating
7.6
Reviews Sentiment
6.4
Number of Reviews
8
Ranking in other categories
Data Visualization (12th)
 

Mindshare comparison

As of April 2025, in the BI (Business Intelligence) Tools category, the mindshare of Pentaho Business Analytics is 0.5%, down from 0.6% compared to the previous year. The mindshare of Pyramid Analytics is 0.8%, up from 0.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Featured Reviews

Sayan König - PeerSpot reviewer
Flexible, easy to understand, and simple to set up
The repository should be improved. There should be the possibility to have versioning, to make it combinable with some Git repositories or something like that, to check out the processes and make sure it has a traceable history. The solution could really be improved. There are too many bugs in our version.
Shyam Pendyala - PeerSpot reviewer
A comprehensive and user-friendly business intelligence for enhanced data insight
When developing multidimensional IMDS models in Pyramid Analytics, there is a need for better features to maintain and analyze data. The application currently lacks the ability to easily track the original physical table and field names, making it challenging to relate them to business names. It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields. Such features would simplify documentation, facilitate understanding of how calculations depend on physical fields and aid in explaining the development process to others. Having this lineage and easy-to-generate data dictionary would greatly enhance the usability of Pyramid Analytics for developers.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Pentaho is an analytics platform that can be used when an organization has a lot of big data storage systems already installed and needs to manage and analyze that data. It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it."
"The most valuable feature of Pentaho is the Tableau report."
"Easy to use components to create the job."
"It is robust, offers market intelligence, and utilizes modules effectively."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"The interface of Pentaho Business Analytics is easy to use and does not require high-level skills to operate the tool."
"We were able to install it without any assistance from tech support."
"Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud."
"The on-premise version has quite good scalability."
"I think the most valuable Pyramid Analytics feature is the solution's ability to drill down and dice in the loop. I think it is better than InExcel or Power BI."
"Pyramid has a wide level of uses, as it's a complete ETL process and has a good level of connecting to a lot of data sources."
"It seems quite performant in analyzing multi-dimensional information sets and presenting them."
"It offers a wide range of analytics options including statistics and visualizations, as well as prediction capabilities, allowing users to make forecasts based on the latest data."
"The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries."
"The features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job."
"It proved to be a very powerful and useful tool due to its breakdown capabilities, easy reporting features, flexibility in building custom calculations, and the ability to integrate them into reports."
 

Cons

"Deployment is not simple. It is not simple because we are dealing with a lot of data; we are dealing with a lot of storage. So, it's not a simple process."
"Pentaho Business Analytics is hard to learn and not suited for initial users as it requires knowledge of operating systems, Java, and other technical skills."
"Logging capability is needed."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"Version control would be a good addition."
"The repository should be improved."
"The tool is very good, and yet it has some problems as it relies heavily on Java."
"Pentaho Business Analytics' user interface is outdated."
"Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."
"I find that this is quite a heavy, time-consuming tool for developers."
"There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."
"There is room for improvement in terms of the user interface, particularly when it comes to modifying connections between filters and visual components in a dashboard."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"The general amount of negative comments that I am hearing from my team makes me very wary."
 

Pricing and Cost Advice

"We were lucky enough to find a Pentaho OEM partner who offered a data warehouse model and the ETL software for about 60K SGD per year."
"Pentaho is expensive ."
"Free and commercial versions are available."
"The licensing cost is not excessively expensive, but it does increase with the addition of new features and modules."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
847,625 professionals have used our research since 2012.
 

Comparison Review

it_user6978 - PeerSpot reviewer
Jun 10, 2013
Jaspersoft vs. Pentaho – Which one to use & is there any need to purchase the commercial edition
Any company (be it technology, manfucaturing, human resource, ecommerce, SME etc) always has the need for Business Intelligence to some or the other extent. If cost is one of the consideration factor, then the 2 BI tools which are at the forefront are Pentaho and Jaspersoft. But, often the same…
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Computer Software Company
13%
Educational Organization
7%
Real Estate/Law Firm
6%
Financial Services Firm
15%
Computer Software Company
14%
Government
12%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
What is your experience regarding pricing and costs for Pentaho Business Analytics?
For those starting to use this tool, there is a free version available which is beneficial. The company also finds the pricing to be good.
What needs improvement with Pentaho Business Analytics?
The tool is very good, and yet it has some problems as it relies heavily on Java. The platform works with Java, and it has brought some issues to the company.
What do you like most about Pyramid Analytics?
The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries.
What is your experience regarding pricing and costs for Pyramid Analytics?
I find the price of Pyramid Analytics to be quite reasonable, especially when compared to other tools in the industry. It is a cost-effective choice, particularly for mid-sized or larger companies ...
What needs improvement with Pyramid Analytics?
Pyramid Analytics could improve by speeding up data refresh, especially for large datasets. While it is currently an in-memory tool, efforts are underway to enhance direct connections to source sys...
 

Also Known As

Pentaho, Kettle, Hitachi Pentaho Business Analytics
No data available
 

Overview

 

Sample Customers

Cargo 2000 Lufthansa, Marketo, ModCloth, Cardiac Science, Telefonica, ExactTarget, Active Broadband Networks, and Brussels Airport.
US Department of Veterans Affair, Volkswagen, Siemens, Blackboard, Hallmark, Orange, CDW, LA Fitness, Atelier GS, Memorial Healthcare, Acadia Insurance, BancoBic, Advanced Learning, Microsoft, Drake University
Find out what your peers are saying about Pentaho Business Analytics vs. Pyramid Analytics and other solutions. Updated: April 2025.
847,625 professionals have used our research since 2012.