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

Data models

  • 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

Calendars and dates

  • Training topicCreating a calendar
  • Training topicDate-based functions

Advanced date functions

  • Training topicMultiple relationships
  • Training topicMoving averages
  • Training topicCreating a periods table

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

"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!

Related Courses

Introduction to Power BI Desktop

Introduction

2 day course

PowerPivot / Excel Power BI

Introduction

2 day course

Advanced Power BI Desktop

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 blogs

Power BI blogs

View Power BI - Excel or Power BI Desktop blogs

This page has 0 threads Add post