DP-500 Enterprise-Scale Analytics Solutions, Part 2 of 2: Advanced Concepts and Power BI
with expert Tijs Maes
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 | Advanced | |
| Runtime | 1h 29m | |
| 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 Advanced concepts and Power BI. it will take you through DAX, Query Diagnostics, authentication methods, security, performance and more.
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 2
Advanced Concepts Part 1 (33:47)
- Introduction (01:59)
- Performance (02:34)
- Premium Features (01:39)
- Accessibility (01:10)
- DAX vs. Tabular (02:44)
- DAX Studio (01:46)
- Query Diagnostics (01:30)
- VertiPaq Analyzer (01:24)
- Data Refreshing (05:02)
- Incremental Refresh (02:34)
- Working with Shared Datasets (02:19)
- Privacy Levels in Power BI (02:30)
- Authentication Methods (01:31)
- Object Level Security (02:10)
- Sensitivity Labels (02:10)
- Summary (00:37)
Advanced Concepts Part 2 (15:34)
- Introduction (00:28)
- Perform Advanced Calculations (02:20)
- Power Query (01:23)
- Tabular Editor (02:01)
- Composite Models (06:20)
- Denormalization (02:53)
- Summary (00:08)
Power BI Admin (40:03)
- Introduction (00:21)
- Admin Center (01:53)
- Admin Roles (02:48)
- Admin Tasks (01:27)
- Recommend Monitoring and Auditing (02:02)
- Licensing Options (04:58)
- Sharing Reports (01:50)
- Capacity Nodes (01:18)
- Embedded Reports (03:09)
- Monitor Power BI environment using REST API�s (01:17)
- APIs (00:38)
- REST APIs (00:40)
- Demo: Azure Portal (02:37)
- Analyze Results (02:06)
- Demo: Quality and Perforamnce (05:55)
- Scanning a Power BI Environment (00:26)
- Azure Purview (00:45)
- Prerequisites (01:23)
- Power BI Tenant Registration and Scan (03:39)
- Summary (00:42)