We performed a comparison between Microsoft BI and Oracle Essbase based on real PeerSpot user reviews.Find out what your peers are saying about Microsoft, Tableau, Amazon and others in BI (Business Intelligence) Tools.
"The stability is great and continues to get better and better."
"The one feature most of our customers like is data visualization. When we were doing BI directly from SQL, most users found it challenging to create their own reports. Power BI has self-serve analytics that the end-users can do themselves. On most projects, people are primarily using data visualization and self-serve analytics."
"It's a straightforward setup."
"The stability is good."
"The most valuable feature is definitely the visual aspect and the DAX capabilities to virtually do anything."
"My understanding is that the initial setup is pretty easy."
"What I like about Power BI is how fast you are able to create dashboards and how fast you are able to fetch the data. You can connect to the database or data source, and then you can design your dashboards very easily."
"The data can be accessed from anywhere."
"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."
"It helps us fetch specific data sets per users' requirements."
"Essbase is extremely stable and low-maintenance."
"I have found the most valuable aspect is the user-friendly environment and current features."
"I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity."
"I believe the price should be degressive, and we should have a lower, or better unit price if we have more users."
"The look and feel should be updated in terms of the types of dashboards and graphs that you can produce. They aren't as visual as some of its competitors."
"Most of the dashboarding tools have prebuilt graphs. So, you have to stick with them, unless you are going to use a third-party tool to create them, and then you are going to upload them to the BI tool. In Power BI, they started supporting this functionality and created a tool for that, but it isn't yet complete and mature. It is still exceeding the expectations and is better than most of the BI tools when it comes to creating custom graphs, but it needs more enhancement and simplification. It would be good to have a design tool provided by Power BI to design the graphs that we want and set the figures that we want on them."
"I find the solution to be 70 percent stable."
"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."
"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."
"The UI looks awkward once the graphs have been generated in the console. This is what Microsoft can work on."
"They should improve the solution's performance."
"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."
"It's an expensive product to use."
"The initial setup could be simplified."
"The ability to drive external reporting out for development could be improved."
Microsoft BI is a business intelligence solution that connects to all your data sources and turns your data into insightful and useful business information that is relevant to all levels of the business, ensuring data accuracy, consistency, and security.
Microsoft BI combines familiar Microsoft tools - Office, SharePoint, and SQL server - with extra features for end-users, such as Power View and Power Pivot. This powerful product gives businesses a competitive advantage by allowing end users to better analyze their data, collaborate, and better present their data.
The BI platform empowers members of your organization to make data-driven decisions that drive strategic actions quickly by allowing them to work together easily on the same data, share insights, and collaborate on reports using other Microsoft Office applications.
Microsoft BI Benefits
Some of the benefits of using Microsoft BI include:
Reviews from Real Users
Microsoft BI stands out among its competitors for a number of reasons. Two major ones are its integration options and its data analytics capabilities.
Tariq R., an operations & BI analyst at American Hospital Dubai, writes, “Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. 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. ”
Oracle Essbase is an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications or developing custom analytic and enterprise performance management applications.
Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 101 reviews while Oracle Essbase is ranked 9th in Database Development and Management with 7 reviews. Microsoft BI is rated 8.0, while Oracle Essbase is rated 8.2. The top reviewer of Microsoft 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 BI is most compared with Amazon QuickSight, Tableau, KNIME and Domo, whereas Oracle Essbase is most compared with SAP BusinessObjects Business Intelligence Platform, Oracle Analytics Cloud, SAP Analytics Cloud, IBM Cognos and Tableau.
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.