We performed a comparison between Microsoft BI and SAP Analytics Cloud based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Microsoft BI is the winner in this comparison. Its users give it higher marks in the customer support category. SAP Analytics users are happier with the pricing, however.
"Many of my customers already use Microsoft products like Office 365, so I often propose Microsoft Power BI because it integrates well with all the standard Microsoft business tools. And it's the quickest tool to implement and start using daily."
"It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
"One of the most valuable features of Power BI is the ease of use. It is comfortable and there is not a steep learning curve for this solution. If you have some idea of the data and basic visualization ideas, you can use this solution comfortably."
"We found the initial setup to be straightforward."
"Microsoft BI is scalable."
"There was a lot of manual work involved with Excel, whereas once we moved on to Microsoft Power BI, it was a cleaner dashboard and it was faster too."
"I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data."
"Other people can access data much more easily than before. Its usability is the main advantage, people in the company are using it."
"SAP Analytics Cloud is easy to create charts with, and is a stable business intelligence platform. Easy to set up solution."
"One feature I've found most valuable is discovery."
"It is scalable."
"The ability to collaborate and plan together is great."
"I like the connectivity the solution provides with other products."
"The Smart Predict, Smart Insights, and Smart Discovery predictive analysis features are quite good."
"Visualization is quite seamless and awesome. Once the data messaging is set up, it's straightforward and simple to select how it should be displayed. So, that's another advantage of SAP."
"The most valuable features are the visualization and user-friendliness."
"The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features."
"There is room for improvement in terms of pricing for the solution."
"I find the solution to be 70 percent stable."
"here are some limitations with the data models needed to build the report."
"This solution's performance when handling big data could be improved. Right now, if you're handling big data, the application becomes slow and the performance is very low."
"Real-time refreshing for SAP BW would be nice. We know its on the radar for the development team at MS. "
"One thing I would like to have is the scripting language, as they already have within Excel. It's already within a Microsoft business product, because Excel is the number one business product out there. So it would be nice to have the scripting capability in order to automate certain processes."
"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."
"It still lacks a lot of functionalities as compared to other tools such as Power BI or Tableau. Sorting is not working as well as it works in Tableau. A lot of other things are also not at the same level. Their technical support is not perfect and could be better. It takes a lot of time to have lacking functionalities implemented. Its integration with the BW backend should be better. Both solutions are from the same vendor. They position SAP Analytics Cloud as a reporting tool on top of the BW environment, but the integration between both is not yet 100%. For example, user management is still not synchronized."
"I would like to see reporting to the Analytics cloud directly."
"Sometimes there are speed issues with big deletion data."
"SAP Analytics Cloud requires a lot of coding and I would like the coding to be somewhat minimal."
"One area for improvement in SAP Analytics Cloud is incorporating Python into the coding. That functionality is available, but it's not as efficient, and it's a bit difficult sometimes to do it, so that could be improved."
"However, there are areas of improvement, particularly in terms of visualization. The front-end interface of SAP Analytics Cloud is not as impressive as Tableau and Power BI. The charts in other solutions have a more visually appealing and customizable look, while in SAP Analytics Cloud, there's a lack of alignment between numbers and charts. This graphical aspect, especially concerning charts, is not as satisfactory in SAP Analytics Cloud compared to its counterparts."
"There is plenty of room for improvement. They have different products, and you need to integrate all of them to have one functionality. For example, data extraction happens in Datasphere. Then it would be best if you had some connection between the Datasphere and the SAP Analytics Cloud to get the data, as this is causing headaches sometimes. The knowledge base and Jedox also could be more meaningful. I have tried to search for some specific knowledge base and technology base, and I didn't find them. I have learned it by trial and error. There is room to improve the integrations between the different products. The AFS, and the Data action, need improvement. Sometimes they release new tools and updates, but not in my area."
"The business intelligence features should be improved because there is a lack of functionality regarding that part."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews while SAP Analytics Cloud is ranked 4th in BI (Business Intelligence) Tools with 58 reviews. Microsoft Power BI is rated 8.0, while SAP 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 SAP Analytics Cloud writes "Good for reporting but needs to improve its predictive analytics features". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME and Domo, whereas SAP Analytics Cloud is most compared with SAP BusinessObjects Business Intelligence Platform, Tableau, IBM Planning Analytics, Anaplan and IBM Cognos. See our Microsoft Power BI vs. SAP 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.