Data Warehousing with Azure: Analytics and Reporting


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Discover how to use Azure Analysis Services and Power BI to prepare reports that can be used to analyze data in SQL Data Warehouse and Azure Data Lake.



Expected Duration (hours)
0.8

Lesson Objectives

Data Warehousing with Azure: Analytics and Reporting

  • define the essential features and the critical capabilities provided by Azure Analysis Services
  • create an Analysis Services server using Azure and PowerShell
  • create an Analysis Services server using the Azure portal
  • demonstrate how to add models to the Analysis Services Server
  • create reports from the model data using Power BI
  • demonstrate the approaches of connecting and exploring data using Microsoft Excel and Power BI
  • create dynamic reports and mashups to facilitate valuable insights from the data visualizations
  • illustrate how to facilitate data warehousing solutions using the AdventureWorks sample
  • work with Power BI and Azure Data Lake
  • prepare data and create reports using Power BI
  • Course Number:
    it_dfdwaz_04_enus

    Expertise Level
    Intermediate