Skip navigation

Modern data warehouse

Build the hub for all of your data – structured, unstructured or streaming – to drive transformative solutions like BI and reporting, advanced analytics and real-time analytics. Take advantage of the performance, flexibility and security of fully managed Azure services, such as Azure SQL Data Warehouse and Azure Databricks, to get started with ease.

Accelerate time to market

Ensure productivity with industry-leading SQL Server and Apache Spark engines, as well as fully managed cloud services that allow you to provision your modern data warehouse in minutes. Accelerate data integration with more than 30 native data connectors from Azure Data Factory and support for leading information management tools from Informatica and Talend. Empower your data scientists, data engineers and business analysts to use the tools and languages of their choice on big data.

Read how Rockwell Automation cut development time by 80 per cent for shorter time to market, reduced costs and improved customer responsiveness.

Choose a solution based on your specific needs

Easily get started with a cloud solution or a hybrid option based on your business requirements. Only Microsoft lets you take consistent advantage of SQL Server performance, familiarity and security in a private cloud or as a managed service in MPP architecture in Azure. Reduce costs and the complexity of managing existing data transformations through the hybrid data integration experience. Finally, enable a consistent user experience with common identity across on-premises services and Azure.

Learn how Carnival Maritime built a hybrid solution that predicts onboard water usage, saving $200000 per ship annually.

Get insights on any data

Take advantage of the flexibility to build and deploy machine learning models on-premises or in the cloud. Use the data science tool of your choice with support for the best of Microsoft and open-source innovation. Easily distribute insights across your organisation through rich integration with Power BI and other leading business intelligence and visualisation tools like Tableau, Qlik, MicroStrategy and Alteryx.

Find out how ASOS delivers 13 million personalised experiences with up to 33 orders per second.

Enjoy peace of mind

Built-in advanced security features include Transparent Data Encryption, audit, threat detection, Azure Active Directory integration and Azure Virtual Network endpoints. Azure services comply with more than 50 industry and geographical certifications, and are globally available across 42 regions to keep your data where your users are. Finally, Microsoft offers financially backed SLAs to ensure peace of mind.

Read why GE Healthcare delivers its core solutions using Azure data services.

Customers doing great things with modern data warehouse

Solution architectures

Modern data warehouse

Data warehouse modernoUn data warehouse moderno consente di combinare facilmente tutti i dati su qualsiasi scala e di ottenere informazioni dettagliate tramite dashboard di analisi, report operativi o analisi avanzata per tutti gli utenti.12354
  1. Overview
  2. Flow

A modern data warehouse lets you bring together all your data at any scale easily, and means you can get insights through analytical dashboards, operational reports or advanced analytics for all your users.

  1. 1 Combine all your structured, unstructured and semi-structured data (logs, files and media) using Azure Data Factory to Azure Blob Storage.
  2. 2 Leverage data in Azure Blob Storage to perform scalable analytics with Azure Databricks and achieve cleansed and transformed data.
  3. 3 Cleansed and transformed data can be moved to Azure SQL Data Warehouse to combine with existing structured data, creating one hub for all your data. Leverage native connectors between Azure Databricks and Azure SQL Data Warehouse to access and move data at scale.
  4. 4 Build operational reports and analytical dashboards on top of Azure Data Warehouse to derive insights from the data, and use Azure Analysis Services to serve thousands of end users.
  5. 5 Run ad hoc queries directly on data within Azure Databricks.

Advanced analytics on big data

Analisi avanzata su Big DataTrasforma i tuoi dati in informazioni dettagliate di utilità pratica usando gli strumenti di apprendimento automatico migliori del settore. Questa architettura consente di combinare qualsiasi dato su qualsiasi scala, nonché di creare e distribuire modelli di apprendimento automatico personalizzati su vasta scala.1234576
  1. Overview
  2. Flow

Transform your data into actionable insights using the best-in-class machine learning tools. This architecture allows you to combine any data at any scale, and to build and deploy custom machine-learning models at scale.

  1. 1 Bring together all your structured, unstructured and semi-structured data (logs, files and media) using Azure Data Factory to Azure Blob Storage.
  2. 2 Use Azure Databricks to clean and transform the structureless datasets and combine them with structured data from operational databases or data warehouses.
  3. 3 Use scalable machine learning/deep learning techniques to derive deeper insights from this data using Python, R or Scala, with inbuilt notebook experiences in Azure Databricks.
  4. 4 Leverage native connectors between Azure Databricks and Azure SQL Data Warehouse to access and move data at scale.
  5. 5 Power users take advantage of the inbuilt capabilities of Azure Databricks to perform root cause determination and raw data analysis.
  6. 6 Run ad hoc queries directly on data within Azure Databricks.
  7. 7 Take the insights from Azure Databricks to Cosmos DB to make them accessible through web and mobile apps.

Real-time analytics

Analisi in tempo realeOttieni facilmente informazioni dettagliate dai dati dello streaming live. Acquisisci continuamente dati da qualsiasi dispositivo IoT o log di clickstream di siti Web ed elaborali in tempo quasi reale.12348765
  1. Overview
  2. Flow

Get insights from live streaming data with ease. Capture data continuously from any IoT device, or logs from website clickstreams, and process it in near-real time.

  1. 1 Easily ingest live streaming data for an application using Apache Kafka cluster in Azure HDInsight.
  2. 2 Bring together all your structured data using Azure Data Factory to Azure Blob Storage.
  3. 3 Take advantage of Azure Databricks to clean, transform and analyse the streaming data, and combine it with structured data from operational databases or data warehouses.
  4. 4 Use scalable machine learning/deep learning techniques to derive deeper insights from this data using Python, R or Scala, with inbuilt notebook experiences in Azure Databricks.
  5. 5 Leverage native connectors between Azure Databricks and Azure SQL Data Warehouse to access and move data at scale.
  6. 6 Build analytical dashboards and embedded reports on top of Azure Data Warehouse to share insights within your organisation and use Azure Analysis Services to serve this data to thousands of users.
  7. 7 Power users take advantage of the inbuilt capabilities of Azure Databricks and Azure HDInsight to perform root cause determination and raw data analysis.
  8. 8 Take the insights from Azure Databricks to Cosmos DB to make them accessible through real-time apps.

Jump-start modern data warehouse in your organisation

Contact sales

Microsoft may use your contact information to provide updates and special offers about Microsoft Azure and other Microsoft products and services. You can unsubscribe at any time. To learn more, read the Privacy Statement.

Related solutions

Big data and analytics

Make the most informed decision possible by analysing all of the data you need in real time

Learn more

Business intelligence

Drive better, faster decision making by analysing your data for deeper insights

Learn more

Internet of Things

Internet of Things

Power your digital transformation, collect untapped data and find new insights by connecting your devices, assets and sensors

Learn more

High-performance computing

High-performance computing

Tap into unlimited resources to scale your high-performance computing (HPC) jobs

Learn more