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 Overview

  • Training topicDifferences from PBI Desktop
  • Training topicWorkspaces
  • Training topicFavorites

Using Power BI Service

  • Training topicReports and dashboards
  • Training topicUsing tiles
  • Training topicPinning to dashboards
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 topicStatic report tooltips
  • Training topicDynamic report tooltips

Quick measures

  • Training topicRunning totals
  • Training topicAbsolute and relative totals
  • 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
  • Training topicInformation pop-ups

Report themes

  • Training topicGetting report themes
  • Training topicCreating basic report themes
  • Training topicVisual themes

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

"Great. Good pace."

Debra Sloan (Cheshire East Council)

"Really useful course and very well presented."

Mike Hardiman (Aster Group Ltd)

"Really worth while course. Very glad I did it. Brilliant trainer, would recommend to anyone. Very knowledgeable and enthusiastic. Great feedback on your website. Great location and course choice/content. Very good value for money."

Duncan Barber (DBS Datamarketing Ltd)

"A great mix of theory and practical. Helpful to have data stick as a take away for future reference, plus a detailed manual. The trainer was great - it was easy to ask for help to to go over points again - no fear of embarrassment! I needed to conquer my fear of LookUps and PivotTables - now I know they are not difficult at all."

Trish West (ATS Euromaster Ltd)

"Very clear, helpful trainer, good examples. Price was very good!"

Linda Fownes (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 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