No more typing reviews! Try our Samantha, our new voice AI agent.

Microsoft Analytics Platform System vs SAP Business Warehouse comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Microsoft Analytics Platfor...
Average Rating
6.6
Reviews Sentiment
6.8
Number of Reviews
9
Ranking in other categories
Data Warehouse (18th)
SAP Business Warehouse
Average Rating
7.8
Reviews Sentiment
6.1
Number of Reviews
26
Ranking in other categories
Cloud Data Warehouse (15th)
 

Featured Reviews

MahmoudMohamed1 - PeerSpot reviewer
Senior Data Engineer at Tatweer Educational Technologies Company - TETCO
Offers smooth data integration between systems, but requires better real-time analytics capabilities
We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services. This lets us continue using private databases without paying additional licensing fees. Additionally, the license includes Analytics services and Power BI, which work on-premises, unlike most other technologies that require cloud solutions.
VishnuReddy2 - PeerSpot reviewer
Consulting Enterprise Architect at R2V2.ai
Have encountered complexity with programming language while working on large-scale data integration and have experienced improved governance and reporting
The only complexity I find with the product is the programming language; people find it harder, but once you know the language, it's not that difficult. Regarding the future of SAP Business Warehouse, I would to see added features that simplify the product very well now. They are coming up with a terminology called SAP BDC where they are consolidating their tools, SAP Data Sphere for integration and SAP BW for the ETL and warehousing parts, and SAP Analytics Cloud. They are packaging these three features and calling it Business Data Cloud; they are fully coming on the cloud. We have to wait and watch; they have been speaking about BW/4HANA for quite some time now, but the customers or clients I work with are not finding great interest and it was seen as a candidate for evaluation. I have seen people looking at the latest technologies who are already on cloud who started building from scratch on cloud, such as Snowflake or Databricks, which can process very huge amounts of data and also address unstructured data, where SAP lags behind in cases where there is a need to bring in unstructured data. I have worked with SAP Data Intelligence, which earlier used to be called SAP Data Hub. The unstructured data is not greatly handled in SAP at this point in time.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"This is a well-integrated solution and that integration empowers results."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"The result is a highly flexible, affordable, and scalable platform that makes large-scale Hub and Spoke EDW architectures a practical reality."
"We help customers in many ways from customized analysis for detection of anomalies in tax, operations, customer relationship, and marketing campaigns, and we also use mining and ML to help them discover trends, which provides useful information based on their business."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"It is closely integrated with other products in the MS portfolio."
"I like that it's integrated with other Azure products."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"The product is very stable."
"The most valuable aspect of the solution is the integration with SAP ERP."
"The key element in this solution is its rapid response, because if you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two, and that is the key benefit for us that a solution like BW gives us."
"Now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually."
"The most valuable feature is the new version of Business Explorer Analyzer, which is a very good version because there are a lot of analytical features of Excel also."
"The Real-time InfoCube is quite useful in terms of getting information fast when we need it."
"The features that I have found most valuable are its capabilities to connect to Excel and to slice and dice."
"Technical support is good, and they were able to assist us in some specific issues we were experiencing."
 

Cons

"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"​Hybrid environments are complex to manage."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"The pricing model needs to be improved."
"The trouble is Microsoft has changed their licensing. It's an extremely expensive product now."
"Microsoft Analytics Platform System could have better support."
"In the next release, my suggestion would be to have user-friendly interfaces and performance issues be addressed."
"Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users."
"The solution should be more open to the cloud."
"What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup."
"The problem with BW, and the factor that differentiated it from the original BW, is that you only get limited functionality with your runtime license. So, you have to pay extra for extracting data."
"From a support perspective, SAP Business Warehouse is quite a complex module."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"The visualization should be improved, as well as the dashboards and advanced analytics."
 

Pricing and Cost Advice

"The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."
"I rate Microsoft Analytics Platform System a seven out of ten for pricing."
"Users have to pay extra for premium-level technical support."
"We are currently paying $200,000 a year for all the different parts of the suite during an ingest model Microsoft now charges us $700,000 a year."
"The licensing cost for SAP Business Warehouse depends on your revenue. Its licensing structure is a little bit complicated. The more your revenue is, the higher the price, but SAP does have different pricing structures for various companies. For small businesses, licensing isn't based on revenue, but for big companies, it's revenue-based. There's some agreement regarding pricing for huge companies, so it's different, and SAP Business Warehouse pricing isn't fixed. On a scale of one to ten, I'm rating the licensing cost for SAP Business Warehouse as five because it's very high. As your revenue grows, your licensing cost also increases, so you have to factor that in when calculating your cost."
"I would not recommend it to small-scale companies. The price is too much."
"The solution is quite expensive."
"It's quite pricey. SAP changed its pricing policy, so they give you one engine and then you have to buy everything next to it, like MSS, the BPC licenses, and everything else."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
"Overall, the pricing is not fixed and is expensive."
"It's moderately expensive, but definitely has its branding and price value for it."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
902,988 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Manufacturing Company
12%
Construction Company
9%
Healthcare Company
9%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Large Enterprise7
By reviewers
Company SizeCount
Small Business8
Midsize Enterprise4
Large Enterprise15
 

Questions from the Community

Ask a question
Earn 20 points
What is your experience regarding pricing and costs for SAP Business Warehouse?
The pricing for SAP Business Warehouse is on the expensive side. I am not sure about the current costing model as such. In my experience on cloud, I did not use BW HANA Cloud. I used the cloud prod...
What needs improvement with SAP Business Warehouse?
The only complexity I find with the product is the programming language; people find it harder, but once you know the language, it's not that difficult. Regarding the future of SAP Business Warehou...
What is your primary use case for SAP Business Warehouse?
I am using SAP Business Warehouse in my organization for data warehousing as well as an ETL tool. Integration with SAP Business Warehouse's ETL tools is not straightforward. Integration with SAP ER...
 

Also Known As

Microsoft APS, MS Analytics Platform System
No data available
 

Overview

 

Sample Customers

Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
Find out what your peers are saying about Snowflake Computing, Teradata, Oracle and others in Data Warehouse. Updated: June 2026.
902,988 professionals have used our research since 2012.