This is a 1-day instructor-led course is the second offering in a custom Power BI Desktop training series. This course shows participants that Power BI is such a vast improvement over simple Excel worksheets is the Power Query engine in both Power BI and Excel. Power Query allows data to be pulled and transformed from multiple data sources. Using fundamental concepts of Self-Service Data Model Design, students will use Power Query to extract, transform, and load data to create manageable and scalable data models. This course is designed for Report Builders who are ready to create custom data models. Students will also be receive an introduction to the M Language as well as Data Analytic eXpressions (DAX). Note: participants of this course should have the knowledge and skills presented in the PBI-RB Data Analysis using Power BI Desktop; Level 1 Report Builder course.
Target Audience
This course is designed for Report Builders who are ready to create custom data models for themselves and for other Power BI Report Users.
What You'll Learn
- Get Started with Power Query
- Get Data from Data Sources
- Prepare the Data
- Model Data – Creating a Data Model
- DAX Calculated Columns and Measures
- Power BI Functions – M Language
- Course Number PBI-DMD
- Course Length 1 day
- Course Fee $595.00
- Delivery Format vILT (Instructor Led; Virtual LIVE Online; Remote Training)
- Course Topic Business Intelligence
- Vendor Microsoft
- Technology Excel
Need a different date? This course is also offered on these dates
| Date | Course ID | Course Name | Duration | Delivery Format | Registration | |
|---|---|---|---|---|---|---|
| 06/23/2023 | PBI-DMD | Data Model Design using Power BI Desktop; Level 2 (PBI-DMD) | 1 day | vILT | Register |
Register for course: PBI-DMD
"*" indicates required fields