COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Fast track Power BI/DAX

Classroom Training

3-day intensive Power BI/DAX training course

Available as classroom training course only

3 days

There is a LOT to learn in Power BI, which is why we've split our Power BI training into three two-day courses (an introduction to Power BI, showing how to write measures in DAX and showing some more advanced Power BI features).  However, we've had a few clients who want to accelerate this process, squeezing nearly 6 days of learning into an intensive three-day fast track course.  This isn't for everyone, which is why it's only available for single company courses.

Our fast-track courses are only available as tailored training, either at your premises or at either our London or Manchester venues (here's why).

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

Covered if time allows If time

Overview of maps

  • The types of map
  • Geo-location
  • Introduction to ArcGIS

Calculated columns

  • Adding columns
  • IF and SWITCH
  • The RELATED function

Publishing reports

  • Power BI accounts
  • Power BI files (PBIX)

Power BI Service

  • Publishing
  • Dashboards and tiles
  • Sharing reports

App workspaces

  • Creating app workspaces
  • Publishing apps
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

Covered if time allows If time

Understanding EARLIER

  • How it works
  • Banding using EARLIER
  • Ranking using EARLIER

Variables

  • Creating variables
  • Using for debugging

Calendars and dates

  • Creating a calendar
  • Date-based functions

Advanced date functions

  • Multiple relationships
  • Moving averages

Covered if time allows If time

Parent-child hierarchies

  • The PATH functions
  • Displaying different levels
  • Making the results neater
From our ADVANCED POWER BI course

Tooltips

  • Tooltip backgrounds
  • Dynamic report tooltips
  • Visual header tooltips

Quick measures

  • Showing selected items
  • Filtering columns

Bookmarks

  • Creating bookmarks
  • Data and display properties
  • Spotlighting and hiding visuals

Covered if time allows If time

Bookmark case studies

  • Dynamic chart axes
  • Dynamic page titles

Report themes

  • Applying themes
  • Creating custom themes
  • A suggested standard theme

Power BI Templates

  • Creating templates
  • Including themes
  • Using parameters

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

"Great to get the manuals to take away. Easy to follow and understand."

Becky Owen (Finning (UK) Ltd)

"I really enjoyed the course and learnt a lot. Thanks."

Kathryn Fouracre (Home Retail Group PLC)

"Excellent course. Pitched at the perfect level. Trainer very knowledgeable and engaging and kept the course at a really good pace."

Jordan Thorp (Department of Health)

"Trainer was excellent. Content was excellent. The flow of training was excellent."

Ian Hollingsworth (First Ark)

"Very interesting and relevant course. Lots of useful information, now need to practice. Recommendation came from a colleague."

Joanne Hobbs (Cobalt Housing)

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

This page has 0 threads Add post