Microsoft Office training - Introduction to Power BI Desktop

Power BI Tools Training

Introduction to Power BI Desktop (2 days)

£650 + VAT for most venues (£750 + VAT for London)

There are three parts to creating a Power BI Desktop report, all of which are covered by this two-day course. Firstly, you'll learn how to get data from all manner of different sources, using Query Editor to manipulate the results; secondly, you'll learn how to create, format and use visualisations (tables, charts, gauges, maps and many more); and thirdly, you'll learn how to create calculated columns and measures using basic DAX language. You'll also learn how to use Power BI Web, and get an overview of Power BI Mobile. If you're not sure whether you want to book on this course or on our two-day Excel Power BI tools course, have a look here.

Course details

Locations:Manchester, London
Next course:Tue 03 October 2017
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

Basic reports

Getting data
Basic visualisations
Shapes, text boxes and images

Data sources

SQL Server / databases
Excel / text files
Websites and web serivces

Query editor

Filtering rows
Manipulating columns
Working with data types

Covered if time allows If time

Advanced query editor

Grouping and pivoting
Creating new columns
Basic M formula language

Multiple tables

Relationships
Filter directions

Covered if time allows If time

Parameters

Creating parameters
Filtering by parameter

Filtering data

Slicers
Visualisation level filters

Drill-down

Interactions
"See records" feature
Hierarchies

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

Maps

Categorising data
Issues with maps

Calculated columns

Adding columns
IF and SWITCH
The RELATED function

Measures/DAX

How measures work/tuples
Adding measures
Basic DAX

Calendars

Creating calendars
Using multiple calendars
Working days

Date functions

Period to date
Previous periods
Other date functions
Semi-additive measures

Covered if time allows If time

Advanced measures

AggregateX functions
The CALCULATE function
The FILTER function
DAX variables

Covered if time allows If time

Roles and security

Creating roles
DAX restrictions

Publishing reports

Power BI accounts
Power BI files (PBIX)

Power BI Service Overview

Differences from PBI Desktop
Workspaces
Favorites

Using Power BI Service

Reports and dashboards
Using tiles
Pinning to dashboards

Overview of Excel tools

Power BI Publisher for Excel
Analyze for Excel

Covered if time allows If time

Overview of other tools

Power BI Mobile overview
Power BI Pro overview

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
492 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

"l thought the course was fantastic and really helpful and the training materials were of a really high standard. It is not often when going on a training course that you can work through the training and manual afterwards which is a credit to Wise Owl Training. I also wanted to thank your excellent trainer; his style of teaching was very good. He has a lot of patience with less experienced people like myself and was always willing to help us when we got stuck. I would definitely like to attend some other courses."

John Groves (Kinase Consulting Limited)

"Excellent reference material manuals. Informative website and competitive prices."

Sarah Cradick (Signature)

"Really good pacing and appreciated the chance to practice at regular intervals. The trainer made what seemed complex at the outset very approachable."

Chris Chandler (Trafford Housing Trust)

"Best course in a long time, particularly as it was right down to the daily needs (already used knowledge last night.) Very good and detailed course material."

Michael Gruetzner (Sherwood Compliance Services)

"Superb! Excellent content, good coverage, manuals are super, the web tutorials look great too! I will recommend."

Tracy Little (Department for Education)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Power BI Desktop is a standalone application, so there are no pre-requisites for attending this course.