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

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

Y ou can request to attend at our officed in Manchester, Birmingham, Portsmouth, Southend-On-Sea, Milton Keynes, and London.

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

Functions

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

CALCULATE & ALL

CALCULATE & FILTER

Iterator Functions (SUMX, RANKX)

Time Intelligence Formulas

DAX Best Practices in Power BI Desktop

Description supplied by the event organiser.