Microsoft Parallel Data Warehouse Primary Use Case

PALAK SURI - PeerSpot reviewer
Senior Software Engineer at Eurofins

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.

View full review »
PeterMaier - PeerSpot reviewer
Chief Financial Officer at a retailer with 5,001-10,000 employees

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.

View full review »
SG
Application Designer at LMKR

We primarily use the solution for data. 

View full review »
Buyer's Guide
Microsoft Parallel Data Warehouse
April 2024
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,578 professionals have used our research since 2012.
Sunil_Shah - PeerSpot reviewer
Senior software developer at a tech services company with 1,001-5,000 employees

I use it at the office to access data.

View full review »
StevenLai - PeerSpot reviewer
Sr. Data Engineer at a real estate/law firm with 1,001-5,000 employees

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.

View full review »
EO
Senior Systems Engineer at Dimension Data

We use the product for data analytics purposes.

View full review »
AS
IT manager at Farmatrejd

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

View full review »
ONUR ÇALISKAN - PeerSpot reviewer
Managing Partner at INFOLOJIK

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

View full review »
IS
CTO at Data Semantics Pvt Limited

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

View full review »
Albert Lacerda - PeerSpot reviewer
Managing partner at Dynamis Informatica

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.

View full review »
VJ
BI/Data Warehouse Analyst at a healthcare company with 501-1,000 employees

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. 

View full review »
AN
Senior Principal Consultant at a tech services company with 1,001-5,000 employees

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.

View full review »
MJ
BI Developer at a healthcare company with 51-200 employees

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.

View full review »
CC
Product Director at a insurance company with 10,001+ employees

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

View full review »
SM
Senior Software Engineer at a tech services company with 1,001-5,000 employees

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

View full review »
EG
Senior System Analyst at a tech services company with 1,001-5,000 employees

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

View full review »
ER
Microsoft Dynamics Specialist at a computer software company with 51-200 employees

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.

View full review »
it_user1352403 - PeerSpot reviewer
System Administrator at a university with 501-1,000 employees

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.  

View full review »
MS
EDRMS Practice Lead at a tech services company with 51-200 employees

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.

View full review »
AJ
Team Lead at a computer software company with 10,001+ employees

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.

View full review »
PS
Software Engineer at Tech Mahindra Limited

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.

View full review »
it_user400518 - PeerSpot reviewer
Teradata DBA / Parallel datawarehouse DBA at a tech services company with 10,001+ employees

We are using PDW as an EDW solution.

View full review »
it_user222813 - PeerSpot reviewer
BI Business Analyst at a transportation company with 1,001-5,000 employees

Analysing large volumes of data collected from auto ticket barriers at railway stations.

View full review »
SM
Vice President at a tech consulting company with 201-500 employees

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

View full review »
Buyer's Guide
Microsoft Parallel Data Warehouse
April 2024
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2024.
768,578 professionals have used our research since 2012.