Power BI Training

DAX Training Course

£795 + VAT for most venues (£950 + VAT for London)

2 days

We have other courses which show how to create basic DAX measures as part of other applications, but this is the DAX course for hard-core programmers! Learn how to create calculated columns and measures using DAX, and how to write DAX queries to interrogate databases. On the way you'll pick up lots of clever techniques for building data models, including ways to model multiple calendars, parent-child hierarchies and dynamic security. The course uses PowerPivot for editing measures, but the techniques learnt apply equally well to Power BI Desktop and Analysis Services (tabular model).

We don't have any dates scheduled for this course, but we may well consider adding them - it's always worth asking (or consider an onsite Power BI training course).

Course Contents - PDF

Course Contents

Data models

Linking to data
Creating a data model

Calculated columns

Creating calculated columns
IF and SWITCH
Showing RELATED data
Dealing with blanks

Basic measures

Creating measures
Understanding filter context
Using a measures table
AggregateX functions

Filtering

The CALCULATE function
Removing and replacing context
The FILTER function
VALUES: editing filter context

Understanding EARLIER

How it works
Banding using EARLIER
Ranking using EARLIER

Calendars and dates

Creating a calendar
Date-based functions

Advanced date functions

Multiple relationships
Moving averages
Creating a periods table

Covered if time allows If time

Dynamic security

Creating a permissions table
Dynamic roles

Covered if time allows If time

Parent-child hierarchies

The PATH functions
Displaying different levels
Making the results neater

DAX queries

Evaulating data
Summarising data
Filtering data
Adding columns

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
572 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"I learnt a lot and the trainer was very patient and helpful. It was a very worthwhile course."

Jeff Maddocks (Emerson Industrial Automation)

"Great step-by-step course. Trainer lively and willing to go above and beyond. Dynamic, engaging. I feel this has been incredibly useful. Recommended by colleagues."

Samuel Lewis (Cafcass)

"The trainer is very friendly and helpful."

Wenlong Wang (Hometrack Data System )

"Large amount of useful content."

Morgan Howard (M2 Digital)

"Excellent manual, great venue, delivered at just the right level. Thanks for lunch."

Jill Eldon (Health and Social Care Information Centre)

There are lots more where these came from (or just refresh this page to change the quotes shown).

You should be familiar with Excel pivot tables. This course also requires a high degree of numeracy!

Other Power BI Tools training resources

Power BI exercises

View Power BI Desktop or PowerPivot exercises

Power BI videos

View PowerPivot videos

Power BI blogs

View Power BI - Excel or Power BI Desktop blogs

This page has 0 threads Add post