Welcome to this repository, targeted to trainers delivering DP-500. It provides a number of usefull resources:
First of all, there is a set of Bicep templates, allowing you to deploy a DEMO Azure environment for DP-500. It contains the following resources:
-
A Virtual Machine with Power BI Desktop, Report Builder, DAX Studio, Tabular Editor, Data Gateway already installed, as well as a set of lab and demo files from github reposUPDATE: Consider using a Microsoft DevBox (Preview) link -
A SQL Server Virtual Machine -
An Azure Synapse Analytics environment, configured with a number of pipelines (copy data) and scripts (to demo)
-
A few Azure SQL Databases on the serverless tier (AdventureWorksLT and AdventureWorksDW2022-DP-500)
-
An Azure Data Lake with some containers
-
A Microsoft Purview account, with some scripts to register the above datasources and start a scan.
-
Supporting resources like KeyVault, a VNET and various role assignments
-
A Power BI Embedded environment, with A4 capacity, which corresponds to P1 (Premium P1). You can attach this in Power BI Service to create workspaces with Premium Capacity. Check out https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-premium-testing
-
A Logic App to suspend the Power BI Embedded every 2 hours between 10:00 and 20:00 (cost saving!)
-
A Logic App to pause the Synapse SQL Dedicated pool at 18:00 and 20:00 (cost saving!)
In order to deploy this environment, check out this page.
Next, there is a set of demo's and usefull resources for each module.
- Module 01: Introduction to data analytics on Azure
- Module 02: Govern data across an enterprise
- Module 03: Model, query, and explore data in Azure Synapse
- Module 04: Prepare data for tabular models in Power BI
- Module 05: Design and build tabular models
- Module 06: Implement advanced data visualization techniques by using Power BI
- Module 07: Implement and manage an analytics environment
- Module 08: Manage the analytics development lifecycle
Next, there is a set of whiteboard for each module.
- Module 01: Introduction to data analytics on Azure
- Module 02: Govern data across an enterprise
- Module 03: Model, query, and explore data in Azure Synapse
- Module 04: Prepare data for tabular models in Power BI
- Module 05: Design and build tabular models
- Module 06: Implement advanced data visualization techniques by using Power BI
- Module 07: Implement and manage an analytics environment
- Module 08: Manage the analytics development lifecycle