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).

Course details

Locations:Manchester, London
Next course:Tue 18 September 2018
Time:09.30-16.30

SCHEDULED DATES 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
555 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

"The course is brilliant. I now feel, after a long time tinkering with SSRS by myself that I am now on the right track, simply because of this course. The trainer is great at explaining the complexity of it in simple terms. I would happily recommend this course! The online courseware is excellent and really helped me understand my requirements to get the most out of this course."

Adil Zeshan (James Brindley School)

"All really good thanks. Had good reviews on Google, so booked."

Michael Barlow (Garic Ltd)

"Hope all is well and you had a great weekend. I attended your SQL Report Writing class last week. Wanted to say thank you for teaching it in such a great, straight forward way. I have already written my first report (see attached) – geek fest! ? Thanks again, you are a fantastic trainer. Engaging, personable, and very knowledgeable. Awesome! "

Megan Walker (Bond International Software (UK) Ltd)

"Excellent. Very encouraging tutor, useful manuals, enjoyed the course. Contents excellent for level being taught."

Chas Mills (Guardian Industries UK Ltd)

"I thoroughly enjoyed the training provided. The trainer was very helpful and clear in her approach. "

Liz Clarke (Whitecroft Lighting Ltd.)

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 skills assessment

View Power BI Desktop skills assessment tests

Power BI blogs

View Power BI - Excel or Power BI Desktop blogs

This page has 0 threads Add post