Power BI Course. Query Editor and Advanced DAX. Virtual Classroom.

Power BI Course. Query Editor and Advanced DAX. Virtual Classroom.

In this Power BI Course, ofr intermediate users, you will use Query Editor and DAX to manipulate and caculate data to enrich your data sets.

By PCWorkshops

Select date and time

Wed, 1 May 2024 02:00 - 08:00 PDT

Location

Online

Refund Policy

No Refunds

About this event

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

Tags

Organised by

PCWorkshops

At PCWorkshops, we offer instructor-led online courses in our Live Virtual Classroom. We cover Java programming, Python Coding, Database Development, SQL, Data Analytics and MS Project.

More about us:

training@pcworkshopslondon.co.uk

  • Our classes are instructor led, in our Live Virtual Classroom
  • Courses well developed by registered, qualified instructors with a wealth of experience in software development and training.
  • The maximum groups size that can access our Virtual Classroom, is 4.
  • Every one gets personalised attention.

Why learn with us at PCWorkshops:

  • Excellent, up-to-date courses, following latest trends and technologies.
  • Excellent trainers with professional experience.

Award Winning Trainer

We offer Training Courses in Software Packages:

  • Java Programming
  • Python Programming, Python data analytics, Python Machine Learning
  • Database design and Data Normalisation
  • SQL Courses
  • Data Analysis and 
  • MS Excel, data analyses with Excel. Excel VBA
  • Access Database Courses.
  • MS Project Training
  • MS Office Training

Our Style:

  • Relaxed, Practical, Useful

Methods of instruction:

  • Classroom training with max class-size 4 people
  • Virtual classrooms via online video links
  • 1-1 mentoring
  • Customised training

Certification:

Our PCWorkshops certificates are assessment based.Our Java course outlines are aligned with Oracle courses. We assist with exam prep for the prestigious, international Oracle Certified Associate qualification.

Our clients are:

Data analysts and all others who use large sets of dataSoftware companies, testing companies, companies employing software developersCoders and new coders who need Accredited Java qualification

Customisation:

We can tailor all our courses. Email to customise location, times, content.

 

 

 

£400