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."Power BI is more powerful than other tools because it is new for us. Each new version has more capabilities, and we're expecting AI and ML features in the next version."
"The fact that you can visualize items is great."
"MS SQL & SQL Server Analysis Services."
"The most valuable feature of Microsoft Power BI is the drill-through feature that takes you to a details page the users want to see."
"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."
"In the early stage of an implementation, it not only helps decision making, but it allows people to have insight into problems with data so that they can go and get it corrected."
"Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis."
"SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components."
"The solution is stable and reliable."
"It helps us fetch specific data sets per users' requirements."
"The solution is scalable."
"The solution can handle a large volume of data."
"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 have found the most valuable aspect is the user-friendly environment and current features."
"It is highly efficient and easily scalable, particularly for handling large databases."
"Essbase is extremely stable and low-maintenance."
"The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features."
"Microsoft BI’s integration and visualization could be improved."
"There is no column-level security in Microsoft BI, and this is a feature that most of our customers are looking for. That is something that should be implemented."
"In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility."
"It could have more of a hold on big data. Manipulating big data on this solution complicates things. This needs to be improved."
"A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution."
"I believe there is room for improvement in terms of authentication and certain functionalities in Power BI. For instance, adjusting the width of columns is not easily done, as there is only an option to enable or disable automatic adjustment. This can be a significant drawback for clients who desire more flexibility."
"Power BI shows reports on actual data, not metadata."
"I would like to see an integration with application performance management and a version control management tool."
"The ability to drive external reporting out for development could be improved."
"The initial setup is pretty complex."
"It's an expensive product to use."
"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."
"There is room for improvement in terms of cost-effectiveness."
"The initial setup could be simplified."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 22 reviews while Oracle Essbase is ranked 10th in Database Development and Management with 8 reviews. Microsoft Power BI is rated 8.0, while Oracle Essbase is rated 8.4. The top reviewer of Microsoft Power BI writes "User friendly, easy to set up and great for analyzing data". On the other hand, the top reviewer of Oracle Essbase writes "Everybody uses it for financial purposes, but it can also be used for other analytic purposes, such as mathematical models, statistical models, and so on". 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, Oracle Analytics Cloud, Oracle OBIEE 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.