Business Booking Details

Payment Of Invoices

For bookings from established businesses, we do not require payment at the point of booking.

We will send you an invoice which you can submit to your accounts payable system.

Purchase Orders

If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.

  • If you already have a P.O. number when booking add it to the PO number box on the booking form, and we will include it on your invoice.
  • If you need an invoice to generate a P.O. number in your accounts system, please book the course as normal and add a note in the PO number box – to be provided
  • We will send you an invoice (without a P.O.) which you can use to generate a P.O..
  • We will then re-issue your invoice with your P.O. included when you provide us with it

PAYMENT METHODS:

You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.

We accept payment either via direct bank transfer or card

Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.

Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.

Learn to use DAX’s most powerful functions on this Advanced DAX training course.

This is a hands-on course. There is plenty of time to experiment with the techniques you are being taught and ask questions.

By the time you finish, you’ll be comfortable using all of DAX’s most powerful tools.

An advanced course that covers DAX’s most powerful features.
Plenty of one-to-one attention and time to ask questions.
Friendly, certified trainers, small groups and a comfortable place to learn.
Ongoing support and help with any issues you have after the course.

What Will I Learn?

By the end of this course, you will be able to confidently:

  • Create a Measures table
  • Use variables
  • Use the DAX studio
  • Define and use What If scenarios and parameters

The Trainer

Oakley is one of our regular trainers for this course. He has been a Microsoft certified trainer for 8 years.

He has been training Microsoft applications for 19 years and focuses on Power BI and Project.

 

Am I Ready For This Course?

This course is for existing users of DAX who want to develop their understanding of DAX.

Before coming on this course, you need to have attended our introduction to DAX course or have equivalent Power BI skills.

Course Details

Download full course details Download full course details

This one day course covers the following areas:

  1. Creating a Measure Table
  2. Using Variables
  3. Time Intelligence Calculations
  4. DAX as a Query Language: EVALUATE Function
  5. Introduction to DAX Studio
  6. Advanced Table Functions
  7. Advanced Evaluation Context: Cross Filters, Nested Row Context
  8. Exploring the Evaluation Context with Information Functions
  9. Defining and Using Parameters
  10. Defining and Using What-If scenarios

During the course, the trainer will briefly introduce you to ChatGPT and its possibility when using DAX. This section will not be covered in course materials or post-course support.

The Training Day

We provide everything you need for a really fun productive day of Power BI training. You don’t need to bring anything. 

Our courses run from 9.30 am to roughly 4.30 pm with refreshments and biscuits throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned facilities, and some of the nicest instructors on the planet.

Also, you’ll receive:

A full-colour manual which covers everything in the course.
Your course exercises so that you can practice at home.
A Certificate of Attendance.

Online Training Requirements

To attend this Power BI course online, you will need:

Power BI on your Windows PC with a camera, speakers & microphone
A stable internet connection capable of running Zoom
To be a confident computer user and able to use Zoom

If you have access to a second screen, we would encourage you to use it as it improves the experience.