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