• Online, Self-Paced
Course 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.

Learning 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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.