Free Power BI Data Modelling with DAX Course

Learn Power BI Data Modeling with DAX

• Lesson 01: Course Introduction

  01:48

  • Course Introduction Mastering Power BI Data Modeling DAX Calculations Performance Optimization and Data Visualization

    01:48

• Lesson 02: Data Modeling

  01:03:29

  • 2.01 Learning Objectives

    02:27

  • 2.02 Design and Implement a Data Model

    04:32

  • 2.03 Identifying Dimensions and Facts

    02:20

  • 2.04 Star Schema or Snowflake Schema

    04:00

  • 2.05 Configuring Table and Column Properties

    05:20

  • 2.06 Demo Configuring Table and Column Properties in Power BI

    06:57

  • 2.07 Implementing Role Playing Dimensions

    06:54

  • 2.08 Defining Relationship Cardinality

    04:54

  • 2.09 Cross Filter Direction

    02:24

  • 2.10 Demo Configuring Relationship Cardinality and Cross Filter Direction

    08:11

  • 2.11 Introduction to Date Tables in Power BI

    03:45

  • 2.12 Creating Date Tables and Relationships in Power BI

    03:39

  • 2.13 Implementing Security Roles and Permissions

    01:11

  • 2.14 Row Level Security in Power BI

    05:41

  • 2.15 Key Takeaways

    01:14

• Lesson 03: Model Calculations with DAX

  01:23:31

  • 3.01 Learning Objectives

    01:54

  • 3.02 Introduction to Data Analysis Expressions DAX

    03:26

  • 3.03 DAX Formulas and Operators

    04:28

  • 3.04 Introduction to Measures in Power BI

    04:58

  • 3.05 Creating Single Aggregation Measures

    05:12

  • 3.06 Using DAX Functions

    04:39

  • 3.07 Using CALCULATE to Manipulate Filters

    06:02

  • 3.08 Understanding Row Contexts

    00:46

  • 3.09 Demo Analyzing Sales Data with DAX and Filter Context

    12:04

  • 3.10 Time Intelligence Functions

    06:38

  • 3.11 Time Series Analysis

    03:43

  • 3.12 Using Basic Statistical Functions

    05:49

  • 3.13 Creating Measures Using Quick Measures

    05:33

  • 3.14 Demo Creating Quick Measures in Power BI for Healthcare Data

    09:20

  • 3.15 Creating Calculated Tables

    04:15

  • 3.16 Example Creating a Calculated Table

    02:39

  • 3.17 Using Calculated Tables in Relationships​

    01:02

  • 3.18 Key Takeaways

    01:03

• Lesson 04: Optimize Model Performance

  01:20:34

  • 4.01 Learning Objectives

    04:41

  • 4.02 Improve Performance​ Identify and Remove Unnecessary Rows and Columns​

    01:38

  • 4.03 Common Performance Issues in Power BI

    04:16

  • 4.04 Analyzing Data Usage

    03:22

  • 4.05 Identifying Redundant Data

    06:19

  • 4.06 Removing Unnecessary Data to Improve Query Performance

    01:50

  • 4.07 Techniques to Improve Query Performance in Power BI

    05:31

  • 4.08 Understanding Performance Analyzer

    02:49

  • 4.09 Using Performance Analyzer to Identify Performance Bottlenecks

    05:38

  • 4.10 Optimizing Measures Relationships and Visualizations

    05:43

  • 4.11 Improve Performance by Choosing Optimal Data Types​​

    02:22

  • 4.12 Data Types and Their Implications

    02:23

  • 4.13 Avoiding Unnecessary Data Conversions

    05:16

  • 4.14 Demo Optimizing Power BI Query Performance Through Data Cleansing

    12:40

  • 4.15 Improve Performance by Summarizing Data​

    05:43

  • 4.16 Best Practices for Summarization

    05:37

  • 4.17 Understanding Aggregations

    03:37

  • 4.18 Key Takeaways

    01:09

• Lesson 05: Visualize and Analyze the Data

  01:50:30

  • 5.01 Learnining Objectives

    01:37

  • 5.02 Create Reports

    03:28

  • 5.03 Visualization Types

    06:12

  • 5.04 Apply and Customize a Theme

    02:18

  • 5.05 Conditional Formatting

    05:25

  • 5.06 Configure the Report Page

    03:21

  • 5.07 Paginated Report

    04:18

  • 5.08 Paginated Reports in Power BI Creation Use Cases and Comparison with Traditional Reports

    05:37

  • 5.09 Demo Create Visualizations Part 1

    07:35

  • 5.10 Demo Create Visualizations Part 2

    07:20

  • 5.11 Enhance Reports for Usability and Storytelling​ Bookmarks

    03:13

  • 5.12 Enhance Reports for Usability and Storytelling​ Tooltips

    03:56

  • 5.13 Edit and Configure Interactions Between Visuals​

    03:40

  • 5.14 Enhance Reports for Usability and Storytelling Configure Interactions

    03:37

  • 5.15 Enhance Reports for Usability and Storytelling​ Sorting

    01:51

  • 5.16 Enhance Reports for Usability and Storytelling Sync Slicers

    01:24

  • 5.17 Enhance Reports for Usability and Storytelling Selection Pane

    02:20

  • 5.18 Enhance Reports for Usability and Storytelling Tab Order and Drill Through

    01:19

  • 5.19 Exporting Reports

    01:50

  • 5.20 Design Reports for Mobile Devices

    06:35

  • 5.21 Demo Creating a Mobile Layout

    06:54

  • 5.22 Identifying Patterns and Trends​​

    03:45

  • 5.23 Grouping

    02:51

  • 5.24 Binning

    01:04

  • 5.25 Clustering

    02:26

  • 5.26 Introduction to AI Visuals

    01:12

  • 5.27 Using AI Visuals to Analyze Key Drivers and Metrics

    05:54

  • 5.28 Using AI Visuals to Detect Anomalies and Explore Data Insights

    04:04

  • 5.29 Reference Lines and Error Bars in Power BI Visuals

    02:18

  • 5.30 Forecasting

    01:34

  • 5.31 Key Takeaways

    01:32

  • Knowledge Check