Got a team or group of 5 or more people? We have special options for you, such as in-person training at your site, or special group pricing for Live Virtual training. Click or tap the button below to request a special quote for your group now!Request Group Quote
Price: $1195, Length: 2 days
Power BI for the Cloud - Level 2 - Data Model Designer
What makes Power BI for the Cloud such a vast improvement over simple Excel worksheets is the Power BI Data Model, which allows data to be pulled together from multiple data sources. This course is designed for Report Builders who are ready to create custom data models for themselves and for other Power BI Report Builders.
Pre-requisite(s): Power BI for the Cloud - Level 1 - Report Builder
Lesson 1 : Understanding BI Data
Business Intelligence Data Data Source Types Power BI Data Sources
Lesson 2 : Creating Data Models
Power BI Query Import Options Planning a Data Model - Flat File Planning Power BI Data Queries Planning a Data Model - Database Planning a Data Model - Hybrid
Lesson 3 : Customizing Data Models
Query Editor Transformations Applied Steps Merging & Appending Queries Understanding the Data Modeling Tool
Lesson 4 : Power BI Functions - DAX Measures
DAX Measures Creating Measures Best Practices
Lesson 5 : Using Dates Correctly
Building Data Tables Building Hierarchies
*NOTE: if an average rating and rating count are shown on this page, they are based on all reviews associated with Dynamics Edge that are shown on the review page, and are not restricted to reviews only for the particular course offered on this page.