WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 482 reviews 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:09:30-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 visuals
  • Shapes, text boxes and images

Data sources

  • SQL Server / databases
  • Excel / CSV files
  • Websites

Working with visuals

  • The formatting pane
  • Conditional formatting
  • Visual interactions

Charts

  • Creating charts
  • Bubble and other charts
  • Grouping data
  • Small multiples

Matrices

  • Row and column headers
  • Drill-down

Dashboard visuals

  • Gauges
  • Cards
  • KPIs

Query editor

  • Filtering rows
  • Manipulating columns
  • Working with data types
  • Creating new columns

Creating data models

  • Relationships
  • Hiding fields and tables
  • Renaming fields/tables

Filtering data

  • Slicers
  • Using the filter pane

Drill-through

  • Adding drillthrough filters
  • Creating back buttons
  • Button drill-through

Basic publishing

  • Power BI Service
  • Workspaces
  • Dashboards and tiles
  • Lineage view
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).

"Very informative in a simple manner. Good pace, excellent trainer, very friendly & created a brilliant atmosphere."

Pam Politis (Hyde Central Services Ltd)

"Good friendly energetic trainer. Good flow of content kept interest."

Robert Blincoe (Department for Levelling Up, Housing and Communities (DLUHC, ex MHCLG))

"The most useful training course I have been on."

Andrew Jordan (Government Internal Audit Agency (GIAA))

"The trainer was very helpful, friendly and open to questions, which made the sessions a lot more enjoyable and engaging. The pace of the sessions was just right (not too fast but not too slow) and the trainer being able to view our remote desktops was a very useful feature, as it meant he could help us over any stumbling blocks. We covered an impressive range of content, much of which should be useful for my work. I also appreciated the care taken in ensuring the course ran smoothly, i.e. the pre-course checks and the provision of accompanying materials well in advance of the sessions. I had seen examples of what others have done with Power BI and wished to be able to produce similar myself."

Chris BurridgeBarney (Devon County Council)

"Good pace and insight."

Richard Finn (Edge Hill University)

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 or DAX 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, Power Apps or Power Automate blogs

This page has 0 threads Add post