Watch trailer
Course at a glance
Included in these subscriptions:
- Dev & IT Pro Video
- Dev & IT Pro Power Pack
| Release date | 8/25/2022 | |
| Level | Intermediate | |
| Runtime | 0h 41m | |
| Closed captioning | N/A | |
| Transcript | N/A | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | Included | |
| Exams | Included |
Course description
The DP-500 exam measures your ability to accomplish the following technical tasks: implement and manage a data analytics environment; query and transform data; implement and manage data models; and explore and visualize data. and it's scored on the following domains:
Implement and manage a data analytics environment (25–30%)
Query and transform data (20–25%)
Implement and manage data models (25–30%)
Explore and visualize data (20–25%)
This course covers an introduction to the exam, as well as Azure Synapse.
Prerequisites
The DP-500 exam measures Advanced Power BI Skills including managing data, data processing in both on-premise and in cloud. Users should have firm knowledge of Power Query and DAX (Data Analysis Expressions) as well as Azure Synapse Analytics along with experience with Relational databases and visualizing data.
Meet the expert
Tijs Maes is co-founder of a Belgian startup active in data visualization. Besides my current role, I love to teach others about Microsoft Power BI, a tool that I use everyday. I have been able to help a lot of people through my training, and enjoy learning!
Course outline
Module 1
Get Started (11:45)
- Introduction (00:16)
- Audience Profile (01:10)
- Data Platform Services (02:01)
- Demo: Azure Synapse and Power BI (08:08)
- Summary (00:08)
Azure Synapse (30:09)
- Introduction (01:10)
- Azure Synapse (00:16)
- Manage Analytics Development Cycle (03:06)
- Cloud Data Solution (02:54)
- Serverless (11:40)
- Best Practices for Serverless SQL Pool (03:32)
- Machine Learning to Predict Function (03:38)
- Python Examples (02:29)
- Summary (01:20)