My main use case for Pyramid Analytics was that it was a new tool that the company had acquired for visualization, dashboarding, reporting, and similar tasks, which is what I was doing.
I worked on one report using Pyramid Analytics, where I had to get the data from an Oracle database, connect to it using PL/SQL, and perform all the transformations in the backend using SQL, and then load the data.
I wrote the query inside Pyramid Analytics, modeled the data inside the platform, and displayed a table as a report.
I believe the amount of features Pyramid Analytics offers is almost overwhelming.
The platform has a small ETL tool that is similar to Power BI query but a bit different, and it reminds me of SSIS, but I would not use it since the engine on Pyramid Analytics is more of a front-end based engine.
I would much rather do ETL transformations using SQL or another tool, but it is really nice for a beginner or maybe for quick transformations, and the modeling tools are also really nice.
I cannot accurately say how Pyramid Analytics impacted my organization positively, as I only used it for a few months before switching places, but the platform does have feature-rich visualization tools that allow you to visualize your data any way you want and build attractive dashboards.
I would not say Pyramid Analytics made reporting faster; it just offered more features compared to the previous tool, Sisense, which we used before switching to Pyramid Analytics, mainly because it also has a small ETL tool inside it.
Additionally, it has some machine learning features, but I did not get to use those.
I think Pyramid Analytics could be improved by making it less feature-rich, as too much choice and complex menus and sub-menus are a drawback.
I feel a visualization tool needs to be very simple.
Also, the calculations for measures are really complex, and the need to select checkboxes and navigate menus is frustrating.
I believe SQL or Python, which almost every developer can use, is much easier.
However, this is the tool that the company offers.
I have been working in my current field for four years and have been doing AI engineering for the past one and a half years.
Pyramid Analytics is stable in my experience.
I cannot answer how Pyramid Analytics's scalability is because during my time working with it, there were many data teams that each had access to Pyramid Analytics and could develop their projects.
Given that it was used in a bank with a massive infrastructure and servers, it seemed pretty stable and scalable, working perfectly fine.
Customer support was really good; they taught us how to use the tool, which was helpful since there is not much documentation available online because it is a fairly new startup with a small user base.
They brought in teams to assist us, and the customer support was awesome.
I previously used Power BI and worked with Tableau after Pyramid Analytics, as these were the tools provided by the respective companies I worked in, mainly for very basic reporting or basic dashboarding and simple visualizations.
My organization evaluated other options, including Power BI and Tableau.
We were using Sisense when I arrived and I worked with it for about a year before Pyramid Analytics was introduced and I used that for about three or four months until I left for a different company.
I liked that I could write my own query inside Pyramid Analytics and extract the data the way I wanted it, but I did not like that it was too complex to display just a simple report, with so many menus and sub-menus, and the calculations were a bit complex.
In the report itself, in the visual itself, it was pretty good and nice, but nothing special.
I have also used Tableau and Power BI for comparison, and while Tableau is much easier to work on, it lacks the ETL transformation features found in Power BI and Pyramid Analytics.
Overall, I think Pyramid Analytics is the top visualization tool because it is easier to work with, and it has lots of features, which depends on how you are going to use it.
If you are just going for very basic reporting and transformations, it is a good fit, but for more complex needs, I prefer a different tool for ETLs, while using Pyramid Analytics primarily for visualization.
I would rate Pyramid Analytics a seven as the more conservative option.
I choose seven specifically because I think this tool is really good for people who are not developers.
As a developer, I work a lot with Python or SQL, which makes it easier to extract data and perform calculations, but if you are not a developer, it is easier to use checkboxes and if-then conditions.
The problem arises for developers who are frustrated when using those features.
Therefore, it serves more as a use case, and someone not versed in development would likely enjoy it and find it effective for analytics, while developers might find it cumbersome, leading me to rate it a seven.
I did not know Pyramid Analytics has AI capabilities; perhaps it is a new feature that was added after I used it.
I have no experience with Pyramid Analytics' AI capabilities, specifically regarding its accuracy and reliability of outputs, so I would rather not answer that and potentially provide incorrect information.
I would advise that if the user is a developer, they should use Pyramid Analytics as a visualization tool, managing the logic themselves and just loading the data, modeling it by connecting tables to display the data.
If the user is not a developer, I would recommend getting deeper into learning how to use the tool properly, as it can be a bit cumbersome yet allows for a lot of functionalities.
My overall rating for Pyramid Analytics is seven.