Browse 543 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:No classroom dates
  • 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).

"Good content taught well, engaging and surprisingly useful. Top teacher, friendly & made the courses as fun as possible. Thanks for the cake!"

Akaash Rajput (PricewaterhouseCoopers)

"Hands on course that will enable me to hit the ground running when I will need to use Power BI for analytics. Trainer is very knowledge and very easy to follow. The course covers a lot of topics and I reckon it is well structured. All in all, very satisfied with the Wise Owl offering!"

Carlo Pisoni (PricewaterhouseCoopers)

"Superb job. One of the best courses I've been on. Fantastic trainer - very knowledgeable, hugely personable and an excellent presenter. We had a lot to cover in the three days. Not once did I feel rushed, not once was the instruction anything other than clear, well explained and very well organised. Kudos too to the people who write your manuals - they are excellent - clear, concise and easy to absorb. This is my second Wise Owl course and I will sing your praises to anyone who cares to listen. What makes the difference? The human touch and the thought and care. You're dealing with a person, not an opaque and convolution online registration process. A great deal of effort has gone in to the content of the courses and their manuals and above all they're delivered by likeable, knowledgeable people who want you to learn."

Tony Smith (Newark and Sherwood District Council)

"A great trainer with a great attitude. He monitored the speed of the course and kept the info relevant and was able to demonstrate extremely in depth knowledge when needed. I am going back to my company with a glowing review and I am sure there will be more people following in my foot steps."

Mitchell Batten (Great Western Railway (GWR))

"Really good pace and coverage of topics. Very happy, thank you."

Marie Woltman (Devon County Council)

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

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 or DAX for 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