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

Knowage 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

Knowage
Ranking in BI (Business Intelligence) Tools
32nd
Average Rating
7.6
Reviews Sentiment
6.7
Number of Reviews
18
Ranking in other categories
Reporting (24th)
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 Knowage is 0.4%, down from 0.5% 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

AM
Easy to customize, cross-platform capable, and very stable
The only challenge here is that it's a Java-based platform. It requires very high technical skills. When we come to the integration with the single sign-on facilities, that part is very challenging. In Power BI and other tools, it's very easy to integrate with active directory and single sign-on, and identity management is very easy in other business intelligence tools. However, when it comes to Knowage, it's a bit heavy, it's time-consuming sometimes, it's not very fast, and definitely not as fast as other business intelligence tools in terms of getting graphical reports. The solution could be cheaper.
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

"I can't name the features the way the Knowage community calls them because I still don't know the lingo. However, I can describe them. I like the ability to join more than one report, set all fields on one end, and replicate that on the other reports. I like that a lot. I think it's one of the features that got me using Knowage. They have tables, and I like that too. They took SQL scripts and many other scripts and enabled them to even correlate with Python. That's also one of the best things about Knowage. You could also decide to get information per user role, and this is also a feature that I like in Knowage."
"We can easily do our own customizations."
"The concept of engines is quite powerful allowing the user to work with report authoring/provisioning tools of their choice."
"The embedding feature is great."
"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."
"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."
"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."
"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."
"The on-premise version has quite good scalability."
"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."
"It seems quite performant in analyzing multi-dimensional information sets and presenting them."
 

Cons

"Development of SpagoBI has now been moved to Knowage. Users interested in further developments of the platform will have to look there."
"The only challenge here is that it's a Java-based platform. It requires very high technical skills."
"It would be better if more resources were available to help us learn how to use it. I wanted to use Knowage for a more extended period, but learning materials around the product were not really available and were not really straightforward. I've also seen inconsistencies between versions. For example, under the tools, especially in the cockpit, the way you create reports is now different. You will also find some configurations within a particular state, like a line chart, which differs from version to version. I think consistency is an essential feature in a product, especially for business intelligence products."
"The dashboard components could be better."
"Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved."
"The general amount of negative comments that I am hearing from my team makes me very wary."
"There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"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."
"I find that this is quite a heavy, time-consuming tool for developers."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
 

Pricing and Cost Advice

"Knowage is open-source, and an enterprise edition is also available."
"It allows the implementation of an effective reporting system using internal skills at a limited upfront cost."
"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.
 

Top Industries

By visitors reading reviews
Computer Software Company
18%
Government
14%
Real Estate/Law Firm
9%
Hospitality Company
9%
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

Ask a question
Earn 20 points
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

SpagoBI
No data available
 

Overview

 

Sample Customers

FIAT Group, Italian air navigation service provider, Ministry of Education and Science of the Russian Federation, Telecom Italia, ASL Genovese, San Giovanni Battista University Hospital
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 Knowage vs. Pyramid Analytics and other solutions. Updated: April 2025.
847,625 professionals have used our research since 2012.