About This Event

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

Staying overnight?

Hotels within walking distance of London.

Frequently asked questions