Browse 537 attributed reviews, viewable separately for our classroom and online training
Classroom training -  Fast track Power BI and DAX

Classroom Training

3-day intensive DAX and Power BI course

Classroom training course - online version also available

3 days

Our two-day DAX course assumes that you're already familiar with using Power BI, but what if this isn't the case?  Normally we'd advise you to book onto our two-day Introduction to Power BI course first, but we recognise that there are a select band of people who have the ability to cover three days of intensive training without being fazed (and who would prefer to minimise the amount of time spent away from their desk), and so we've created this three-day fast-track course to give a general introduction to Power BI and a full grounding in DAX in three busy, busy days.

Course details

  • Locations for Fast track Power BI and DAX coursesPossible locations:London, Manchester, Online
  • Next Fast track Power BI and DAX course locationNext classroom course:Wed 13 October 2021
  • Fast track Power BI and DAX course timesTime:10.00-16.30

Course Contents

This fast-track course combines topics from the following other Wise Owl courses:

From our INTRODUCTION TO POWER BI course

Basic reports

  • Getting data
  • Basic visualisations
  • Shapes, text boxes and images

Data sources

  • SQL Server / databases
  • Excel / text files
  • Websites and web services

Formatting visualisations

  • The formatting panes
  • Conditional formatting

Charts

  • Working with charts
  • Specific chart type issues
  • Grouping and binning

Other types of visualisation

  • Working with matrices
  • Working with cards

Dashboard visualisations

  • Gauges
  • Single-number visualisations
  • KPIs

Query editor

  • Filtering rows
  • Manipulating columns
  • Working with data types

More on query editor

  • Creating new columns
  • Introducing the M language

Multiple tables

  • Relationships
  • Filter directions

Filtering data

  • Slicers
  • Visualisation level filters

Drill-down

  • Interactions
  • "See records" feature

Drill-through filtering

  • Adding drillthrough filters
  • Back buttons

Publishing reports

  • Power BI accounts
  • Power BI files (PBIX)

Power BI Service

  • Publishing
  • Dashboards and tiles
  • Sharing reports
From our DAX course

Ways to edit DAX

  • Power BI
  • PowerPivot
  • SSAS Tabular
  • DAX Studio

Data model basics

  • 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

The CALCULATE function

  • Filter context revisited
  • Removing and replacing context
  • Context transition

Covered if time allows If time

The VALUES function

  • The HASONEVALUE function
  • Listing single values
  • Parameter tables

Covered if time allows If time

Dynamic measures

  • The ISFILTERED function
  • The ALLSELECTED FUNCTION
  • Dynamic titles

Covered if time allows If time

The FILTER function

  • Row context
  • Iterator functions
  • Applying criteria

Variables

  • Creating variables
  • Using for debugging

Calendars and dates

  • Creating a calendar
  • Date-based functions

Advanced date functions

  • Multiple relationships
  • Moving averages

You'll get the most out of this course if you've already dabbled with Power BI, although no experience is essential.  The course has a very ambitious timetable, and obviously our ability to cover all of the syllabus will depend on the ability of those attending!

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"(Intro Power BI) The trainer's pace was perfect for course. He understood the level at which candidates were at and paced the course accordingly. (Adv Power BI) Excellent course! A lot to take in but the supporting info is superb."

Leo Skelly (Prima Group)

"Very knowledgeable trainer, very well prepared, great training session, informal and friendly atmosphere."

Stephen Catlow (LifeArc)

"Great content. Great trainer. Thoroughly enjoyed how trainer engaged with us. Exercises helped cement course knowledge."

Hazem Hawwash (RPC Group plc)

"Trainer was very engaging. Content was well thought out and relative. Good to keep the material to look at afterwards."

Ian Wilson (NHS Pension Scheme)

"Excellent course and trainer. It's all good."

Antony Bateman (London Borough of Newham)

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

Scheduled Fast track Power BI and DAX training dates

Here are the classroom Fast track Power BI and DAX courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Wed/Fri 13-15 October 2021 3 £1,095 Book places
Mon/Wed 06-08 December 2021 3 £1,095 Book places
Date(s) Venue
13/10
06/12

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

DAX

Intermediate

2 day course

Advanced Power BI

Advanced

2 day course

Other Power BI training resources

Power BI exercises

Power BI exercises

We have lots of Power BI exercises on our website.

View Power BI Desktop, DAX or Power Apps exercises

Power BI videos

Power BI videos

Have a look at the videos we've published showing how to use Power BI.

View Power BI videos

Power BI skills assessment

Power BI skills assessment

Take our test to see how good your Power BI skills are.

View Power BI skills skills assessment tests

Power BI blogs

Power BI blogs

Have a look at some of the Power BI blogs that we've published on our site.

View Power BI or Power Apps blogs

This page has 0 threads Add post