Preloader spinner

Microsoft Power BI Desktop Advanced

Image of laptop displaying an image containing the words Microsoft Power BI

Course Aims:

This Microsoft Power BI Desktop Advanced training course is for anyone looking to create formulas using the advanced DAX functions. You will create calculations using calculated columns, measures, quick measures, and tables. You will use the Power Query Editor to clean up your data tables and generate structured reports.

 

Course Pre-requisites:

Delegates should have attended the Intermediate course or have previously used Power BI and can create visuals and basic calculations using calculated Columns & Measures.

 

Course Objectives:

On completion of this course, delegates will be able to:

  • Work in the Power Query Editor to transform data
  • Create calculations using Advanced DAX Functions
  • Add tooltips, conditional formatting and sparklines to visuals
  • Create Custom column calculations
  • Append and Merge Queries

 

Course Content:

Data Sources

  • Copying and entering data into a table
  • Importing a Folder

 

Power BI Query Editor (PQE)

  • Column Quality / Profile and Distribution
  • Detect Data types
  • Split Columns
  • Use Custom Column to create calculation
  • Adding Conditional Column
  • Column From Example
  • Index Column
  • Transpose
  • Group By (Basic / Advanced)
  • Editing data in an existing table
  • Append and Merge queries

 

Advanced Visualisation Features

  • Applying Conditional formatting to dynamic titles
  • Using a Slicer to return different results
  • Adding Tool Tips Page
  • Adding Sparklines (column / lines) to visuals
  • Managing Visualisation relationships e.g. properties

Advanced DAX  Functions (Calculated columns, Measures, Quick Measures and New Table)

  • Relationship Functions (e.g. RELATED, RELATEDTABLE)
  • Aggregation and Iteration Functions (e.g. SUMX, AVERAGEX)
  • Text Functions (e.g. MID, FIND, FORMAT)
  • Logical Functions (e.g. IF, AND, SWITCH)
  • Date Functions (e.g. DATEDIFF, DATEADD)
  • Filter Functions (e.g. ALL, CALCULATE, FILTER)
  • Information Functions (e.g. CONTAINSSTRING, ISBLANK)
  • Table Manipulation Functions (e.g. SUMMARIZE, VALUES)
  • Time Intelligence Functions (e.g. DATESYTD, DATESMTD)
  • Math and Trig Functions (e.g. DIVIDE, ROUNDUP)

 

Hints and Tips

  • Calculations
  • Power BI Reports in PowerPoint
  • Edit Interactions with Slicers
  • Image URL

Download PDF Outline

Public Schedule

RRP:  
£690 per delegate
Our price:  
£495 per delegate

Virtual Private Training

Contact us for pricing

Onsite Training

Contact us for pricing

Note

All prices exclude VAT at 20%.

VAT registration number: 450 4347 14

You may like...

Microsoft Project Advanced

Excel in project management with our 1-day Advanced Microsoft Project course. Master complex scheduling, reporting, and customisation to lead successful projects.

An icon of a person

N/A

An icon of a clock

1 day

Microsoft Project Intermediate

Take your Microsoft Project skills to the next level with our 1-day Intermediate course. Dive deeper into advanced tools and techniques to manage projects efficiently.

An icon of a person

N/A

An icon of a clock

1 day

Microsoft Project Introduction

Master the basics of Microsoft Project in our 1-day introductory course. Learn to plan, manage, and optimise your projects effectively.

An icon of a person

N/A

An icon of a clock

1 day

Enquire about this course

Microsoft Power BI Desktop Advanced
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Join our mailing list

Receive details on our new courses and special offers

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.