Microsoft Office training -  DAX

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 and Analysis Services (tabular model).

Course details

  • Locations for DAX coursesLocations:Manchester, London
  • Next DAX course locationNext course:Tue 18 September 2018
  • DAX course timesTime:09.30-16.30

Course Contents

Ways to edit DAX

  • Training topicPower BI
  • Training topicPowerPivot
  • Training topicSSAS Tabular
  • Training topicDAX Studio

Data model basics

  • Training topicLinking to data
  • Training topicCreating a data model

Calculated columns

  • Training topicCreating calculated columns
  • Training topicIF and SWITCH
  • Training topicShowing RELATED data
  • Training topicDealing with blanks

Basic measures

  • Training topicCreating measures
  • Training topicUnderstanding filter context
  • Training topicUsing a measures table
  • Training topicAggregateX functions

Filtering

  • Training topicThe CALCULATE function
  • Training topicRemoving and replacing context
  • Training topicThe FILTER function
  • Training topicVALUES: editing filter context

Understanding EARLIER

  • Training topicHow it works
  • Training topicBanding using EARLIER
  • Training topicRanking using EARLIER

Variables

  • Training topicCreating variables
  • Training topicUsing for debugging

Calendars and dates

  • Training topicCreating a calendar
  • Training topicDate-based functions

Covered if time allows If time

Creating a periods table

  • Training topicCreating the table and measures
  • Training topicThe HASONEVALUE function

Advanced date functions

  • Training topicMultiple relationships
  • Training topicMoving averages

Dynamic titles

  • Training topicShowing filter choices
  • Training topicThe ISFILTERED function

Covered if time allows If time

Dynamic security

  • Training topicCreating a permissions table
  • Training topicDynamic roles

Covered if time allows If time

Parent-child hierarchies

  • Training topicThe PATH functions
  • Training topicDisplaying different levels
  • Training topicMaking the results neater

DAX queries

  • Training topicEvaulating data
  • Training topicSummarising data
  • Training topicFiltering data
  • Training topicAdding columns

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Love it!"

Barry Stanworth (9Brand Foods Limited)

"The course was exactly what I was looking for in order to complete a specific project that I am working on shortly. Many of the topics are relevant to what I had in mind for the project. The content of the course and duration were right for a basics to RB. The trainer, was excellent and I learned a lot from his teaching method."

Mark McArdle (BAE Systems)

"Good pace. Trainer very attentive, no-one was left behind."

David Byrne (Department for Education)

"The trainer was great. Everything was explained well and questions answered brilliantly."

Dan Hooper (The AA)

"Very clear and interesting training. Very enjoyable! Didn't want London and fewer candidate numbers appealed!"

Sue McGrath (SuperBreak)

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!

Scheduled DAX training dates

Here are the DAX courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Tue/Wed 18-19 September 2018 2 £795 Book places
Tue/Wed 16-17 October 2018 2 £950 Book places
Thu/Fri 25-26 October 2018 2 £950 Fully booked
Tue/Wed 20-21 November 2018 2 £795 Book places
Date(s) Venue
18/09
16/10
25/10
20/11

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Power BI training at your offices (we'll even provide and set up the computers).

Related Courses

Introduction to Power BI

Introduction

2 day course

PowerPivot / Excel Power BI

Introduction

2 day course

Advanced Power BI

Intermediate

2 day course

Other Power BI Tools training resources

Power BI exercises

Power BI exercises

View Power BI Desktop or PowerPivot exercises

Power BI videos

Power BI videos

View PowerPivot videos

Power BI skills assessment

Power BI skills assessment

View Power BI skills skills assessment tests

Power BI blogs

Power BI blogs

View Power BI - Excel or Power BI blogs

This page has 0 threads Add post