01483 688488 01483 688488 Request a callback Email us
Microsoft
Office 365Office 365
AccessAccess
ExcelExcel
OutlookOutlook
Power AutomatePower Automate
Power BIPower BI
PowerPointPowerPoint
ProjectProject
SharePointSharePoint
VisioVisio
WordWord
Adobe
After EffectsAfter Effects
CaptivateCaptivate
Creative CloudCreative Cloud
IllustratorIllustrator
InDesignInDesign
PhotoshopPhotoshop
Premiere ProPremiere Pro
CAD
AutoCADAutoCAD
RevitRevit
SketchUpSketchUp
SolidWorksSolidWorks
Technical
Crystal ReportsCrystal Reports
HTML & CSSHTML & CSS
MapInfoMapInfo
RR
SPSSSPSS
SQLSQL
WordPressWordPress
Finance
Finance CoursesFinance Courses
XeroXero
Professional Development
ResilienceResilience
Training: 90 Minute Blitz Training: 90 Minute Blitz
Soft Skills
AssertivenessAssertiveness
Chairing MeetingsChairing Meetings
Minute TakingMinute Taking
Team LeaderTeam Leader
Time ManagementTime Management
Executive Coaching
Deliver Confident & Impactful Presentations Training
Power BI Training: 1 Day Advanced DAX Course

Power BI Training: 1 Day Advanced DAX Course

Introduction

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 our usual trainer 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 skills.

Course Detail

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

The Training Day

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

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 A4 manual covering everything in the course to keep.
✔ A USB stick so that you can take the course exercises home with you.
✔ A Certificate of Attendance.

Online Training Requirements

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

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

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