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 solution has a good toggling feature."
"Data integration enabled my organization to easily pool data from our varied system into one data warehouse."
"The drill-down capabilities and automatic charts are the best ones. The visualization is also very good. In terms of visualization, no competing product, such as IBM Cognos or any other product, has the same capabilities."
"Previously we used Excel, which took a long time - two or three weeks - to bring the data into a uniform format, whereas BI can do the same job in a day."
"Initial setup was very straightforward. Users can get up and running reporting on databases within minutes."
"I think the visualization part is valuable."
"It is very good, and it supports the Microsoft ecosystem, including Excel, etc."
"The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive."
"It is highly efficient and easily scalable, particularly for handling large databases."
"It helps us fetch specific data sets per users' requirements."
"It is very fast compared to other normal databases, like SQL and MySQL."
"The solution is stable and reliable."
"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 can handle a large volume of data."
"I have found the most valuable aspect is the user-friendly environment and current features."
"Essbase is extremely stable and low-maintenance."
"The product could have better analytics capabilities."
"It needs an AI which can choose the appropriate connection strings and provide options for connections."
"Real-time refreshing for SAP BW would be nice. We know its on the radar for the development team at MS. "
"Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data."
"It should be more user-friendly and simple."
"It is definitely a wonderful analytics tool. However, database ETL, data integration functionality would be absolutely perfect in many cases. Currently, it doesn't get the job done and we need to extract, transform, and load the data from faulty data sets into something more suitable for the deployment of the analytics tool."
"Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is."
"There is room for improvement in terms of pricing for the solution."
"The ability to drive external reporting out for development could be improved."
"The initial setup could be simplified."
"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."
"I would like to see an integration with application performance management and a version control management tool."
"It's an expensive product to use."
"They should improve the solution's performance."
"The consolidation engine, which is HFM or FCCS, needs some room for improvement."
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, IBM Planning Analytics, Tableau and Oracle Analytics Cloud.
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.