Data Model Design using Power BI Desktop – Level 2 Classroom Live Bellevue, WA November 20, 2019

Course Overview

Lesson 1: Understanding Power BI Data Queries

• Overview of Power BI Queries
• Power Query
• Data Sources

Lesson 2: Creating and Transforming Data Models

• Understanding a Basic Data Model
• Creating the Initial Data Query
• Converting Raw Data into a Data Model

Lesson 3: Data Transformations

• Query Editor Transformations
• Altering the Data
• Creating new Data
• Refreshing Data

Lesson 4: Accessing Additional Data Sources

• Using an Access database
• Creating a Hybrid Data Model
• Working with Data

Lesson 5: DAX Calculated Columns and Measures

• Review of Calculated Columns
• Power BI Measures
• Evaluation Context
• Optimize Model Performance
• Date Tables

Lesson 6: Introduction to the M Language

• Power BI Functions: M Language
• M Language Syntax
• Adding Columns

Appendices

• Storage Modes (Import vs DirectQuery)
• Dataverse
• Power Query and Query folding

Prerequisites

Data Analysis using Power BI Desktop – Level 1 – Report Builder

Course Comments