Data Model Design using Power BI Desktop – Level 2

Course Overview

Lesson 1: Understanding  BI Data

• Understanding the Process
• Understanding BI Data Sources
• Table Roles

Lesson 2: Creating Data Models

• Analyzing the Data Source
• Creating New Tables
• Creating Relationships

Lesson 3: Customizing Data Models

• Additional Transformations
• Editing Applied Steps
• Merging, Appending, Unpivoting Data
• Transformations in Table View
• Using the Options Dialog Box

Lesson 4: Accessing Additional Data Sources

• Using Relational Databases
• Creating a Composite Data Model
• Creating a Data Model from Cloud Sources
• Storage Modes (ImportQuery vs. DirectQuery)
• Query Folding
• Performance Analyzer

Lesson 5: Power BI Functions – Intro to DAX

• Calculated Columns
• DAX Measures
• Working with Date Tables

Lesson 6: M Language

• Getting Started with M Language
• Basic M Language Queries
• Adding, Duplicating & Splitting Columns
• The “Last Refresh” Indicator

Prerequisites

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