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 performs well in analyzing multi-dimensional information sets and presenting them.
The on-premise version offers good scalability.
Its ability to drill down, dice in the loop, and support for DAX queries excels compared to platforms like Power BI.
Pyramid Analytics is versatile, providing a complete ETL process and extensive data source connectivity.
It offers a wide range of analytics options, including statistics, visualizations, and prediction capabilities for making forecasts.

CONS

Creating a data model in Pyramid Analytics is more complicated compared to other tools, especially Microsoft BI.
The tool is considered time-consuming for developers.
There is a need for generating a data dictionary to detail original physical tables, renamed fields, and derived fields.
Pyramid Analytics should improve on speeding up data refresh, particularly for large datasets.
There is a desire for a greater degree of customization in Pyramid Analytics.
 

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.
OB
Works at a comms service provider with 201-500 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: March 2026.
884,873 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.
OB
Works at a comms service provider with 201-500 employees
Feb 16, 2026
We just replaced our old reports and chose Pyramid Analytics because the technology moved on, and we do just well in supporting our customers with a reporting tool based on Pyramid Analytics.
 

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.
OB
Works at a comms service provider with 201-500 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: March 2026.
884,873 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.
OB
Works at a comms service provider with 201-500 employees
Feb 16, 2026
When creating a data model in Pyramid Analytics, it's a bit complicated compared to other tools, especially to Microsoft BI.