Microsoft Power BI – The Practical Guide 2024

Course Curriculum

Chapter 1: Getting Started

Lecture 1: Welcome to This Course

Lecture 2: What is Power BI?

Lecture 3: Installing Power BI Desktop

Lecture 4: Connecting Power BI Desktop to Source Files

Lecture 5: Creating our First Visuals

Lecture 6: Join our Online Learning Community

Lecture 7: Comparing Excel & Power BI

Lecture 8: Course Outline

Lecture 9: The Two Ways (Paths) Of Taking This Course

Lecture 10: How to Get the Most Out of This Course

Lecture 11: Important: How to Access Course Resources, Project Files & Slides

Chapter 2: Understanding the Power BI Desktop Basics & Preparing the Course Project

Lecture 1: Module Introduction

Lecture 2: The Power BI Desktop Workflow

Lecture 3: Interface Tour

Lecture 4: Important! Creating the Project Template & Recommended Settings

Chapter 3: Data Preparation in the Power Query Editor

Lecture 1: Module Introduction

Lecture 2: Understanding Data Preparation / Cleaning / Cleansing

Lecture 3: Connecting Power BI Desktop to Source Files

Lecture 4: How Power BI Queries Data

Lecture 5: Understanding Basic Row Operations

Lecture 6: Filtering Data

Lecture 7: Analyzing Columns & Removing Blank Fields

Lecture 8: Understanding & Using the Append Feature

Lecture 9: Choosing & Removing Columns

Lecture 10: Append Behind the Scenes

Lecture 11: Understanding the Transpose Feature

Lecture 12: Replacing Values

Lecture 13: Working with Dates – The Basics

Lecture 14: Understanding Data Formats

Lecture 15: Handling Data Format Errors

Lecture 16: Understanding Pivoting & Unpivoting

Lecture 17: Applying Pivoting & Unpivoting

Lecture 18: Fixing a Sorting Problem

Lecture 19: Extracting Data, Splitting Columns & Sorting Multiple Columns

Lecture 20: Introducing the "Group By" Feature

Lecture 21: Improving the Project Structure

Lecture 22: Wrap Up

Chapter 4: Data Transformation in the Power Query Editor

Lecture 1: Module Introduction

Lecture 2: Data Warehouse, Data Model & Data Schema

Lecture 3: The Star Schema – Theory

Lecture 4: Applying the Star Schema to our Project

Lecture 5: Understanding References

Lecture 6: Comparing References & Duplicates

Lecture 7: Importing Country & Region Codes

Lecture 8: Using "Enter Data" to Create a Table

Lecture 9: Understanding the Merge Feature

Lecture 10: How to Join Tables

Lecture 11: Understanding Outer, Inner & Anti Joins

Lecture 12: Join Kind in Practice

Lecture 13: Handling Merge Errors

Lecture 14: Understanding the DIM-age Table

Lecture 15: Bringing Back the "age-group" Column

Lecture 16: Getting the Maximum Values From Each Age Group

Lecture 17: Creating Conditional Columns

Lecture 18: Creating an Index Column

Lecture 19: Creating a DIM-gender Table

Lecture 20: Understanding the FACT Table

Lecture 21: Finishing the FACT Table

Lecture 22: Applying Basic Mathematical Operations

Lecture 23: Using the Enable Load Feature

Lecture 24: Wrap Up

Chapter 5: The Data Model: Working with Relationships & DAX (Data Analysis Espressions)

Lecture 1: Module Introduction

Lecture 2: Query Editor vs Data Model

Lecture 3: Understanding Relationships

Lecture 4: Creating our First Relationship

Lecture 5: Understanding Cardinality & Difference Relationship Types

Lecture 6: One to Many & Many to One

Lecture 7: One to One

Lecture 8: Many to Many

Lecture 9: Fixing the Column Order Bug

Lecture 10: Understanding the Cross Filter Direction

Lecture 11: Understanding Active Properties

Lecture 12: Adding Relationships to the Project

Lecture 13: M-Language vs DAX (Data Analysis Expressions)

Lecture 14: Creating a Custom Column with the M-Language

Lecture 15: Creating a Calculated Column with DAX

Lecture 16: M vs DAX – What Should I Choose?

Lecture 17: The DAX Basics

Lecture 18: The Core DAX Syntax

Lecture 19: DAX Data Types

Lecture 20: DAX Operators

Lecture 21: DAX Core Functions

Lecture 22: Creating a Table with the CALENDAR Function

Lecture 23: Extracting Data with the DOT Notation

Lecture 24: Adding & Dividing Columns

Lecture 25: Working with IF Functions

Lecture 26: Understanding Relationship Functions

Lecture 27: Calculated Column vs Measure

Lecture 28: Understanding & Creating Measures

Lecture 29: Working with FILTER & CALCULATE Functions – Theory

Lecture 30: Combining CALCULATED & FILTER Functions

Lecture 31: Adding the Filter Condition to CALCULATE

Lecture 32: Using Measures in Measures

Lecture 33: Changing the Measure's Home Table