Power BI Query Editor and Dax Calculations. 2-Day Course. In-Classroom

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