Microsoft Data & Power BI
Data Model Design using Power BI Desktop - Level 2
Design strong data models in Power BI.
1 dayIntermediate6 modules
About this course
Design strong data models in Power BI. In one day you will shape data with Power Query, build and transform models, connect more sources, write DAX calculated columns and measures and take a first look at the M language.
Curriculum
6 modules
- Topic A: Overview of Power BI Queries
- Topic B: Power Query
- Topic C: Data Sources
- Topic A: Understanding a Basic Data Model
- Topic B: Creating the Initial Data Query
- Topic C: Converting Raw Data into a Data Model
- Topic A: Query Editor Transformations
- Topic B: Altering the Data
- Topic C: Creating new Data
- Topic D: Refreshing Data
- Topic A: Using an Access database
- Topic B: Creating a Hybrid Data Model
- Topic C: Working with Data
- Topic A: Review of Calculated Columns
- Topic B: Power BI Measures
- Topic C: Evaluation Context
- Topic D: Optimize Model Performance
- Topic E: Date Tables
- Topic A: Power BI Functions: M Language
- Topic B: M Language Syntax
- Topic C: Adding Columns
Who it's for
Power BI users with Level 1 skills who are ready to model data properly.
Before you start
- Data Analysis using Power BI Desktop - Level 1 - Report Builder
Related courses
More in Microsoft Data & Power BI →Intermediate
55128 Writing Reports with Report Builder and SSRS Level 2
Microsoft Data & Power BI
View course →Intermediate
55232 Writing Analytical Queries for Business Intelligence
Microsoft Data & Power BI
View course →Foundation
55315 Introduction to SQL Databases
Microsoft Data & Power BI
View course →Intermediate55353
Administering a SQL Database Infrastructure (55353)
Microsoft Data & Power BI
View course →IntermediateDP-300 Exam Prep/DP-300T00
Administering Microsoft Azure SQL Solutions (DP-300 Exam Prep/DP-300T00)
Microsoft Data & Power BI
View course →Foundation
Data Analysis using Power BI Desktop - Level 1: Report Builder
Microsoft Data & Power BI
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.