We performed a comparison between Microsoft Power BI and Oracle Analytics Cloud based on real PeerSpot user reviews.
Find out in this report how the two BI (Business Intelligence) Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."There is a lot of help and documentation on the Internet, so no special training is needed to use the source code."
"The good part of it is that you can do whatever you want with it when it comes to building BI. In terms of languages, it supports Python, and it also natively supports R."
"We find the solution offers good stability."
"Microsoft BI's most valuable feature is flexibility."
"Two valuable most features are the ability to create columns and create measures."
"I like the flexibility it offers."
"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."
"The product is easy to use and simple to navigate."
"The most valuable features of the solution are dashboarding and data visualization."
"I've discovered that the new layout of this product makes Docker sharing, machine learning support, and data backups more efficient. Unlike the older method of linking physical, pre-logical, and presentation layers separately, the new interface simplifies this process. Additionally, the integration of databases and machine learning is seamless, with the new visualization approach being particularly beautiful and highly beneficial."
"Data preparation is fantastic and fast. We were able to use multiple data sources and prepare the data quickly."
"It's robust. It has the ability to handle massive amounts. After reporting has been developed, there is an ease of use or a user-friendly interface for a trained workforce."
"It's valuable feature is that it is user-friendly and doesn't require much time for understanding. The solution is stable. The initial setup was straightforward."
"The AI/ML enablement is useful, as many reporting tools do not offer machine learning models as of now, without writing customized code."
"The technical support services are good."
"It's really an enterprise solution. It has a dashboard, like standard dashboarding functionality. It also has reporting capabilities for producing pixel-perfect reports, bursting large volumes of a document if you need to. It has interactive data discovery functionality, which you would use to explore your data, bring your own data, and merge it with maybe the data from an enterprise data warehouse to get new insights from the pre-existing data. It has machine learning embedded in the solution. If you're new to machine learning, it's a really good way to get into it, because it's all within this platform, and it's really easy to use."
"Not having to login again after a mobile app upgrade. A simple login on mobile would be great."
"SSMS & SSRS."
"Microsoft Power BI was born native on the cloud, however, it's quite difficult when it has to connect to on-premise data sources."
"It is not the right tool to do deeper analysis or predictions. When you have some data and you want to do some deep analysis, there is no feature to help you with this."
"They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. They can make it easier to create some of the reports. They can also include predefined templates that you can directly use."
"It needs an AI which can choose the appropriate connection strings and provide options for connections."
"I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse. I have to search on the web for a solution because I don't have the tool for it."
"The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files."
"It should simplify data connectivity and modeling, making data extraction more streamlined and adaptable for diverse use cases."
"Sharing dataflows is not possible at this time, and the custom chart functionality is not available."
"The price of the solution could be lower."
"It's not a failure of the product; it's just an architectural choice. It has to do with data modeling. I'm comparing this to another product, which is Oracle's developer client and probably called Oracle BI Developer Client Tool. The data modeler, which is cloud-based, and Oracle BI Developer Client Tool, which is local or on-premises-based, both can do the same thing in data modeling. However, the cloud tool does not have as many features as the Oracle BI Developer Client Tool, which is closest to the OBIEE Administration Tool with full feature data modeling, metadata development, and so forth. In a complex environment or implementation, that is the capability that you need."
"The learning curve should be improved, and I'm uncertain if tutorials are readily available or easily accessible. We may have resorted to looking on YouTube for such information. Having easily understandable documents or guides for new users would be beneficial. AI integration would be an interesting feature to add in the next release."
"They could improve the ease of developing the dashboard and interacting with it."
"At this time, dataflows cannot be shared, but I think that this should be enhanced."
"The solution could be more flexible."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 293 reviews while Oracle Analytics Cloud is ranked 8th in BI (Business Intelligence) Tools with 23 reviews. Microsoft Power BI is rated 8.0, while Oracle Analytics Cloud is rated 8.0. 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 Analytics Cloud writes "Reliable, capable of handling massive amounts of data, and good value for money". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Oracle OBIEE, whereas Oracle Analytics Cloud is most compared with Oracle OBIEE, Databricks, Tableau, Oracle Business Intelligence Cloud Service and Qlik Sense. See our Microsoft Power BI vs. Oracle Analytics Cloud report.
See our list of best BI (Business Intelligence) Tools vendors.
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.