I have used Pyramid Analytics at a few different projects. I used it at the VA, at the Department of Health and Human Services, and on a couple smaller projects for some smaller customers that were using that platform.

My main use case for Pyramid Analytics is to integrate data, do visualizations, or presentations and conduct BI type work in order to communicate where the organization is at or where they are in a particular project or updates in terms of marketing sciences and campaigns.

A specific example of how I used Pyramid Analytics stands out when we were doing the project at the VA, where we were doing site reliability engineering. We had a bunch of enterprise platforms that were getting migrated to newer platforms. We had smaller technology suites that were getting upgraded or moved. We were integrating a lot of those projects and using Pyramid Analytics to manage that data. We could report on where we were, what progress we had, and what we were doing, and I used some of the interactive features in order to help with the technical side of it.

The best features Pyramid Analytics offers include a broad range of features, which I think is one of the advantages of it. It has a lot of connectors and a lot of different capabilities. I would say end-to-end capabilities is one of the nice features of it.

Regarding the end-to-end capabilities and lots of connectors, I found the connectors most valuable. If you are trying to do Snowflake, SQL server, or any of the normal database platforms that you see in the cloud or on-premises, it has those connectors built in. You don't have to worry about writing custom drivers. That is a nice feature to have.

Pyramid Analytics has impacted my organization positively in that I use it for my clients' organizations. For my organization, it is great because it gives me a technology platform that clients enjoy using and I am proficient with. For my clients, it is about delivering on their aspirations in terms of what they want to do with their data and where they want to head in their organization. This is definitely a tool that we can use in order to get there.

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. I think that streamlining has a positive effect on the quality of the outputs. The quality of the outputs definitely leads to better decision making.

As for how Pyramid Analytics can be improved, I wish that there was a greater degree of customization available. Any advanced user wants to implement an idea that they have, and while the whole idea of a platform is not necessarily to give a custom solution, I would not mind if they had more in terms of AutoML or that sort of capability. I think that is becoming significant now, and I think that would be a good thing to implement.

I did not purchase Pyramid Analytics through the AWS Marketplace; the client did all of the purchasing. I just arrived on scene and began to use the platform.

Pyramid Analytics is stable in my experience; there have not really been issues with downtime or bugs. It has some bugs here and there, but overall, I would say that it is probably better than average in terms of bugs. In particular, it did not have any of those severe bugs that cripple operations. It had some small bugs but nothing that was more than slightly irritating, nothing operationally hindering or that was causing issues with the data pipelines. Everything was good quality overall.

Regarding Pyramid Analytics' scalability from what I have seen, with the right people managing it, it can handle growing amounts of data and users well. When you are talking about scale, if you do not have the right people managing it, then it does not matter what technology suite you are using. Is it the best thing to scale for very large data sets? I am not sure, but definitely for small to large data sets, it is not a problem.

Customer support for Pyramid Analytics is good from what I have seen or heard from my clients. I never had to use them because we did not experience any of those severe bugs, so there was not much of a reason to call customer service. The one time we had an issue related to something with the logins, they addressed it that morning. We had an issue maybe around 8:00 or 9:00, and I think by 11:30 it was cleared up. I would say that is a good response time.

Before choosing Pyramid Analytics, I think my clients evaluated other options and they had looked at Tableau prior to the switch. I think they were looking at the Tableau server and in-house databases. I think that was much more difficult to manage than having a single platform.

I did not purchase Pyramid Analytics through the AWS Marketplace; the client did all of the purchasing. I just arrived on scene and began to use the platform.

I would say that there is a positive return on the data investment for my clients using Pyramid Analytics. In other words, there are a lot of resources going into what we are doing with the data, and is what we are getting out of it worth the inputs? I would say for both what we saw at the VA in terms of the modernization, as well as some of the smaller projects, the return on the data investment was positive.

Regarding my experience with pricing, setup cost, and licensing for Pyramid Analytics, I have to be honest, I did not observe any of it. They already had the platform in place when I got there. From my perspective, it was just operational execution. I was not involved in any of the decision-making that went into selecting it or any of the review process for how they were fairing with it.

Before choosing Pyramid Analytics, I think my clients evaluated other options and they had looked at Tableau prior to the switch. I think they were looking at the Tableau server and in-house databases. I think that was much more difficult to manage than having a single platform.

I believe Pyramid Analytics is a good platform with a lot of features and capabilities. It does not do everything, but most platforms do not do everything. I would give Pyramid Analytics a rating of 8 out of 10.

My advice to others looking into using Pyramid Analytics is to pair it with a good administrator. Whoever you are choosing for an administrator, you want to choose someone that has both the data skills and the people skills in order to maximize what you are going to get out of Pyramid Analytics.

I think Pyramid Analytics is really a good platform with a lot of good things going for it. If someone is considering it, it is definitely not the wrong decision.

Pyramid Analytics is a great tool for digging into data from different angles. It is like a supercharged version of Power BI, offering a smart way to analyze information over time and other dimensions. With Pyramid, you can easily create detailed reports that provide timely and intelligent insights. It is a user-friendly platform that makes data exploration and decision-making easy.

At my previous job, we used Pyramid Analytics for a healthcare client, and it made a big impact. They wanted to predict patient visits using machine learning. With Pyramid, we analyzed five years of clinical assessment data and forecasted how often patients would visit each site. After six months, our regular analysis showed that Pyramid accurately predicted visits around 80% of the time. This was a huge benefit in implementing the healthcare plan, providing valuable insights for better planning and resource allocation.

The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries. This capability enhances data analysis significantly, making Pyramid a versatile and powerful tool for deriving insights from complex datasets.

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 systems and potentially move to the cloud for faster reporting. There is also room for improvement in supporting additional reporting formats like D3.js and web reports.

I have been working with Pyramid Analytics for five years.

I would rate the stability of Pyramid Analytics at around a six out of ten. While it is not exceptionally stable currently, there is ongoing improvement as the tool evolves at a faster pace.

I would rate the scalability as a nine out of ten. Currently, we have around 30 to 50 end users in our organization, with seven developers working on various business modules. Initially, we started with 15 users and have developed around 100 to 150 reports. While our current usage is at a maximum of 50 end users, we anticipate potential increases in the future, especially if there are any acquisitions.

I would rate their tech support as a ten out of ten.

I used Power BI, Tableau, and a bit of Click before switching to Pyramid Analytics. I made the switch because Pyramid has a more user-friendly interface with better features. It also supports multi-dimensional models, which was a key factor, something Tableau doesn't offer.

Deploying Pyramid Analytics was quite straightforward. The deployment involved a small admin team of two to three people, while the overall team size was around 15 to 20, including seven business intelligence specialists. In terms of maintenance, it is minimal, typically requiring only a patch upgrade every six months. Overall, it is a low-maintenance solution once it is up and running.

We have seen a significant return on investment with Pyramid Analytics. For instance, in forecasting patient visits to urgent care facilities, we achieved an 80% accuracy, allowing providers to plan and allocate resources more effectively.

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 with a three-tier or higher structure. It meets the needs well within budget.

My advice to anyone considering Pyramid Analytics would be that if you are a smaller organization with budget constraints but still need robust reporting metrics, Pyramid's mode could be the perfect fit. It offers all the necessary features and solid technical support at a more affordable cost. On the other hand, if you are a larger organization with a bigger budget, you might want to explore Power BI. While both platforms are similar, Power BI, being integrated with Microsoft, has the added advantage of seamless connectivity to Microsoft systems. They serve the same purpose, but Power BI is hosted by Microsoft. Overall, I would rate Pyramid Analytics as an eight out of ten.

I use it to create reports for my clients. These reports focus on traditional business topics like market share, share difference, and sales difference over different time periods. It helps us analyze and present data in a structured way.

The features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job.

There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid. I have occasionally struggled with understanding the syntax, so more extensive documentation with practical examples would be really helpful. Additionally, I have encountered challenges with loading large amounts of data into memory. While working in the cloud is fine, managing and processing data in memory has been a struggle. I have had to raise technical support tickets to address these issues.

I have been using Pyramid Analytics daily for about eight months.

On a scale of one to ten, I would rate the stability as a six. I have experienced an issue where I lost a lot of work, and it was frustrating. While it doesn't happen regularly, there have been instances of work being lost, including by a partner in Germany.

The scalability of Pyramid Analytics is quite high, I would rate it eight out of ten. At my company, six people use the solution, and we have about 100 clients who use it as well. We are considerably expanding the usage of the solution.

My experience with the support team has been positive. I have reached out for help with various issues, and I think they are attentive, supportive, and responsive. Overall, I find their support to be good.

We didn't use a different solution before Pyramid Analytics. We chose Pyramid primarily because it was the preferred choice of our major client.

The solution is not cheap, but its pricing is comparable to other BI tools on the market.

My advice for newcomers is to try to separate your work from understanding other data as much as possible. Start with public datasets or your own familiar data, like sports analytics, to learn the tool and its capabilities. This way, you can stretch yourself and explore various aspects of the tool without being limited by client expectations. Overall, I would rate the solution a seven out of ten.

It is a versatile business intelligence and analytics platform that can be used for various purposes including creating medical services dashboards, supply chain dashboards, and leveraging AI capabilities. It allows connecting and analyzing data from multiple sources, creating models and visualizations, and collaborating with others.

It offers a unique and powerful feature called ''swapping'' which allows users to easily switch between columns and rows, and the platform automatically recalculates all the relevant measures accordingly. It provides extensive self-service capabilities, enabling users to customize visuals such as changing bars to circles. 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 platform has encountered several bugs during programming. Their support team collaborated with us to find solutions, even if the bugs were new to them as well. While they managed to eventually resolve issues, it is acknowledged that there may be some bugs that they did not anticipate, especially in regions where the platform is less commonly used. 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. The process currently requires making changes one by one, which can be tedious. The platform developers are aware of this limitation and they have been working to enhance the user experience and provide more efficient ways of modifying dashboards.

I have been using it for one year.

The stability is inconsistent, as sometimes it presents alerts upon opening a dashboard, but these alerts may disappear upon reopening. The stability depends on the complexity of the functions implemented in the dashboard. If sophisticated functions are used, there may be instances where the system encounters errors or struggles to determine the cause of the alert.

We obtained two hundred licenses, but we have only thirty to forty people who use Pyramid dashboard. It is a scalable solution.

Our experience with their customer support services is highly satisfactory. They have offices here, in Tel Aviv, and when I called them to report certain issues, they scheduled a meeting with me in their offices. During the meeting, I had the opportunity to discuss the issues encountered and provide necessary information. The bugs reported were promptly addressed and resolved within a week or two, with the support team conducting collaborative meetings to ensure efficient communication.

The initial setup was done easily and promptly.

After we evaluated several options like Power BI and Tableau, we decided to choose Pyramid Analytics. While Power BI is strong in cloud-based solutions, it lacks frequent updates for on-premises versions. As a result, Pyramid Analytics becomes the preferred choice as it offers robust features and frequent updates for on-premises data analytics.

When working on-premises, Pyramid Analytics offers several advantages over Power BI and Tableau. Despite some limitations in terms of programming, it offers extensive self-service capabilities and functions that cater to end-users needs. I would rate it eight out of ten.

The solution is used for high level reporting.

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.

Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved.

I have been using Pyramid Analytics over three years.

It is a stable solution. Sometimes there are bugs but most of the time, it is stable.

It is a scalable solution. Presently, 200 to 300 users are using the solution.

The technical team is very responsive.

The installation is done by third party vendors.

I have seen a return on investment.

There is a yearly cost which is between ten to twenty thousand per year.

The company decided on Pyramid Analytics because the pricing is good and we were in need of a BI platform. Plus it has a customer code and AI.

I rate the overall solution an eight out of ten.

It is mainly used by finance users in the Financial Planning and Analysis department. It works as a front-end application that enables access and analysis of finance data from various sources such as VIP and SAP. The interface has access to a specific multidimensional cube developed internally. The cube is built using MSAS. It allows users to explore financial data at a granular level and enables them to drill down or drill through to queue-based reports, providing better insights and analysis.

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. Its web-based nature ensures no client installation is required, making it easily accessible for users. The application also complies with fax regulations, requiring necessary approvals before adding users. The user-friendly interface, look, and feel of the application further contributes to its success in the organization.

Its ability to access different applications and offer development functionalities, along with the valuable feature of drill-down reports, enhances its usefulness in financial analysis and reporting.

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.

I have been working with it for five years.

It offers good stability. We didn't face any issues regarding it due to our multi-server environment with redundant task engines and downtime engines to ensure continuous operation. We have also upgraded our hardware configuration with more RAM and higher CPUs to enhance performance.

It is scalable, although we have not utilized all of its features. We faced some initial issues when integrating with Snowflake, but those were resolved in subsequent versions, leading to better performance. We developed direct query models instead of storing data internally within the application, which aids in dealing with larger volumes of data in the back end.

They provide a high level of customer service and support. I would rate it eight out of ten.

I was previously working with ProClarity, but they announced its retirement and lack of support for future versions. They had various issues and bugs, prompting the need for a more robust and supported solution.

We followed a set process of developing in dev, testing in QA, and conducting UAT before exporting and importing the model into production. Initially, we had to learn about the application from scratch and it took a couple of months to set up users, access, and familiarize with Pyramid Analytics. The finance teams were previously working with ProClarity and it took time to correlate their previous processes with the new tool. The main goal was to make users comfortable and provide support throughout the transition.

Finance teams appreciate Pyramid Analytics and have a positive opinion of the application in general.

The licensing cost is not excessively expensive, but it does increase with the addition of new features and modules. We only renewed our existing standard licenses and did not purchase any additional modules. The cost could be seen as reasonable, but it restricts access to only finance users. If expertise is required for developing and delivering solutions within Pyramid Analytics, consulting services may need to be hired, resulting in additional costs for the company. I would rate it seven out of ten.

It is a versatile and easy-to-maintain tool with connectivity to various databases. If the environment is highly secure and restrictive, configuring connections to systems like SAP or SharePoint may require overcoming network security restrictions and opening ports. There is no clear guidance on how to resolve these issues yet, so admin support is necessary for troubleshooting and analyzing logs or errors. I would rate it eight out of ten.