Organizations want answers and many of those answers come from data analysis, but that can be challenging with the vast amount and variety of data in a modern organization. In this course, Plan for Data Warehousing with Microsoft Azure, you will learn foundation knowledge of data warehousing and core components in Microsoft Azure that can be used to solve this problem. First, you will examine the fundamentals of data warehousing and identifying requirements. Next, you will explore key Microsoft technologies that will form part of the complete data warehouse solution. Finally, you will discover common architectures for a complete data warehouse solution. When you’re finished with this course, you will have the skills and knowledge of data warehousing to design an architecture in Microsoft Azure.
John Savill is an 11-time MVP, and he holds many Microsoft certifications
including Azure Infrastructure and Azure Architecture specialist. John is
the author of the popular FAQ for Windows and a senior contributing editor
to Windows IT Pro. John has written eight books on Microsoft technologies
including Mastering Microsoft Azure Infrastructure Services and Mastering
Windows Server 2016 Hyper-V.
Course Overview Hi everyone, my name is John Savill, and welcome to my course, Plan for Data Warehousing with Microsoft Azure. I'm a principal technical architect at the Dallas Microsoft Technology Center. Every organization has data from which insight is required, but that can be challenging given the vast number of systems generating data and all the different formats. Data warehouses consolidate and store data while bringing large-scale analytics capabilities. In this course, we're going to look at requirements related to designing data warehouse solutions and how to architect those using Microsoft Azure services. By the end of this course, you'll know the components available in Azure to be used as part of a data warehouse solution and some common architectures. I hope you will join me on this journey to learn all about data warehouses in Azure with the Plan for Data Warehousing with Microsoft Azure course, at Pluralsight.
Understanding Data Warehouse Core Concepts Welcome to the Plan for Data Warehousing with Microsoft Azure course, and this first module, Understanding Data Warehouse Core Concepts. My name is John Savill. I'm a Principal Technical Architect at the Dallas Microsoft Technology Center. You can follow me on Twitter @ntfaquy or my blog savilltech. com, and I'll try and keep you up to date of any new recordings or papers I might write. Now, the focus for this course is really to dive into anything related to data warehousing in Microsoft Azure. We'll look at data warehouse basics. Why do we have it? What benefit does it bring us over a traditional database? Deploying data warehouse solutions in Azure. And then, looking at a couple of reference architectures. In this first module, we're going to explore why we need data warehouses, some of the typical data warehouse tasks we'll be faced with, and then some of the different approaches to data warehousing.
Designing Data Warehouse Solutions in Azure Welcome to the Designing Data Warehouse Solutions in Azure module, and the goal for this module is simply to run through some of the key Azure technical solutions we would see in a modern data warehousing solution and then how do we pick? So a few hints and tips to actually choose the solutions for your data warehousing architecture.
Reference Architectures Welcome to the Reference Architecture module. And our goal for this module is to simply review two types of modern data warehouse.