Introduktion til Azure BI

Dette 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. I løbet af kurset vil du få en gennemgang af de DW/BI værktøjer som Microsoft stiller til rådighed i Azure og du vil lærer om de styrker og begrænsninger der er i de forskellige værktøjer. 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 med Visual Studio

Kursus agenda:

Modul 1: Azure Basics

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

Modul 2: Azure Virtual Machines

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

Modul 3:  Azure SQL DB

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

Modul 4: Azure Big Stores

  • Introduction to Azure Storage
  • Azure Big Data Stores
  • Azure Blob Storage
  • Azure Data Lake Storage
  • Azure Data Lake Storage Gen2
  • Azure Storage Explorer

Modul 5: Azure SQL DW

  • Introduction to Azure SQL DW
  • Overview of the MPP architecture
  • Strengths
  • Azure SQL DW Gen 2
  • Data loading with PolyBase
  • Developing and migration

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
  • Next: Data Pipelines

Modul 7: Azure Automation

  • Automating processes with runbooks
  • Azure Automation Capabilities
  • PowerShell modules
  • Orchestration of other Azure services
  • Runbook execution
  • Other options?

Modul 8: Azure Analysis Services Tabular

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

Modul 9: Azure Databricks

  • Data and AI People
  • Introduction to Databricks in Azure
  • Architecture
  • Data processing with Azure Databricks
  • Machine Learning with Azure Databricks
  • Scale, Cost and Management
  • Language, Data and Format
  • Next: Azure Databricks Delta

Modul 10: Azure Machine Learning

  • Machine Learning in Azure
  • Cloud Data Science
  • Building Azure Machine Learning Models

Modul 11: Power BI in Azure

  • Power BI administration and automation
  • Power BI REST APIs
  • Power BI Embedded
  • Embedding options
  • Power BI Dataflows
  • Power BI merging with Azure Analysis Services

Modul 12: Summary and recap

  • End-to-end solution
  • Logging
  • Source control
  • Deployment

 

Copyright 2018 Orange Man · RSS Feed · Log ind · Google+

Organic Themes