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

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Pyramid Analytics has excellent scalability, particularly in its on-premise version.
The platform excels in drilling down and creating complex data combinations, outperforming tools like InExcel and Power BI.
It is powerful for building custom calculations, integrating them into reports, and analyzing multi-dimensional information.
Pyramid offers diverse analytics options, including statistics, visualizations, prediction capabilities, and comprehensive ETL processes.
The platform supports DAX queries robustly, often outperforming other top-tier analytics tools.

CONS

Pyramid Analytics is considered a heavy, time-consuming tool for developers.
The number of charts and components could be expanded to match competitors like Brain Power BI.
It lacks a feature to generate a data dictionary that outlines original physical tables, renamed fields, and derived fields.
The functionality for each step is not well-defined and requires improvement.
Data refresh speeds need enhancement, particularly for large datasets.
 

Pyramid Analytics Pros review quotes

reviewer1486161 - PeerSpot reviewer
Senior Consultant at a tech services company with 51-200 employees
Jan 15, 2021
It seems quite performant in analyzing multi-dimensional information sets and presenting them.
reviewer1099803 - PeerSpot reviewer
Data Analyst at a comms service provider with 51-200 employees
Jan 4, 2022
The on-premise version has quite good scalability.
Roman Domin - PeerSpot reviewer
Senior Consultant at Adastra Česká republika
Mar 9, 2023
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.
Learn what your peers think about Pyramid Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
880,435 professionals have used our research since 2012.
Shyam Pendyala - PeerSpot reviewer
Manager, BI Platforms at Refinitiv, an LSEG Business at LSEG (London Stock Exchange Group)
Sep 12, 2023
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.
Coby Jefferson Gardner - PeerSpot reviewer
Data Consultant at Align BI
Sep 18, 2023
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.
RA
VP DATA at Nogamy
Sep 19, 2023
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.
David Carbery - PeerSpot reviewer
Data Analytics Consultant at Snap Analytics
Oct 2, 2023
The features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job.
SK
Software Developer at a tech consulting company with 51-200 employees
Nov 28, 2023
The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries.
Ynazif Nazif - PeerSpot reviewer
CEO & Principal Consultant at Pyramid Analytics & Consulting
Dec 11, 2025
After implementing Pyramid Analytics for my clients, I have seen measurable outcomes and specific improvements, such as having a single platform that gets them from the raw data to the endpoint reporting.
 

Pyramid Analytics Cons review quotes

reviewer1486161 - PeerSpot reviewer
Senior Consultant at a tech services company with 51-200 employees
Jan 15, 2021
The general amount of negative comments that I am hearing from my team makes me very wary.
reviewer1099803 - PeerSpot reviewer
Data Analyst at a comms service provider with 51-200 employees
Jan 4, 2022
I find that this is quite a heavy, time-consuming tool for developers.
Roman Domin - PeerSpot reviewer
Senior Consultant at Adastra Česká republika
Mar 9, 2023
I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI.
Learn what your peers think about Pyramid Analytics. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
880,435 professionals have used our research since 2012.
Shyam Pendyala - PeerSpot reviewer
Manager, BI Platforms at Refinitiv, an LSEG Business at LSEG (London Stock Exchange Group)
Sep 12, 2023
It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields.
Coby Jefferson Gardner - PeerSpot reviewer
Data Consultant at Align BI
Sep 18, 2023
Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved.
RA
VP DATA at Nogamy
Sep 19, 2023
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.
David Carbery - PeerSpot reviewer
Data Analytics Consultant at Snap Analytics
Oct 2, 2023
There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid.
SK
Software Developer at a tech consulting company with 51-200 employees
Nov 28, 2023
Pyramid Analytics could improve by speeding up data refresh, especially for large datasets.
Ynazif Nazif - PeerSpot reviewer
CEO & Principal Consultant at Pyramid Analytics & Consulting
Dec 11, 2025
As for how Pyramid Analytics can be improved, I wish that there was a greater degree of customization available.