COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Introduction to Power BI

Classroom Training

Introduction to Power BI

Classroom training course - online version also available

£695 + VAT for most venues (£795 + VAT for London)

2 days

Things that you'll learn on this two-day course include:

  • how to load data from all manner of different sources, and how to build a data model;
  • how to use Query Editor to transform data as you load it;
  • how to create, format and use visualisations (tables, charts, gauges, maps and many more);
  • how to create calculated columns using the basic DAX language; and
  • how to work with calendars in Power BI.

You'll also learn how to publish reports to Power BI Service. 

Course details

  • Locations for Introduction to Power BI coursesPossible locations:London, Manchester, Online
  • Next Introduction to Power BI course locationNext classroom course:Mon 25 January 2021
  • Introduction to Power BI course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

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

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

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

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

"It was a very good course, pitched at the right level for me. Comprehensive, good knowledge by the trainer."

Davine Cooke (Manchester Metropolitan University)

"Great course, well structured - excellent trainer! (Been on Power BI course previously.)"

Tony Pole (UP Global Sourcing (UK) Ltd)

"3 excellent courses and the trainer helped me so much."

Edward Wenham (Crown Commercial Service)

"Great course, well delivered, spot on, gave me the skills required to progress, Great trainer. The course handbook is a great tool to refer to when using SQL daily. Many thanks"

Andrew Riley (Cross Keys Homes)

"Great. A fantastic experience. Other colleagues have been on training previously."

Simon Lyons (The Original Factory Shop)

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

Scheduled Introduction to Power BI training dates

Here are the classroom Introduction to Power BI courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Mon/Tue 25-26 January 2021 2 £695 Book places
Thu/Fri 11-12 February 2021 2 £795 Book places
Thu/Fri 25-26 February 2021 2 £695 Book places
Mon/Tue 29-30 March 2021 2 £695 Book places
Thu/Fri 08-09 April 2021 2 £795 Book places
Thu/Fri 20-21 May 2021 2 £695 Book places
Mon/Tue 28-29 June 2021 2 £695 Book places
Thu/Fri 01-02 July 2021 2 £795 Book places
Thu/Fri 12-13 August 2021 2 £695 Book places
Date(s) Venue
25/01
11/02
25/02
29/03
08/04
20/05
28/06
01/07
12/08

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Power BI training at your offices (we'll even provide and set up the computers).

Related Courses

Advanced Power BI

Intermediate

2 day course

PowerPivot / Excel Power BI

Introduction

2 day course

DAX

Intermediate

2 day course

Other Power BI training resources

Power BI exercises

Power BI exercises

View Power BI Desktop, DAX or Power Apps exercises

Power BI videos

Power BI videos

View Power BI videos

Power BI skills assessment

Power BI skills assessment

View Power BI skills skills assessment tests

Power BI blogs

Power BI blogs

View Power BI blogs

This page has 0 threads Add post