We performed a comparison between Microsoft Power BI, Oracle Essbase, and Pentaho Business 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 most valuable feature is integration with Python."
"The user interface is easy to work with."
"You can learn a lot of things quickly using resources like ChatGPT or Microsoft's own solutions, which are very helpful within the Microsoft ecosystem."
"The drag and drop facility to easily change the data correctly is the most valuable feature. I am happy to see visualizations. It's easier to talk about and make people understand what is going on."
"It has greatly improved our reporting capabilities."
"It's a pretty scalable product."
"Key features are its dashboard functionality and ease of integration with various data sources."
"The initial setup is simple to do."
"It is highly efficient and easily scalable, particularly for handling large databases."
"It helps us fetch specific data sets per users' requirements."
"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."
"The solution can handle a large volume of data."
"The solution is stable and reliable."
"I have found the most valuable aspect is the user-friendly environment and current features."
"The solution is scalable."
"I use the BI Server, CDE Dashboards, Saiku, and Kettle, because these tools are very good and highly experienced."
"The most valuable feature of Pentaho is the Tableau report."
"Easy to use components to create the job."
"Pentaho Business Analytics' best features include the ease of developing data flows and the wide range of options to connect to databases, including those on the cloud."
"Pentaho is an analytics platform that can be used when an organization has a lot of big data storage systems already installed and needs to manage and analyze that data. It has a specific use case for unstructured data, such as documents, and needs to be able to search and analyze it."
"We were able to install it without any assistance from tech support."
"The initial setup is pretty straightforward."
"Right now, their premium pricing is keeping us out of the premium market. The premium price per user just doesn't make sense for us, but we haven't reached the limit of 500 users to justify the premium."
"There are some problems with the functionality of this solution. The dashboard is not very user friendly and is quite complicated."
"Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product."
"My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack."
"I think that the solution is harder to use for people who are not experts in data."
"There is no specific area that I have a problem with. It's just that, with whatever feature you come across, every visual has its own formatting and behavior. What you get in one visual for a feature, you don't seem to get in another."
"SQL Server Reporting Services (SSRS) is not user friendly."
"The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features."
"The ability to drive external reporting out for development could be improved."
"It's an expensive product to use."
"The initial setup is pretty complex."
"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."
"I would like to see an integration with application performance management and a version control management tool."
"There is room for improvement in terms of cost-effectiveness."
"The initial setup could be simplified."
"They should improve the solution's performance."
"Pentaho, at the general level, should greatly improve the easy construction of its dashboards and easy integration of information from different sources without technical user intervention."
"Pentaho Business Analytics' user interface is outdated."
"Logging capability is needed."
"The repository should be improved."
"Version control would be a good addition."
"We did not achieve the ROI. The work delivered to users had lesser value than the subscription cost."
"Deployment is not simple. It is not simple because we are dealing with a lot of data; we are dealing with a lot of storage. So, it's not a simple process."
"Another concern is that Pentaho is not customizable or interactive."