Introduktion til Azure BI

Underviser
Start
7. december 2020 09:00
Slut
9. december 2020 16:00
Adresse
Kanalvej 7, 2800 Kongens Lyngby   Vis kort

13.500 DKK

Ikke på lager

Status

Detaljer

Dette 3-dages kursus henvender sig til alle der godt kunne tænke sig at få et indblik i hvilke muligheder der er for at bygge en komplet Data Warehouse og Business Intelligence løsning i Azure. Det som ofte går under betegnelsen “Modern DW architecture”.

I løbet af de 11 moduler i kurset vil du få en gennemgang af de primære BI og DWH services som Microsoft stiller til rådighed i Azure og du vil lærer om deres styrker og begrænsninger. Der vil være stort fokus på dialog og øvelser undervejs.

Forudsætninger:

  • Generelt kendskab til Data Warehouse og Business Intelligence
  • Azure Account (eventuelt Free Account)
  • Medbring egen laptop

Kursus agenda:

Modul 1: Azure Basics

  • Microsoft Cloud Data Platform Overview
  • Account and Azure Portal
  • Azure Management tools
  • Azure Active Directory

Modul 2: Security in Azure

  • Role-based access control (RBAC)
  • Azure AD Managed service identities
  • Azure Key Vault
  • Virtual networking
  • Express Route

Modul 3: Azure Virtual Machines

  • Virtual Machines
  • Creating and configuring Azure VMs
  • Configuring Azure VM storage
  • SQL Server on Azure VM

Modul 4: Azure SQL DB

  • Azure SQL Database
  • High Availability and disaster recovery
  • Security
  • Hybrid features
  • Managed instances

Modul 5: Azure Data Lake

  • Introduction to Azure Storage
  • Azure Big Data Stores
  • Azure Blob Storage
  • Azure Data Lake Storage
  • Data Lake Principles and Best Practices
  • Azure Storage Explorer

Modul 6: Azure Data Factory

  • Introduction to ADF
  • Creating a Data Factory
  • Data Factory Concepts
  • Scheduling and monitoring
  • Execution SSIS packages
  • Best practices and design patterns
  • Mapping Dataflows
  • Orchestration with Data Factory
  • Other orchestration tools in Azure

Modul 7: Azure Synapse Analytics

  • Modern DW architecture
  • Introduction to Azure Synapse Analytics
  • SQL on-demand
  • SQL pool (Azure SQL DW)
  • MPP architecture
  • Best Practice data loading with PolyBase
  • Apache Spark pool

Modul 8: Azure Databricks

  • Data and AI People
  • Introduction to Databricks in Azure
  • Architecture
  • Data processing with Azure Databricks
  • Scale, Cost and Management
  • Language, Data and Format

Modul 9: Azure Analysis Services

  • Enterprise-grade data models in the cloud
  • Use SSDT, SSMS and PowerShell
  • Security
  • Migrate existing models
  • Scale up and out
  • Automation and logging

Modul 10: Power BI in Azure

  • Power BI merging with Azure Analysis Services
  • Power BI Dataflows
  • Power BI administration and automation
  • Power BI Embedded

Modul 11: Summary and recap

  • End-to-end solutions
  • Logging, Source control & Deployment
  • Next step: Azure Data Engineer Certification

Yderligere information

Længde

3 dage