Power BI 1 Week Intensive Training Course

We now provide two versions of the Power BI 1 Week Intensive Training Course: one aimed at power users, the other at managers and administrators. Please click the tabs below to see the difference.

Power BI 1 Week Intensive Course
  • For power users
  • for managers & Admins

The Power BI 1 Week Intensive Training Course for Managers and Administrators is designed for users who are new to Power BI, but who intend to be closely involved in their organisation’s Power BI adoption strategy.

You should consider taking this course when your company has recently adopted, or are about to adopt Power BI; and you will be playing a pivotal administration role in ensuring that your organization derives the greatest possible benefit from self-service business intelligence.

We run this scheduled Power BI training course every month as a public, instructor-led online course. We can also deliver a private online version of this course for up to eight people, allowing your staff to take the training either from the office or at home.

The course consists of three components: Power BI Introduction, Power BI Adoption and Proof of Concept and Power BI Administration.

Power BI Training London

Course Outline

Power BI Introduction

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 in app workspaces; Assigning groups to app workspaces; Publishing apps; 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 Adoption and Proof of Concept

Using Microsoft’s Power BI Adoption Framework

Making the Most of the Adoption Framework, Accessing the Framework Documents

Preparing Data Sources

Handling SQL Server Data, Handling Excel Files, Handling Text Files, Creating a Data Catalog, Creating a Data Dictionary

Managing Installations

Power BI Desktop, Power BI Mobile Apps, On-premises Data Gateway, Excel Add-ins

Assigning Roles

Identifying Candidates, Individual and Shared Roles, Project Management Roles, Data Roles, Power User Roles, Users and Consumers, Admin Roles

Power BI Administration

Understanding Administration Roles, Administration Overview, Understanding tenant Settings, Assigning Licenses, Administration Tools

Designing a Power BI POC

Scoping the Project, Selecting Participants, Assigning Roles, Provisioning a Power BI Tenant, Workspace Structure and Design, Dataset Design and Creation, Creating Sample Reports, Creating Sample Dashboards, App Design and Publishing, Assigning Licenses to Participants, Going Live, Monitoring Adoption

Stretching your Budget

Making the most of the Free Trial, Involving Unlicensed Users


Power BI Administration

Overview

The Global admin role, The Power BI service admin role, Key aspects of Power BI administration

Power BI licensing

Power BI Free license, Power BI Pro license, Power BI Premium, Office 365 licensing, Automating license assignment

Securing Power BI

Azure AD Conditional Access policies, Restricting access based on network location, Restricting access based on device, Using multi-factor authentication, Tracking risky sign-ins

Export and Sharing Settings

Sharing content with external users, Publish to Web, Export Data, Export reports as PowerPoint presentation, Print dashboards and reports

Integration Settings

Integration Settings, Ask questions about data using Cortana, Use Analyze in Excel with on-premises datasets, Use ArcGIS Maps for Power BI, Use global search for Power BI

Custom Visual Settings

Enabling and disabling the use of custom visuals, Tenant Settings: R Visual Settings, Enabling and disabling the use of R visuals

Audit & Usage Settings

Overview of using audit logs, User role and license requirements, Granting access to non-admins, Activating the audit logs feature, Activities audited, Searching audit logs by user, Searching audit logs by date, Using PowerShell to search audit logs, Exporting the audit log, Creating Power BI reports from logs, Using the Power BI Usage Metric Solution Template

Other Settings

Using data classification for dashboards, Activating the Power BI Embedded API, Monitoring embed codes used for Publish to Web, Registering corporate custom visuals

Data Governance

Designing dataflows and entities, Import, DirectQuery and Composite modes, Centralized datasets, Template usage and storage, Row level security

Leveraging PowerShell

Installing the Power Bi modules, Exploring the syntax using help, Logging in and out of the Power BI service

Automating Reports and Dashboards

Listing reports and dashboards, Exporting reports, Copying reports, Creating reports and dashboards, Copying tiles

Automating Workspaces

Listing workspaces and their contents, Creating workspaces, Adding and removing users


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