Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Modern Data Architecture using Microsoft Azure
Rating: 4.1 out of 5(156 ratings)
6,944 students

Modern Data Architecture using Microsoft Azure

An introduction to Azure Data-warehousing Technologies and Principles
Created byVimal Vachhani
Last updated 5/2020
English
English [Auto],

What you'll learn

  • Navigate the Azure Portal
  • Create Resource Groups and Provisioning in Azure
  • Create and Load an Azure SQL Database
  • How to load a Azure Data Lake
  • How to move data using Azure Data Factory
  • How to Configure and use Data Bricks
  • How to provision and load a Azure Data Warehousing
  • Connect Power BI to your Azure Synapse Analytics Data Warehouse

Course content

1 section • 16 lectures • 1h 27m total length

  • Introduction1:18

    Explore modern data architecture on Microsoft Azure, covering cloud data warehousing, analytics fundamentals, and technologies like SQL database, data lake, Data Factory, Databricks, synaptic data warehouse, and Power BI.

  • The Basic Modern Data Architecture4:51

    Explore traditional data architecture from staging databases to the enterprise data warehouse, including consolidation database and the operational data store, with shared dimensions and data cleansing.

  • Microsofts Modern Architecture1:43

    Apply microsoft’s azure architecture to ingest structured and unstructured data with azure databricks, build an edl to a data warehouse, and analyze with azure sql databases and power bi.

  • Navigating the Azure Portal2:58

    Log into the Azure portal, navigate the left nav and main screen to access resources and create items, and explore subscriptions and the 12-month free offer.

  • Resource Groups3:39
  • Creating Data Lake Storage9:07

    Create a data lake in Azure by provisioning a storage account and blob container in your resource group, then set up raw and staging folders for edl steps.

  • Setting up a SQL Server9:30

    Set up a SQL Server on Azure, create a basic-tier server and database, load data with scripts into tables, and configure IP firewall to connect to a data lake.

  • Loading Data Lake with Data Factory12:44
  • Auto running Jobs using Data Factory2:10

    Learn to automate data loads in Azure Data Factory by creating a daily trigger that runs a master job to load multiple tables, with scheduling and on-demand execution.

  • Configuring and setting up Data Bricks8:48

    Configure and provision a Databricks environment in Azure, create clusters, workspaces, and notebooks, and learn cost-conscious deployment while preparing to load data from a data lake into a data warehouse.

  • Staging Data into Data Lake11:30
  • Provisioning a Synapsis SQL Data Warehouse6:16

    Provision a Synapse SQL data warehouse on Azure, load data with Data Factory and Data Bricks, and create tables and external schema to enable scalable, massively parallel processing.

  • Loading Data into your Data Warehouse7:35

    Explore loading data from a data lake into a SQL Server data warehouse using Databricks, notebooks, and a serverless cloud workflow, with end-to-end code and validation.

  • Exploring your Data using Power BI4:04

    Connect to a SQL Server data warehouse with Power BI to preview the customer table. Illustrate end-to-end Azure data architecture with data lake, data factory, and a warehouse for reporting.

  • Deprovisioning your Resources1:18
  • Free eBook0:09

    Download the free eBook "Big Data for the Rest of Us, A brief history of data and analytics and where where we are going next".

Requirements

  • Basic understanding of SQL and Data Warehousing Principles

Description

A hands on walk through of a Modern Data Architecture using Microsoft Azure. For beginners and experienced business intelligence experts alike, learn the basic of navigating the Azure Portal to building an end to end solution of a modern data warehouse using popular technologies such as SQL Database, Data Lake, Data Factory, Data Bricks, Azure Synapse Data Warehouse and Power BI.

Who this course is for:

  • Beginner Business Intelligence Developers

Report abuse