Cost Calculator

Price per head:

£ .

Duration:

2 Day

* Price is exclusive of VAT.

Tell Me More

Testimonials

Petrobas

Live Online DAX "Very good training. I was able to learn many different DAX formulas and it was exactly what I needed."

Foster Refrigeration

"The training was pitched at exactly the right level and Simon Cubbin tailored the course to fit the requirements of our company. After a 2 day course we had a working sales analysis model with all the correctly structured measures in place ready for deployment across the business. Simon's level of knowledge and teaching style were excellent. Highly recommended.

Network Rail

"Very interesting to get to grips with the principles and some of the practices from DAX. Enjoyed the course and Simon was great with his enthusiasm and patience."

Locations outside Coventry

Power BI DAX Training Course Beginners Coventry

Coventry Beginners Power BI DAX Course Overview

Beginners Power BI DAX training course in Coventry

In in the middle of the West Midlands we are now delivering training courses in the conveniently located city of Coventry. Computer Tutoring has already provided Power BI DAX training for many companies in the surrounding areas so delivering Power BI DAX Training Course training in Coventry is a natural step.

We can come to you, or you can come to us for your Beginners Power BI DAX Training Course training course.

Explore Coventry, a city steeped in history with its iconic cathedral and vibrant arts scene.

Other training courses in Coventry.

Course Duration: 2 Day

Course Prerequisites for your training in Coventry

This course is designed for individuals with foundational Power BI knowledge who are ready to explore DAX. To make the most of your training, we recommend:

Basic Power BI skills:Familiarity with creating reports, importing data, and using visuals.
Intermediate Excel experience:Understanding of functions like SUM, IF, and VLOOKUP, and working with tables.

Not sure if you're ready for the advanced course? Take a quick look at the beginners' training to make sure you're all set. Microsoft Power BI Beginners Training Course.

Complete Course Outline

What is Dax?

DAX in the world of Excel
Cells vs tables
Iterators - what are they?

Introducing DAX

Understanding DAX calculations
DAX data types
DAX operators
Calculated columns vs measures
Variables
Error handling in DAX
Formatting DAX Code
Common DAX functions

Basic Table Functions

What are table functions?
EVALUATE syntax
Table expressions
Understanding FILTER
Understanding ALL, ALLEXCEPT, and ALLNOBLANKROW
UNDERSTANDING VALUES and DISTINCT

Understanding Evaluation Contexts

Introduction to evaluation contexts
Understanding the row context
Using SUM in a calculated column
Using columns in a measure
Row context with Iterators - EARLIER function
Working with many tables
Row contexts and relationships
Filter context with relationships
Introducing VALUES
Introducing ISFILTERED, ISCROSSFILTERED

CALCULATE and CALCULATETABLE

Understanding CALCULATE
Understanding the filter context
CALCULATE examples
Filtering a single column
Filtering with complex conditions
Using CALCULATETABLE
What are circular dependencies
CALCULATE rules
Introducing ALLSELECTED
Understanding USERELATIONSHIP

DAX Examples

Finding ratios and percentages
Cumulative totals
Using ABC (Pareto) classification
Finding sales per day and working day
Differences in working days
Static moving averages

Time Intelligence Calculations

What is time intelligence?
Building a date table
Handling multiple relationships to the date table
Aggregating overtime (year-to-date|qarter-to-date)
Opening and closing balances

Other Related Courses

Post-Course Resources

Training notes & exercise files
Online materials: video tutorials & shortcuts
3 months post training support

Power BI DAX training is available online and in person.

Live Online Training

Power BI Online Training - All you need to know.