Course Outline

Unit 1: Understanding Power BI Data Queries

Topic A: Overview of Power BI Queries
Topic B: Power Query
Topic C: Data Sources

Unit 2: Creating and Transforming Data Models

Topic A: Understanding a Basic Data Model
Topic B: Creating the Initial Data Query
Topic C: Converting Raw Data into a Data Model

Unit 3: Data Transformations

Topic A: Query Editor Transformations
Topic B: Altering the Data
Topic C: Creating new Data
Topic D: Refreshing Data

Unit 4: Accessing Additional Data Sources

Topic A: Using an Access database
Topic B: Creating a Hybrid Data Model
Topic C: Working with Data

Unit 5: DAX Calculated Columns and Measures

Topic A: Review of Calculated Columns
Topic B: Power BI Measures
Topic C: Evaluation Context
Topic D: Optimize Model Performance
Topic E: Date Tables

Unit 6: Introduction to the M Language

Topic A: Power BI Functions: M Language
Topic B: M Language Syntax
Topic C: Adding Columns