We performed a comparison between Microsoft Power BI, Oracle Essbase, and Pyramid Analytics based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools."The initial setup is simple to do."
"The advantages of Microsoft Power BI stem from the fact that it is really easy to use. The drag and drop facilities provided by the product are good."
"It is easy to use. It has got a desktop where people can develop their own dashboards. Basically, we have figured out how to connect finance contracts and all programs for the government agency. So, they can see everything in a dashboard. So, it is very easy to use from a technical standpoint of view."
"The initial setup is straightforward."
"As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools."
"In my experience the scalability is good. You are able to increase users and add more data."
"The initial setup is straightforward."
"I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story."
"The solution can handle a large volume of data."
"I have found the most valuable aspect is the user-friendly environment and current features."
"It helps us fetch specific data sets per users' requirements."
"It is highly efficient and easily scalable, particularly for handling large databases."
"The solution is stable and reliable."
"The solution is scalable."
"Essbase is extremely stable and low-maintenance."
"Unlike relational, where you're linking together multiple tables, with Essbase, you basically define what the dimensions are beforehand, and you define the hierarchy, and then load the data. This allows you to do a pretty sophisticated analysis so that you can drill into it and slice and dice the data."
"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."
"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."
"It seems quite performant in analyzing multi-dimensional information sets and presenting them."
"The features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job."
"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."
"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."
"The on-premise version has quite good scalability."
"The most valuable feature of Pyramid Analytics, outshining even top-tier platforms like Power BI, is its robust support for DAX queries."
"Power BI's administration could use some work, and the user experience needs to improve because it is a client-based tool. If you want to generate a model or report, you need to use client tools, but client tools are limited for end-users who don't have enough hardware. For example, maybe a client lacks enough memory or CPU power for report generators. If you use a model that requires a massive amount of data, your client will face several problems."
"Microsoft has got a very large repository of all change suggestions which have been raised by the BI community. They keep on adding features that are very widely sought after by the community. We don't focus on product features. We focus on business requirements. To use the solution, we find that existing features are good enough and offer us a very effective solution."
"I would like to see a more user-friendly interface with Microsoft BI."
"It needs more analytic tools."
"Areas for improvement would be the construction of reports and the dashboard budget."
"I would like to see some AI incorporated into this solution in the future."
"The way you navigate the product, compared to other products in this industry, that could be improved a bit."
"When I create measures, sometimes the error messages aren't clear. It makes me spend more time searching for solutions. I need the error messages to be more specific. So, I would like clearer error messages when creating measures."
"I would like to see an integration with application performance management and a version control management tool."
"It's an expensive product to use."
"They should improve the solution's performance."
"The ability to drive external reporting out for development could be improved."
"The initial setup is pretty complex."
"There is room for improvement in terms of cost-effectiveness."
"The initial setup could be simplified."
"Essbase has a programming language, and it has a couple of functions to do forecasting, however, their feature set for that is not that good."
"There is room for improvement in terms of documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."
"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 general amount of negative comments that I am hearing from my team makes me very wary."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
"I find that this is quite a heavy, time-consuming tool for developers."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."