Azure SQL Data Warehouse
Azure SQL Data Warehouse is a combination of enterprise-grade SQL Server magnified with the processing architecture of the Analytics Platform System. This allows the SQL Data warehouse service to scale across vast datasets. It integrates seamlessly with existing Azure data tools such as:
- Power BI for data visualization
- Azure Machine Learning for advanced analytics
- Azure Data Factory for data orchestration and movement
- Azure HDInsights for big data processing
The data warehouse becomes a permanent data store for reporting, analysis, and business intelligence (BI).
Benefits of Using SQL Data Warehouse:
Enterprise-Class Cloud Data Warehouse Built on SQL Server
Separating Compute and Storage Enables a Data Warehouse to Meet Your Needs
Pause an Instance to Save Costs
Consolidate Data From Varying Software
PolyBase in the Cloud Makes Combining Data Sets Easy
Store Historical Data From Multiple Sources
Improve Data Quality by Cleaning Up Data as its Imported Into the Data Warehouse
Data Mining Tools Can Find Hidden Patterns in the Data Using Automated Methods
Hybrid Infrastructure Supports Your Needs On-Premises and/or in the Cloud
