Intermediate Microsoft Power BI Training

Start Date End Date Venue Fees (US $)
16 Nov 2026 Dubai, UAE $ 2,500 Register
30 Nov 2026 Live-Online $ 1,800 Register

Intermediate Microsoft Power BI Training

Introduction

This course is a continuation from the Fundamentals Power Bi course.

Learn how to get the most out of Power Query by editing and shaping the data before it lands into Power BI with M code.

Learn about Measures which are powerful functions written with DAX that can extract answers directly from the data.

Use DAX to automate settings inside Visuals and use Bookmarks and Buttons to help consumers navigate your reports.

Objectives

    • Gain insight into business intelligence and how to use DAX in Power BI.
    • Learn about Data Modelling and connect multiple data tables.
    • Create a Date Table for better date related insights.
    • Create a range of interactive visualisations including a range of charts, tables, matrixes and maps.
    • How to publish and share your data.

Training Methodology

This is an interactive course. There will be open question and answer sessions, regular group exercises and activities, videos, case studies, and presentations on best practice. Participants will have the opportunity to share with the facilitator and other participants on what works well and not so well for them, as well as work on issues from their own organizations. The online course is conducted online using MS-Teams/ClickMeeting.

Who Should Attend?

Course Outline

Power Query Editor

  • Advanced data transformation
  • Cleaning irregularly formatted data
  • Adding Columns
  • Merge and Append Queries
  • Query from a Folder
  • View and Edit M Code

M Functions

  • Text and dates Date functions
  • Column from Examples
  • Custom Column Functions
  • Blank queries

Modelling in Power BI

  • Database relationships
  • Create calculated DAX columns
  • Create calculated measures with DAX

Dates

  • Create Date tables CALENDERAUTO function
  • Working with time-based data
  • Date based data comparisons with DAX
  • SAMEPERIODLASTYEAR function
  • TOTALYTD and TOTALMTD
  • functions

DAX

  • Columns and Measures
  • CALCULATE
  • SUMX, AVERAGEX etc.
  • FILTER
  • ALL, ALLEXCEPT, ALLSELECTED
  • IF, SWITCH, FIND
  • RELATED
  • Manage Measures
  • DAX Structure

DAX in Visualisations

  • Use Measures to populate Fields in Visualisations
  • Conditional Formatting

User Navigation

  • Bookmarks
  • Buttons
  • Hyperlinks

Custom Tooltips

  • Tooltip Page
  • Applying Tooltips

Power BI Service - Workspaces and Apps

  • Creating a Workspace
  • Managing Workspace Access
  • Publish to a Workspace
  • Create and Publish an App

 

Accreditation

Related Courses

Nationals Development Training Program
2026 Training Calendar (Excel)
Laboratory Systems ISO17025 Consulting
Competency Frameworks Consulting
Talent & Succession Planning Solutions
Employee Assessment & Development Plans