We performed a comparison between Microsoft Power BI and Oracle Essbase based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Tableau, SAP and others in BI (Business Intelligence) Tools."The most valuable feature is that it's easy to use. It's very useful for non-engineers and it is the ultimate solution for providing information and insights. Power BI is the best visualization tool I have ever worked with."
"The best feature of this solution is the way you can plan, communicate, and visualize all the knowledge you extract from the data for the customers. I like the way you can show or visualize the information a client needs to answer a business question."
"Power BI has strong support from Microsoft. If you need help, they answer promptly. There are also several discussion groups where you can get information, like the product roadmap and any new things coming up."
"The solution integrates with other Microsoft solutions very well."
"In the process of using data there is the Extract, Transform and Load (ETL). For extracting we are using another software, for transforming we are using our own coding in C#, and then we use Microsoft BI for loading the information. Microsoft BI displays information very well."
"Allows business users with a mission to solve their own problems, without an IT person."
"Power BI allows you to create user defined charts which is really useful."
"It is low-cost and easy to deploy. It is fully-featured."
"Essbase is extremely stable and low-maintenance."
"It is very fast compared to other normal databases, like SQL and MySQL."
"It is highly efficient and easily scalable, particularly for handling large databases."
"It's a very powerful analytical engine with Essbase as the back end. We can analyze, transform, or utilize a big chunk of data for our calculations."
"The solution is stable and reliable."
"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."
"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."
"I would prefer that the solution not be shared. I'm concerned that if we make a mistake we could reveal information to people who shouldn't see it. I would like to have my own on-prem server, to buy my own server and have my own infrastructure for Microsoft BI, with only with my data."
"The accounting data needs improvement."
"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."
"If you need data in real-time, it's not an ideal solution."
"The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files."
"For someone who is new, I think that Power BI can be a little complicated."
"BI is scalable, but there are some problems with limited online storage."
"It is easy enough. I don't see any real substantial improvements that are needed. It is great as it is, but its interface could be a bit modern."
"It's an expensive product to use."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
"The initial setup is pretty complex."
"The reporting tool of Essbase needs improvement."
"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."
"They should improve the solution's performance."
"The ability to drive external reporting out for development could be improved."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews while Oracle Essbase is ranked 10th in Database Development and Management with 12 reviews. Microsoft Power BI is rated 8.0, while Oracle Essbase is rated 8.4. The top reviewer of Microsoft Power BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". On the other hand, the top reviewer of Oracle Essbase writes " Handles a huge amount of data at a time and offers good processing speed". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME and Domo, whereas Oracle Essbase is most compared with SAP BusinessObjects Business Intelligence Platform, SAP Analytics Cloud, Tableau, Oracle Analytics Cloud and IBM Planning Analytics.
We monitor all BI (Business Intelligence) Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.