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

"The trainer was fantastic and very accessible. (Recommendation came from Cambs Police.)"

Clare Hill (Hertfordshire Constabulary)

"Good environment and facilities. Love the Nespresso coffee and lunches. The trainer was really engaging and the database subjects made this much more interesting."

James Young (Ministry of Housing, Communities and Local Government)

"Manuals really clear and helpful. Very good all round."

Richard Moon (AQA Education Limited)

"The trainer was brilliant, a genuinely nice guy with a wealth of knowledge. Looking forward to my Advanced VBA course in the near future. The course is laid back, lets you wear your own 'out of office' clothing and the complementary lunches were lovely."

Tashan Jackson (Partners for Improvement in Islington Ltd)

"There was a lot to take in (especially in day 2) but the course materials are so extensive I feel confident I'll be able to find out how to do anything I might have forgotten."

Steve Pilkington (Department for Education)

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