2019-11-20T05:39:00Z

What is your primary use case for Microsoft Parallel Data Warehouse?

Julia Miller - PeerSpot reviewer
  • 0
  • 6
PeerSpot user
22

22 Answers

EO
MSP
Top 5Leaderboard
2023-12-22T15:24:00Z
Dec 22, 2023

We use the product for data analytics purposes.

Search for a product comparison
ONUR ÇALISKAN - PeerSpot reviewer
Real User
Top 5
2023-12-15T09:24:00Z
Dec 15, 2023

We can use the solution for financial, banking, insurance, or retail sectors.

AS
Real User
Top 5Leaderboard
2023-09-08T07:42:37Z
Sep 8, 2023

The product handles reporting, data collection, and sharing, and serves as a database for applications.

Sunil_Shah - PeerSpot reviewer
Real User
Top 10
2023-08-16T06:49:46Z
Aug 16, 2023

I use it at the office to access data.

PALAK SURI - PeerSpot reviewer
Real User
Top 5
2023-08-01T08:34:00Z
Aug 1, 2023

In my company, we use Microsoft Parallel Data Warehouse in some of our projects, including loading the data of multiple data locations in France to employed data warehouses.

IS
Real User
Top 5
2023-07-04T08:32:00Z
Jul 4, 2023

On any given day, we use Microsoft Parallel Data Warehouse to create an enterprise data warehouse for our customers.

Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
Albert Lacerda - PeerSpot reviewer
Real User
Top 5
2023-03-09T22:03:25Z
Mar 9, 2023

Our clients use Microsoft SQL Server Parallel Data Warehouse to create a separate database and build a data warehouse model. However, they do not use the appropriate product built into Microsoft SQL Server Parallel Data Warehouse for business intelligence. Instead, they create another database, link the model there, move the data from the online transaction database to the data warehouse to create a business intelligence database, and install a reporting tool on top of that. This is what our client does. We have experience with this process, as we are often the ones they call to transfer data from one database to the other, tune the database for performance, and create reports using a reporting tool.

VJ
Real User
Top 20
2023-03-09T22:03:22Z
Mar 9, 2023

We primarily use the solution for the integration of data with different sources and with historical data. We can put all of this into a company database once it is integrated.

PeterMaier - PeerSpot reviewer
Real User
Top 10
2022-11-10T16:34:43Z
Nov 10, 2022

We primarily use Data Warehouse for our business intelligence platform Qlik, which sits on top of it. Data Warehouse is a middleware product. Our users work with Qlik, and our data architects are using SQL Server. It mostly feeds the data to the Qlik cloud product. Very few people are directly using the Data Warehouse. It takes data from other source systems, transforms it, and serves it up to be analyzed in Qlik. Depending on how you look at it, we have around 120-130 indirect Data Warehouse users, but maybe only three or four.

SG
Real User
Top 20Leaderboard
2022-08-15T13:39:26Z
Aug 15, 2022

We primarily use the solution for data.

StevenLai - PeerSpot reviewer
Real User
Top 5
2022-07-25T19:55:01Z
Jul 25, 2022

We have almost 20 years of historical data and use this solution to maintain the cube data. It ensures we don't lose the data.

SM
Real User
2020-08-30T08:33:18Z
Aug 30, 2020

We are primarily using the solution to convert to different dashboards and to collect all of the metrics and data.

it_user1352403 - PeerSpot reviewer
Real User
2020-08-27T10:31:46Z
Aug 27, 2020

In the past, our use case for the product was just to collect data from different data sources. Now, we are trying to build websites and the business intelligence layer above the SQL Data Warehouse.

MS
Real User
2020-05-04T05:12:00Z
May 4, 2020

We provide this solution as a service to customers. Sometimes, it is just used as a data warehouse. However, a couple of our customers use the data warehouse to collect information from everywhere, e.g., from their subsidiaries, such as electric or petrol companies. We are also developing some dashboards using the data warehouse. Sometimes, you are using Microsoft BI, but most of the time, you are using Qlik. It depends on the customer needs at the end of the day. Most of our limitations until this moment have been on-premise. There is some sensitive information, like the billing system for an entire country's electricity. However, because of the current circumstances with COVID-19, we are discussing with them how to move it to the cloud. Mostly because of the regulation that any government data cannot be hosted on a cloud, we need to host it on a local cloud at the moment. We cannot use AWS or similar things as of now. While we do have local cloud vendors that we are working with, this is something in progress.

PS
Real User
2019-12-16T08:14:00Z
Dec 16, 2019

This is a solution that we implement for our clients. We provide end-to-end development, maintenance, enhancement, testing, and support. Everything is done by us.

SM
Real User
2019-12-16T08:13:00Z
Dec 16, 2019

We primarily use the solution to build up our server analytics.

AN
Consultant
2019-12-15T05:58:00Z
Dec 15, 2019

I am a consultant and I assist in implementing this solution for our clients. The projects that we are working on right now are related to finance, banking, and government.

AJ
Real User
2019-12-12T07:48:00Z
Dec 12, 2019

I am using the Microsoft Parallel Data Warehouse for working with information services and datasets, creating reports. It is used primarily for our historical data, but we do some in real-time also. We can receive data weekly, nightly, or even hourly.

CC
Real User
2019-12-09T10:59:00Z
Dec 9, 2019

The primary use cases for this solution are for recording and transactions.

MJ
Real User
2019-12-09T10:58:00Z
Dec 9, 2019

I have mostly worked with analytics, so I normally use SQL to put in data for analysis. I have worked on building dashboards as well.

EG
Real User
2019-12-05T06:53:00Z
Dec 5, 2019

We use this solution for keeping track of sales, goods, times of shipping, and other information. It is used for our KPIs.

ER
Real User
2019-11-20T05:39:00Z
Nov 20, 2019

I work for a Microsoft partner. We're one of the Gold partners, so we implement on their databases. We are also Dynamics 365 specialists, and I'm a Business Intelligence consultant, so I do SQL, Power BI, Azure SQL, SQL Data Warehouses, and a few others.

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.
Download Microsoft Parallel Data Warehouse ReportRead more