Power BI Query Editor and DAX

Excellent course to learn presenting data visually with Microsoft Power BI. Online. Practical. Instructor-led.

Power BI in depth for intermediate users. Calculations, Query Editor and Advanced DAX Calculations

The Power BI Query Editor

Overview and Introduction to The Query Editor

Perform Data Transformations

Introduction to Transformations

Data Transformations

Conditional IF

Advanced Transformations

Introduction to Advanced Transformations

Merge Function

Append Data

Custom Calculations

Group By Function

Cleanse Data and Parameters

Introduction to Cleanse Data

Query Editor Diagnostics

Cleansing Data Files

Parameters

Connect to Power BI Connections and Data Sources

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

Build a Relational Data Model

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

Add Calculated Fields with DAX

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

How does it work:

• Instructor-led
• Fully interactive, with screen-sharing
• Clear explanations with demonstrations and examples
• Practical exercises to be tried out by delegate
• Ask your questions and get the solutions straight away.
• Just as good as a classroom session.

What to do:

• When you make the booking, it will give you the connection instructions.

Included:

• PCWorkshops's Visual Data with Power BI Certificate
• Course notes, exercises and spreadsheets examples