WiseOwl Training - Established 1992
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.32 out of 10, based on 8959 reviews
Microsoft Office training - Fast track Power BI/DAX

Power BI Training

3-day intensive Power BI/DAX training course

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

  • Training topicGetting data
  • Training topicBasic visualisations
  • Training topicShapes, text boxes and images

Data sources

  • Training topicSQL Server / databases
  • Training topicExcel / text files
  • Training topicWebsites and web services

Formatting visualisations

  • Training topicThe formatting panes
  • Training topicConditional formatting

Charts

  • Training topicWorking with charts
  • Training topicSpecific chart type issues
  • Training topicGrouping and binning

Other types of visualisation

  • Training topicWorking with matrices
  • Training topicWorking with cards

Dashboard visualisations

  • Training topicGauges
  • Training topicSingle-number visualisations
  • Training topicKPIs

Query editor

  • Training topicFiltering rows
  • Training topicManipulating columns
  • Training topicWorking with data types

More on query editor

  • Training topicCreating new columns
  • Training topicIntroducing the M language

Multiple tables

  • Training topicRelationships
  • Training topicFilter directions

Filtering data

  • Training topicSlicers
  • Training topicVisualisation level filters

Drill-down

  • Training topicInteractions
  • Training topic"See records" feature

Drill-through filtering

  • Training topicAdding drillthrough filters
  • Training topicBack buttons

Covered if time allows If time

Overview of maps

  • Training topicThe types of map
  • Training topicGeo-location
  • Training topicIntroduction to ArcGIS

Calculated columns

  • Training topicAdding columns
  • Training topicIF and SWITCH
  • Training topicThe RELATED function

Publishing reports

  • Training topicPower BI accounts
  • Training topicPower BI files (PBIX)

Power BI Service

  • Training topicPublishing
  • Training topicDashboards and tiles
  • Training topicSharing reports

App workspaces

  • Training topicCreating app workspaces
  • Training topicPublishing apps
From our DAX course

Ways to edit DAX

  • Training topicPower BI
  • Training topicPowerPivot
  • Training topicSSAS Tabular
  • Training topicDAX Studio

Data model basics

  • Training topicLinking to data
  • Training topicCreating a data model

Calculated columns

  • Training topicCreating calculated columns
  • Training topicIF and SWITCH
  • Training topicShowing RELATED data
  • Training topicDealing with blanks

Basic measures

  • Training topicCreating measures
  • Training topicUnderstanding filter context
  • Training topicUsing a measures table
  • Training topicAggregateX functions

The CALCULATE function

  • Training topicFilter context revisited
  • Training topicRemoving and replacing context
  • Training topicContext transition

Covered if time allows If time

The VALUES function

  • Training topicThe HASONEVALUE function
  • Training topicListing single values
  • Training topicParameter tables

Covered if time allows If time

Dynamic measures

  • Training topicThe ISFILTERED function
  • Training topicThe ALLSELECTED FUNCTION
  • Training topicDynamic titles

Covered if time allows If time

The FILTER function

  • Training topicRow context
  • Training topicIterator functions
  • Training topicApplying criteria

Covered if time allows If time

Understanding EARLIER

  • Training topicHow it works
  • Training topicBanding using EARLIER
  • Training topicRanking using EARLIER

Variables

  • Training topicCreating variables
  • Training topicUsing for debugging

Calendars and dates

  • Training topicCreating a calendar
  • Training topicDate-based functions

Advanced date functions

  • Training topicMultiple relationships
  • Training topicMoving averages

Covered if time allows If time

Parent-child hierarchies

  • Training topicThe PATH functions
  • Training topicDisplaying different levels
  • Training topicMaking the results neater
From our ADVANCED POWER BI course

Tooltips

  • Training topicTooltip backgrounds
  • Training topicDynamic report tooltips
  • Training topicVisual header tooltips

Quick measures

  • Training topicShowing selected items
  • Training topicFiltering columns

Bookmarks

  • Training topicCreating bookmarks
  • Training topicData and display properties
  • Training topicSpotlighting and hiding visuals

Covered if time allows If time

Bookmark case studies

  • Training topicDynamic chart axes
  • Training topicDynamic page titles

Report themes

  • Training topicApplying themes
  • Training topicCreating custom themes
  • Training topicA suggested standard theme

Power BI Templates

  • Training topicCreating templates
  • Training topicIncluding themes
  • Training topicUsing 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?

View full list of benefits View full list of benefits

Sample customer feedback

"The trainer was great; really knowledgeable, enthusiastic and explained everything I asked him to. Colleagues recommended Wise Owl courses..... I can see why."

Lyndsey Bell (Greater Manchester Fire & Rescue Service)

"Informative course, was aimed just right for me, very valuable."

Louise Cox (Devon County Council)

"A very good introduction to a very powerful analytical tool! I chose the course on the basis of good feedback from colleagues."

Ewan Gadd (Department for Education and Skills)

"Outstanding teaching practitioner. Achieved a perfect balance of instruction and independent work (with support where needed). The trainer's self-depreciation and sense of humour made it much easier to ask for help and communicate our problems. Manuals and workbook are very good."

Pri Balachandran (IBM Business Consulting Services)

"Excellent communication. Recommended by colleague."

Will Ridge (Leeds City 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 Tools training resources

Power BI exercises

Power BI exercises

We have lots of Power BI exercises on our website.

View Power BI Desktop 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