Coming October 25: PeerSpot Awards will be announced! Learn more

Microsoft BI vs SAP Analytics Cloud comparison

You must select at least 2 products to compare!
Microsoft Logo
46,105 views|36,772 comparisons
SAP Logo
13,364 views|9,428 comparisons
Comparison Buyer's Guide
Executive Summary
Updated on August 30, 2022

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.

  • Ease of Deployment: Most users of both solutions say that their initial setup is straightforward.
  • Features: Reviewers of both products are happy with their stability and scalability.

    Microsoft BI users say it has good querying capabilities and is flexible, with a good UI and integration options, but that it can slow down when handling large amounts of data.

    SAP Analytics users like its insight feature and say it provides good visualization and is user-friendly, but that there are integration limitations.
  • Pricing: Some Microsoft BI reviewers feel that the price is fair while others feel it is too high. Most SAP Analytics reviewers feel that it is fairly priced.
  • ROI: Reviewers of both products report seeing an ROI.

  • Service and Support: Microsoft BI reviewers report being satisfied with the level of support they receive. Some SAP Analytics reviewers say its support has slow response times.

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.

To learn more, read our detailed Microsoft BI vs. SAP Analytics Cloud report (Updated: September 2022).
633,184 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
"My favorite feature is the power query editor, where it can do the data transformations.""When we are introducing Microsoft BI to our clients, if they're familiar with Excel, the transition phase will be much easier for them. They can easily switch from Microsoft Excel to Microsoft BI. The core foundation or the base technology is the same in both tools. There are a few limitations in Microsoft Excel, and this is where Microsoft BI comes in.""Easy to use and the visualization is valuable.""Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features.""Management reporting solution that's very stable and scalable.""Good CS and administration.""In contrast to what we were using before I think that Power BI has given us more extensive results.""The stability is good."

More Microsoft BI Pros →

"The reporting, dashboards, KPIs, and visualization are the most valuable.""The most valuable features are the analytical application and the user story.""I like the connectivity the solution provides with other products.""The most useful feature of SAP Analytics Cloud is planning because it helps users with making predictions and forecasts. Clients can forecast, make data allocations, and other actions. The solution is useful for planning.""The ability to collaborate and plan together is great.""The visualization feature is the most valuable. SAP Analytics Cloud is also very easy to use.""SAP Analytics Cloud is easy to create charts with, and is a stable business intelligence platform. Easy to set up solution.""Planning and integration are the most valuable features. It is useful for planning, and it is useful for integrating with on-prem or cloud SAP solutions."

More SAP Analytics Cloud Pros →

"It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community.""The maps in Power BI could be improved. You deal with many maps over the years, like maps of America and Saudi Arabia. The maps aren't detailed enough, and there aren't enough visualization tools. Whenever I want to use a map, I struggle with choosing the right visualization.""Microsoft BI's visualization could be better. Though Power BI's visualization has steadily improved over the years, it's not on the level tools like Tableau and SAS or some of the more expensive products on the market.""The interface could be improved.""Integrating it with the physics build model or the engineering model should be included.""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.""The dashboard could be simplified.""There are some problems with the functionality of this solution. The dashboard is not very user friendly and is quite complicated."

More Microsoft BI Cons →

"The budget management could be better.""SAP Analytics Cloud requires a lot of coding and I would like the coding to be somewhat minimal.""SAC, which is the cloud version, lost some good features from the previous planning product, like BPC or BPS.""I would also like to have more advanced features for predictive analytics.""An additional feature that needs to be added to SAP Analytics Cloud is exporting because right now, you can only export to PDF and PowerPoint. It would be good to have multiple export options, for example, to Excel and other apps. Pricing is an area for improvement in SAP Analytics Cloud, apart from exporting.""It should have the flexibility for scoping the story and models. When you use it in a three-layer architecture, you struggle with the fact that you usually have just one SAP Analytics Cloud tenant, and you have to switch the connections, which might be an issue for bigger developments. For the development role, there should be an option to switch between development and production scenarios.""Could have more tabular reporting capabilities.""Technical support could be more helpful and responsive."

More SAP Analytics Cloud Cons →

Pricing and Cost Advice
  • "It is somewhere in the middle in terms of price. Licensing is quite clear."
  • "Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable. It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version."
  • "Once the trial period for the BI service is over, the cost is approximately $10 USD per user, per month, so it's quite reasonable."
  • "The pricing is very reasonable compared to any other tool."
  • "Microsoft BI is not very cheap. A premium license costs roughly 5,000 euros a month."
  • "This product offers good value for the money."
  • "Microsoft BI is free for the personal edition, but there is also a paid-for professional version."
  • "Setup is easy, and the cost is economical. You do sometimes need to pay additional costs for third party products which "plug-in" to Microsoft BI."
  • More Microsoft BI Pricing and Cost Advice →

  • "It is not the most expensive one. You have to do the cost-of-ownership analysis and take a lot of things into consideration to come up with the conclusion that it is cheaper or not, but its price is reasonable. It provides value for money."
  • "It's quite expensive and costs a lot to maintain, especially with licensing."
  • "It's not that costly as such for the time being."
  • "Its licensing is on a monthly basis."
  • "Compute and storage features should be sold separately."
  • "Its pricing is okay as compared to its competitors."
  • "Its price is slightly on the higher side."
  • "The pricing of this product is reasonable."
  • More SAP Analytics Cloud Pricing and Cost Advice →

    Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
    633,184 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows:  1) If you have legacies of SAP, Oracle  - look for SAP… more »
    Top Answer:Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize information, control users accessing information, the configuration of governance… more »
    Top Answer:Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle… more »
    Top Answer:Tableau is easy to set up and maintain. In about a day it is possible for the entire platform to be deployed for use. This relatively short amount of time can make all the difference for companies… more »
    Top Answer:Its user-friendliness is valuable. It is a product for end-users and not for IT, which is an advantage.
    Average Words per Review
    Average Words per Review
    Also Known As
    SSRS, SSAS, MSBI, MS Reporting Services, Power BI, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
    SAP BusinessObjects Cloud
    Learn More

    Microsoft BI is a business intelligence solution that turns data into insightful and useful business information that is relevant to all levels of the business.

    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.

    SAP Analytics Cloud is an all-in-one Software-as-a-Service business intelligence tool that provides the key functionalities of an analytics tool to SAP business users. This tool is built on HANA Business Intelligence (BI) platform, providing analytics from data collected from multiple sources, such as ERP, Microsoft SQL, and Salesforce, among other solutions.

    You can use SAP Analytics Cloud to compile data and perform ad-hoc reporting and analysis for predictive planning. SAP Analytics Cloud collects and analyzes the raw data from transactional systems into intelligent insights that allow you to make better decisions.

    SAP Analytics Cloud uses machine learning to clean up data, identify errors, and issues, and suggest optimization or filtering options. You can use the modeling feature in Analytics Cloud to create hierarchies and get deeper data insights.

    The three core functions of SAP Analytics Cloud consist of Planning, Predictive Analysis, and Business Intelligence as a holistic SaaS solution that offers real-time analysis to business leaders.

    SAP Analytics Cloud Capabilities

    • Data discovery
    • Machine learning
    • Integrated financial and business planning
    • Predictive analysis
    • Automated data cleansing
    • Custom widgets
    • Mobile extension
    • Role-based customization
    • Data exploration and visualization

    SAP Analytics Cloud Key Features

    • Augmented analytics: SAP Analytics Cloud allows organizations to make the most of AI (Artificial Intelligence)-powered analytics through augmented analytics. It includes a Search to Insight feature that enables users not skilled or experienced in data science to access and use the platform.

      These smart insight tools allow organizations to visualize business data without manual intervention. By combining multiple machine learning algorithms, SAP Analytics Cloud automates predictive analysis so that organizations can have significant insight into secured data.
    • Enterprise planning: As SAP Analytics Cloud is an all-in-one financial planning and analysis solution, organizations can use it to align strategies across all departments. It allows end-to-end, data-driven planning decisions via financial modeling, allocations, smart insights, and automated reporting.

      The Zero-based budgeting feature allows for an effective resources allocation with built-in collaboration tools. The finance team can collaborate easily, create budget templates and make accurate decisions.

    SAP Analytics Cloud Benefits

    • Real-time cloud insights: SAP Analytics Cloud makes it easy for users at every level to generate instant insights and improve data-driven decision-making. With SAP Analytics Cloud, you can have immediate and central access to all figures, diagrams, insights, and evaluations for every employee on every device and updated in real time.

    • Customizable dashboard: You can customize your dashboard according to your requirements. This customization means you can easily access all the relevant data on a single pane of vision tailored to your business.

    • Collaborative planning: As an all-in-one platform, SAP Analytics Cloud integrates the multiple aspects of a business into a single solution, including finance, HR, sales, and supply chain management.

    • Data on any device: You can integrate SAP Analytics Cloud with SAP S/4 HANA and deploy insights to Android and iOS devices. The SAP S/4 HANA integration also enables the rolling out of changes to multiple files and devices from a central location, so you can carry your business operations on the go over a secured cloud network.

    • In-memory technology: Since it is based on SAP HANA in-memory technology, SAP Analytics Cloud can process massive amounts of data in a short time.

    Reviews from Real Users

    Segun O., SAP HANA Developer at SOA PEOPLE, says that "The most valuable features are on the application side, where you can design applications into your analytics on the platform."

    The Head of Finance Enterprise Application at a computer software company adds that "The visualization feature is the most valuable. SAP Analytics Cloud is also very easy to use."

    "Its many features make it the best in the market," sums up a Consultor SAP Business Object, Sap Analytics Cloud at a tech services company.

    Learn more about Microsoft BI
    Learn more about SAP Analytics Cloud
    Sample Customers
    Konica Minolta, Klout, Mahindra Satyam, The Weather Channel, Argus, Credit Suisse, NCR, and Sysmex.
    Live Oak Bank
    Top Industries
    Financial Services Firm14%
    Manufacturing Company14%
    Computer Software Company11%
    Computer Software Company17%
    Comms Service Provider12%
    Financial Services Firm10%
    Computer Software Company25%
    Manufacturing Company13%
    Healthcare Company6%
    Computer Software Company23%
    Comms Service Provider10%
    Manufacturing Company8%
    Financial Services Firm6%
    Company Size
    Small Business38%
    Midsize Enterprise17%
    Large Enterprise45%
    Small Business18%
    Midsize Enterprise14%
    Large Enterprise68%
    Small Business27%
    Midsize Enterprise20%
    Large Enterprise52%
    Small Business16%
    Midsize Enterprise13%
    Large Enterprise71%
    Buyer's Guide
    Microsoft BI vs. SAP Analytics Cloud
    September 2022
    Find out what your peers are saying about Microsoft BI vs. SAP Analytics Cloud and other solutions. Updated: September 2022.
    633,184 professionals have used our research since 2012.

    Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 187 reviews while SAP Analytics Cloud is ranked 5th in BI (Business Intelligence) Tools with 29 reviews. Microsoft BI is rated 8.0, while SAP Analytics Cloud is rated 8.2. The top reviewer of Microsoft 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 "Enables us to allocate, spread, and distribute actual figures". Microsoft BI is most compared with Amazon QuickSight, Tableau, MicroStrategy, SAP BusinessObjects Business Intelligence Platform and SAP Crystal Reports, whereas SAP Analytics Cloud is most compared with Tableau, SAP BusinessObjects Business Intelligence Platform, IBM Planning Analytics, Oracle Analytics Cloud and SAP Analytics Hub. See our Microsoft 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.