Microsoft Power BI Training

Power BI Training: Introduction

This Microsoft Power BI training course aims to familiarize subscribers to Power BI Pro with the key features and operations of the Power BI service, as well as with the use of Power BI Desktop to prepare reports. Delegates will learn how to connect to local data sources and online services; customize and transform data sources to suit their own requirements; model data by creating relationships, calculated columns and measures; create reports using a wide variety of visualizations; publish reports to the Power BI service; distribute reports and dashboards both internally and to a wider audience; and schedule automatic refreshes of their datasets.

We run this scheduled Power BI training course at our Peterborough training centre every month. We can also deliver onsite Power BI training direct to your offices, anywhere in the UK.

Power BI Training

Power BI Training Course Outline

Getting started

The key components of Power BI; What is Power BI Desktop; The Power BI service; Power BI free vs Power BI Pro; Power BI vs Excel add-ins; Dashboards, reports and datasets

Connecting to software services

Understanding content packs for services; Google Analytics content pack; Salesforce content pack; Microsoft Dynamics CRM content pack

Getting data into Power BI

Connecting to data sources in the Power BI service; Connecting to data sources in Power BI Desktop; Importing excel workbooks; Importing Access databases; Connecting to SQL Server

Cleaning up and transforming data

Using the Query Editor; Creating a query; Understanding query steps; Automatically generated steps; Removing query steps; Modifying query steps; Renaming columns; Reordering and removing columns; Changing data types; The close & apply command

Data modelling

Working in data view; Working in relationship view; Auto-detection of table relationships; Creating table relationships manually; Setting cardinality; Cross filter direction

Using DAX

Creating Calculated columns; Creating measures; Understanding row context; Understanding filter context; The SUMX function; The CALCULATE function; The ALL function; The FILTER function; Using time intelligence functions

Creating reports

Working in report view; Creating tables and key metrics; Working with matrixes; Filtering data with slicers

Creating visualizations

Creating column and bar charts; Creating line and area charts; Creating scatter charts; Treemap visualizations; Using charts as slicers; Using maps with geographical data; Using custom visuals in your reports

Publishing content

Publishing Power BI Desktop reports; Printing and exporting dashboards and reports; Creating Groups in the Power BI service; Creating content Packs; Assigning groups to content packs; Sharing dashboards with your organization; Publishing reports to the web; Embedding a report in a web page

Creating Power BI Mobile Content

Optimising visuals for small viewports; Creating a phone version of a dashboard; Creating phone-optimised reports

Consuming and customizing content

Browsing group content; Using content packs; Creating read-only versions; Using Quick Insights in Power BI; Creating dashboards from your reports; Querying with natural language; Creating custom Q & A suggestions

Refreshing content

Setting up a personal gateway; Customizing dataset refresh settings; Scheduling a refresh frequency; Setting up enterprise gateways; Managing enterprise gateways; Adding and removing data sources, Creating live connections to data


Power BI Training 2018 – Introduction Schedule

Date Duration Course Title
08/01/2018 2 days Power BI Introduction
12/02/2018 2 days Power BI Introduction
12/03/2018 2 days Power BI Introduction
09/04/2018 2 days Power BI Introduction
07/05/2018 2 days Power BI Introduction
04/06/2018 2 days Power BI Introduction
02/07/2018 2 days Power BI Introduction
06/08/2018 2 days Power BI Introduction
03/09/2018 2 days Power BI Introduction
01/10/2018 2 days Power BI Introduction
05/11/2018 2 days Power BI Introduction
03/12/2018 2 days Power BI Introduction

Power BI Training Prices for UK Delivery

The fee for running in-house Power BI courses in Colchester is £595, per day.
The cost for running customized Power BI courses in Luton is £595, per day.
Our fee for delivering customized Power BI training in Tyneside is £550, per day.
The charge for running customized Power BI training in Liverpool is £595, per day.
Our price for delivering on-site Power BI courses in Medway Towns is £550, per day.
The fee for running customized Power BI training in Doncaster is £550, per day.
The fee for running customized Power BI training in Exeter is £550, per day.
Our charge for delivering on-site Power BI courses in Farnborough/Aldershot is £550, per day.
The charge for running customized Power BI training in Greater Manchester is £550, per day.
Our charge for delivering Microsoft Power BI courses in Chesterfield is £550, per day.
Our price for supplying on-site Power BI courses in Reading is £550, per day.
Our price for delivering on-site Power BI courses in Blackpool is £750, per day.
Our fee for delivering in-house Power BI courses in High Wycombe is £550, per day.
The charge for running Microsoft Power BI courses in Chelmsford is £725, per day.
The fee for running on-site Power BI training in Edinburgh is £550, per day.
Our price for delivering in-house Power BI courses in Oxford is £595, per day.
Our price for running on-site Power BI training in The West Midlands is £595, per day.
The fee for running on-site Power BI training in Telford is £595, per day.
The cost of supplying on-site Power BI courses in Accrington/Rossendale is £550, per day.
Our charge for supplying Microsoft Power BI courses in Sunderland is £550, per day.
Our price for supplying in-house Power BI courses in Derby is £595, per day.
Our price for delivering customized Power BI courses in Basingstoke is £550, per day.
Our price for delivering customized Power BI courses in Eastbourne is £550, per day.
Our fee for delivering on-site Power BI training in Northampton is £550, per day.
The fee for running customized Power BI training in Ireland is £750, per day.
The charge for running in-house Power BI courses in Preston is £595, per day.
Our price for running Microsoft Power BI courses in Sheffield is £595, per day.
Our price for running customized Power BI training in Plymouth is £595, per day.
Our price for supplying in-house Power BI courses in Slough is £550, per day.
Our charge for supplying on-site Power BI training in Newport is £550, per day.
The fee for running customized Power BI courses in Torquay is £595, per day.
Our price for delivering customized Power BI courses in Burnley is £595, per day.
Our fee for delivering customized Power BI courses in Ipswich is £725, per day.
The fee for running on-site Power BI training in West Yorkshire is £595, per day.
Our price for supplying Microsoft Power BI courses in Dundee is £550, per day.
Our fee for delivering customized Power BI courses in Cardiff is £550, per day.
Our fee for delivering Microsoft Power BI courses in Bristol is £550, per day.
The fee for running customized Power BI training in Norwich is £550, per day.
Our charge for supplying on-site Power BI courses in Birkenhead is £550, per day.
Our charge for delivering customized Power BI courses in Coventry is £550, per day.
Our fee for delivering on-site Power BI courses in Warrington is £595, per day.
Our price for delivering in-house Power BI courses in Mansfield is £550, per day.
The fee for running on-site Power BI courses in Greater Glasgow is £550, per day.
The charge for running customized Power BI courses in Lincoln is £595, per day.
Our charge for delivering customized Power BI training in Wigan is £550, per day.
The cost for running in-house Power BI courses in Poole is £550, per day.
The fee for running on-site Power BI courses in Worcester is £595, per day.
The charge for running customized Power BI courses in Stoke-on-Trent is £595, per day.
Our charge for supplying on-site Power BI courses in Maidstone is £550, per day.
Our price for running customized Power BI training in Nottingham is £595, per day.
Our price for supplying Microsoft Power BI courses in Basildon is £595, per day.
The cost for running customized Power BI courses in Hastings is £595, per day.
Our charge for delivering customized Power BI courses in Swindon is £595, per day.
Our price for delivering customized Power BI training in Brighton and Hove is £725, per day.
The cost of supplying Microsoft Power BI courses in Cheltenham is £595, per day.
Our price for running on-site Power BI courses in Teesside is £595, per day.
Our price for supplying customized Power BI training in Cambridge is £550, per day.
The charge for running customized Power BI courses in Thanet is £550, per day.
The cost of supplying on-site Power BI courses in Grimsby is £595, per day.
The cost of supplying on-site Power BI courses in Burton-upon-Trent is £550, per day.
Our price for supplying on-site Power BI courses in Greater London is £550, per day.
The cost of supplying customized Power BI courses in Crawley is £595, per day.
The fee for running in-house Power BI courses in York is £550, per day.
Our charge for supplying customized Power BI training in Leicester is £550, per day.
Our fee for delivering customized Power BI training in Southend-on-Sea is £550, per day.
The cost of supplying in-house Power BI courses in South Hampshire is £595, per day.
The cost for running customized Power BI training in Bedford is £595, per day.
Our fee for delivering Microsoft Power BI courses in Barnsley is £595, per day.
Our price for delivering in-house Power BI courses in Blackburn is £550, per day.
Our price for running Microsoft Power BI courses in Gloucester is £550, per day.
Our charge for supplying customized Power BI training in Bournemouth is £550, per day.
Our price for supplying customized Power BI training in Aberdeen is £550, per day.
The fee for running on-site Power BI courses in Peterborough is £550, per day.
Our price for running customized Power BI courses in Milton Keynes is £595, per day.
The cost for running customized Power BI courses in Kingston upon Hull is £750, per day.
Our price for running Microsoft Power BI courses in Swansea is £595, per day.
Our charge for supplying on-site Power BI training in Belfast is £595, per day.