Most Helpful Review
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
The most valuable feature for me is querying.
The most valuable features are the performance and usability.
I am very satisfied with the customer service/technical support.
It handles high volumes of data very well.
It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time.
The warehouse is the solution's most valuable feature.
The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs.
The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us.
We are currently in a basic stage of analytics and the first goal we have is to make sure the numbers are correct. BW has some features that help you to build factors and ETL in such a way that it's easy to get to correct responses. That's the number one condition that you have to have in an analytic solution.
I would like to see better visualization features.
More tools to help designers should be included.
In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating.
It needs more compatibility with common BI tools.
Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.
The solution could offer better connectivity with other databases.
The advanced structuring can be complicated and the interface is not very intuitive.
One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection.
You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy.
Pricing and Cost Advice
I think the program is well-priced compared to the other offerings that are out in the market.
Information Not Available
out of 30 in Data Warehouse
Average Words per Review
out of 8 in Cloud Data Warehouse
Average Words per Review
Compared 24% of the time.
Compared 15% of the time.
Compared 11% of the time.
Compared 59% of the time.
Compared 25% of the time.
Compared 13% of the time.
Also Known As
|Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse|
The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.
Reporting, analysis and interpretation of business data are crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to react quickly and in line with market needs. SAP Business Warehouse (SAP BW) provides tools and functions that enable companies to attain these goals. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data. Decision makers can make well-founded decisions and identify target-orientated activities on the basis of the analyzed data.
Learn more about Microsoft Parallel Data Warehouse
Learn more about SAP Business Warehouse
|Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe||Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone|