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.