Microsoft Office training -  Introduction to Power BI

Power BI Training

Introduction to Power BI Training Course

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

2 days

There are three parts to creating a Power BI 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, how to use Query Editor to manipulate the results and how to build a data model; 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  using basic DAX language.  You'll also learn how to publish reports to Power BI Service.  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 for Introduction to Power BI coursesLocations:London, Manchester
  • Next Introduction to Power BI course locationNext course:Mon 23 September 2019
  • Introduction to Power BI course timesTime:09.30-16.30

Course Contents

The content of this course are as follows:

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

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

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

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Trainer was friendly, knowledgeable and helpful. Liked the way we were asked questions (as a group) to get us thinking."

Alex Wallace (Manchester Metropolitan University)

"Fantastic course for beginners, delivered excellently by the trainer. The content of the course was perfect, covering everything needed plus giving more information in the course booklet. The exercises were well planned and very useful. Will recommend to everyone in the NHS!"

Craig Benson (NHS Digital)

"A brilliant course & engaging trainer."

David Clarke (Great Western Railway (GWR))

"The trainer was very good and friendly. Very informative. Relaxed and friendly, good touch on going out to a restaurant for lunch."

David Barnes (Trafford Housing Trust)

"(Intro Power BI) Excellent pace for 2 days. Plenty of interaction and humour. Great lunch breaks. (DAX) Excellent course. Very well delivered on a "tricky" topic which could have sent me slightly mad. Great pace of delivery. This is the first time I felt I could do the same course again! (Advanced Power BI) Excellent delivery of a new course. Quick measures were very useful after the DAX course (a good compliment.)"

John Pelan (Coloplast Ltd)

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 Introduction to Power BI courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Mon/Tue 23-24 September 2019 2 £695 Book places
Thu/Fri 10-11 October 2019 2 £795 Book places
Thu/Fri 14-15 November 2019 2 £695 Book places
Tue/Wed 03-04 December 2019 2 £795 Book places
Thu/Fri 12-13 December 2019 2 £695 Book places
Date(s) Venue
23/09
10/10
14/11
03/12
12/12

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 Tools training resources

Power BI exercises

Power BI exercises

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