Power BI Advanced DAX Course, 2 Days

Course Exercises

Code examples

Course Notes

PCWorkshops Power BI Certificate

Personalised attention: max 4 people in the class

Overview and Introduction to The Query Editor

Perform Data Transformations

Introduction to Transformations

Data Transformations

Conditional IF

Introduction to Advanced Transformations

Merge Function

Append Data

Custom Calculations

Group By Function

Introduction to Cleanse Data

Download the Training Data Files

Query Editor Diagnostics

Cleansing Data Files

Parameters

Introduction to Power BI Data Connections and Sources

Loading Data from SQL Server

Loading Data from CSV and TXT

Practical Activity - Load Data from a CSV file

Loading Data from the Web

Practical Activity - Connect to Data on the Web

Loading Excel Data from One Drive for Business

Loading Data from XML files

Loading Data from JSON

Loading Data from the Power BI Service

Intro to Database Normalization

Data ("Fact") Tables vs. Lookup ("Dimension") Tables

Creating Power BI Table Relationships

"Star" vs. "Snowflake" Schemas

Active vs. Inactive Relationships

Relationship Cardinality

Connecting Multiple Data Tables

Filtering & Cross-Filtering

Hiding Fields from the Power BI Report View

Data Modeling & Power BI best Practices

Introduction

Meet Data Analysis Expressions (DAX)

Intro to DAX Calculated Columns

Intro to DAX Measures

Adding Columns & DAX Measures in Power BI Desktop

Implicit vs. Explicit DAX Measures

Filter Context Examples in Power BI

Step-by-Step DAX Measure Calculation

Understanding DAX Syntax & Operators

Common DAX Function Categories

Basic Date & Time Functions

Conditional & Logical Functions (IF/AND/OR)

Common Text Functions

Joining Data with RELATED

Basic Math & Stats Functions

COUNT Functions (COUNTA, DISTINCTCOUNT, COUNTROWS)

CALCULATE

CALCULATE & ALL

CALCULATE & FILTER

Iterator Functions (SUMX, RANKX)

Time Intelligence Formulas

DAX Best Practices in Power BI Desktop

More about us

FAQ's

Client Comments