Microsoft Power BI vs Oracle Essbase comparison

"The most valuable features in Microsoft BI are the analysis using the feature drag and drop function. It's very easy to load and use different data sources."

"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."

"It's pretty easy to set up the product."

"The solution has a good toggling feature."

"In contrast to what we were using before I think that Power BI has given us more extensive results."

"The use of graphics to show and view the data indicators is the most valuable feature. It is also very stable."

"The stability is good."

"The most valuable features of Microsoft BI are its intuitiveness and ease to use."

"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."

"Essbase is extremely stable and low-maintenance."

"The solution is scalable."

"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."

"It is very fast compared to other normal databases, like SQL and MySQL."

"It helps us fetch specific data sets per users' requirements."

"The solution can handle a large volume of data."

"If I have to update data automatically, where I have to pin the gateway, it doesn't update. There is a scheduled refresh functionality so that it refreshes automatically, but I find it very hard to make it work."

"Microsoft BI comes under pressure when there is a lot of data to be crunched. It gets slower and slower, and the functionality becomes a bit of a problem. The performance goes down with data being fed into the system. The infrastructure requirement also increases if you have to increase the performance. This is the area that can be improved in my opinion. Initially, the product is good, but over the years, when data gets accumulated, it becomes a problem unless the old data is kind of archived and is no longer shown on the visualization. It has a feature by using which a user can query for a report through simple questions to a bot. So, if I want to look for the customer share of revenue by geography, I just simply state that in the chatbot. If I wanted it in a pie chart, then you say, "Please show it to me in a pie chart." It comes out well for basic charts. This feature should be improvised more so that people can very quickly get customized reports on the go."

"From any improvement perspective, I want the product to be made available to users free of cost...The stability and scalability of the product can be better."

"This solution needs integration with SAS and more deep analysis functionality."

"People without private emails cannot publish and, frankly, this doesn't allow for easy training."

"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."

"Capacity could be improved."

"The dynamic browsing tables could be better in Microsoft Power BI."

"The ability to drive external reporting out for development could be improved."

"The consolidation engine, which is HFM or FCCS, needs some room for improvement."

"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."

"The solution could enhance business analytics. I delved into the data using Oracle Essbase to create a new support tool."

"I would like to see an integration with application performance management and a version control management tool."

"The initial setup could be simplified."

"They should improve the solution's performance."

"We pay on a monthly basis which is approximately $10 per user on the Microsoft Power BI Pro license. At the moment we are still down at 400 users, but once we reach 500 users, we will move to the premium edition. The premium is $5,000 for unlimited users. Currently, with the 40 users, the cost is roughly $500."

"Price is the best feature of Power BI! You get a lot of value for the price. If you know how to use it, it's a great BI solution for your money."

"We have premium licenses, but you can use it for free. You can share the content with anyone else, so you can use it for free."

"The Report Server is pretty expensive on-premise. But as long companies are happy to use the cloud version, that's very cost effective."

"My company needs to make monthly payments towards the licensing costs attached to the product."

"I would rate them 4 out of 5 for their current pricing. There are no additional costs to the standard licensing fees."

"They have a free Power BI Desktop version, but it has limitations."

"Downloading Power BI Desktop is free."

"I believe the licensing is on a monthly base."

"It is a costly solution."

"Essbase is competitively priced."

"The solution is expensive."