WiseOwl Training - Established 1992
To enable social distancing we've completely remodelled our classroom training, launched a full range of live online courses and now provide online training-cum-consultancy.
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.32 out of 10, based on 8628 reviews
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

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?

View full list of benefits

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 knowledgeable instructor, very clear teaching. Good mixture of tutorials and practice. Lots of progress made. Lots of supporting materials. Two great lunches. Flexible based on customer needs."

Matt Jenkins (Wiggin LLP)

"Surprisingly fun and interesting. Very well done and organised. The trainer was very enthusiastic and very good at answering unique questions with on the spot examples."

Thomas Felton (PricewaterhouseCoopers Services Ltd.)

"The trainer was very knowledgeable and willing to answer all questions."

Rohan Smith (Derby and Burton Hospitals NHS FT)

"Enjoyed the pace, content, manuals & exercises. Great!"

Deji Benson (Amigo Loans)

"Great step-by-step course. Trainer lively and willing to go above and beyond. Dynamic, engaging. I feel this has been incredibly useful. Recommended by colleagues."

Clara Lewis (Cafcass)

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