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