Microsoft Azure Data Fundamentals: Explore modern data warehouse analytics in Azure

0
Microsoft Learn
Free Online Course
English
2-3 hours worth of material
selfpaced

Overview

  • Module 1: Examine components of a modern data warehouse
  • In this module, you will:

    • Describe Azure data services for modern data warehousing
    • Describe modern data warehousing architecture and workload
    • Explore Azure data services in the Azure portal
  • Module 2: Explore the different data ingestion options available when you are building a data warehouse with Azure. See how to use Azure Data Factory to ingest data into a data warehouse. Explore Azure services for performing data analytics, and explore the features of Azure Synapse Analytics.
  • In this module, you will:

    • Describe data ingestion in Azure
    • Describe components of Azure Data Factory
    • See how to use Azure Data Factory to load data into a data warehouse
    • Describe data processing options for performing analytics in Azure
    • Explore Azure Synapse Analytics
  • Module 3: Power BI is a collection of software services and applications that let you connect to all sorts of data sources and create compelling visuals and reports. You can benefit from receiving those reports, or you can share them with others inside or outside your organization. Learn the basics of Power BI, how its services and applications work together, and how they can be used to create or experience compelling visuals and analytics based on your data.
  • In this module, you will:

    • Learn how Power BI services and applications work together.
    • Explore how Power BI can make your business more efficient.
    • Learn how to create compelling visuals and reports.
  • Module 4: Learn about the basics of stream processing, and the services in Microsoft Azure that you can use to implement streaming data solutions.
  • In this module, you'll learn how to:

    • Compare batch and stream processing
    • Describe common elements of streaming data solutions
    • Describe features and capabilities of Azure Stream Analytics
    • Describe features and capabilities of Spark Structured Streaming on Azure

Syllabus

  • Module 1: Examine components of a modern data warehouse
    • Introduction
    • Describe modern data warehousing
    • Explore Azure data services for modern data warehousing
    • Knowledge check
    • Summary
  • Module 2: Explore large-scale data analytics
    • Introduction
    • Describe common practices for data loading
    • Describe data storage and processing
    • Explore Azure Synapse Analytics
    • Exercise: Create an Azure Synapse Analytics workspace and analyze data
    • Knowledge check
    • Summary
  • Module 3: Get started building with Power BI
    • Introduction
    • Use Power BI
    • Building blocks of Power BI
    • Tour and use the Power BI service
    • Summary
    • Check your knowledge
  • Module 4: Explore fundamentals of stream processing
    • Introduction
    • Understand batch and stream processing
    • Explore common elements of stream processing architecture
    • Explore Azure Stream Analytics
    • Exercise: Analyze streaming data
    • Explore Apache Spark on Microsoft Azure
    • Exercise: Process streaming data using Spark
    • Knowledge check
    • Summary