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."Microsoft BI allows us to connect to any database or any dataset."
"Scalability-wise, I rate the solution a nine out of ten."
"It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
"Previously we used Excel, which took a long time - two or three weeks - to bring the data into a uniform format, whereas BI can do the same job in a day."
"In my opinion, Microsoft BI is a low-cost solution, and it could be an interesting solution for a tourism company."
"It is useful for bringing visualization to data. It calculates counts, ratios, etc."
"Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports."
"The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter."
"The solution is stable and reliable."
"The solution is scalable."
"The solution can handle a large volume of data."
"I have found the most valuable aspect is the user-friendly environment and current features."
"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 helps us fetch specific data sets per users' requirements."
"Essbase is extremely stable and low-maintenance."
"It is highly efficient and easily scalable, particularly for handling large databases."
"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."
"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 features I find most valuable are 'Discover,' 'Formulate,' and 'Model.' I use them regularly to build logic and create reports for my job."
"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."
"It seems quite performant in analyzing multi-dimensional information sets and presenting them."
"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."
"The solution doesn't integrate well with third-party tools."
"It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI."
"Real-time refreshing for SAP BW would be nice. We know its on the radar for the development team at MS. "
"It is too slow. I hope in future it will be a comparable big data tool, such as, for example, Data Lake."
"Lacks the ability to copy data from BI into PowerPoint."
"BI is scalable, but there are some problems with limited online storage."
"There are some other visuals that are available in the Microsoft marketplace, however, you need to use them via trial and error. There needs to be a write-up about how to use them with a quick guide describing the visual."
"The solution could be more customizable and you do not have too much freedom on the code."
"I would like to see an integration with application performance management and a version control management tool."
"They should improve the solution's performance."
"The initial setup could be simplified."
"It's an expensive product to use."
"There is room for improvement in terms of cost-effectiveness."
"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."
"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 documentation and examples, especially for newcomers like me who are learning both business intelligence and Pyramid."
"I find that this is quite a heavy, time-consuming tool for developers."
"Even though the solution has a functionality for every step, it's not so well- defined. That needs to be improved."
"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."
"Pyramid Analytics could improve by speeding up data refresh, especially for large datasets."
"I think the graphic number of charts and components could be higher, at least comparable to Brain Power BI."
"It would be desirable to have the possibility to generate a data dictionary, detailing the original physical tables, renamed fields, and derived fields."
"The general amount of negative comments that I am hearing from my team makes me very wary."