Data Model Design using Power BI Desktop – Level 2

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