Episode

FastTrack for Azure Ep1: Modern Data Warehouse - Designing, making & operating

Learn Live

As more businesses become data-driven, Modern Data Warehouse (MDW) solutions have exploded in popularity with numerous architectures and technologies to support them. Deciding on which architecture and set of technologies to include in your MDW project can be overwhelming, however. In this session you will learn important things to consider to produce a MDW design and best practices to deploy successfully into Azure. Based on lessons learned from working with hundreds of organizations, topics include architecture, security, business continuity, governance, monitoring, development practices and many more. Join us so we can fast-track your next MDW project.

Learning objectives

  • Understand what a Modern Data Warehouse is and the steps required to take that high level concept to a solution in Azure.
  • Learn where you need to focus when embarking on your MDW project and the key decision points that can unblock and accelerate your project.
  • Discover the best practices for operating and maintaining a MDW

Chapters

  • 00:00 - Introduction
  • 01:30 - Learning objectives
  • 04:53 - Modern Data Warehouses - Designing, Building and Operating
  • 12:42 - Browse Azure Architectures
  • 31:24 - Data lakes
  • 38:08 - Building
  • 43:29 - Infrastructure as code
  • 46:43 - Dataops
  • 52:44 - Larges scale data copy pipelines
  • 55:52 - Operating
  • 60:06 - Data governance
  • 65:47 - Monitoring
  • 70:03 - Security
  • 83:25 - Azure Synapse Analytics
  • 85:58 - Summary and conclusion

Connect

Azure