Power BI Intermediate Training Course - UK Wide

Introduction | On-site Courses | Virtual Courses | Cost | Course Outline | Related Courses | Locations

Your learning needs are at the ❤ heart of what we do.

Power BI Level 2 Course Overview

Our two-day Power BI intermediate course takes an in-depth first look at Microsoft's suite of business analytics tools and your students will learn how to quickly transform business data into rich and insightful visualisations.

During this Power BI course you will cover beginners to intermediate topics including:

1. Some of the essential core concepts and practicalities for working with Power BI.
   
   
2. Learn how to work with Power BI datasets.
   
   
3. Learn some fundamental DAX formula language measures.
   
   
4. Get started with producing reports and creating visualisations.
   
   
5. Get started with Power BI Dashboards and Workspaces including understanding permissions and roles.
   
   
6. And, even get to try out some Q&A natural language queries.

The Microsoft Power BI Intermediate training course is a two-day, instructor-led event which will be conducted either on-site at your premises (within mainland UK) or as a live virtual classroom event via MS Teams. We will provide all courseware and reference materials electronically to use for reference.

Email us or call 0844 493 3699 to find out more about booking Power BI training for your team.

This Power BI course also forms part of the Microsoft 365 Master Class course.

Power BI Intermediate Training Course Prerequisites

Delegates should already have access to the Desktop version of Power BI in order to attend this course. The course takes students through both beginners and intermediate knowledge with Power BI and no previous knowledge of the software is required. However, before attending the course, delegates will need to have a basic understanding of what Power BI is and does and why it is of benefit to them. A good grasp of Microsoft Excel or similar would be advantageous (but not essential) as would some understanding of the concepts of database and data sources.

On-site Power BI Intermediate Training UK

These are corporate in-house training courses conducted at your workplace for small groups and are exceptional value and very popular. You will usually need to book at least one month in advance and the maximum number of learners is eight per course.

Our 'face-to-face' closed courses for Power BI are delivered as private courses for your delegates offering more flexibility than off-the-shelf public courses and topics taught can often be tailored to match your learning needs. One of our trainers will discuss your training requirements with you prior to the course.

Our trainers can attend anywhere in mainland UK (for overseas requirements, please enquire). On rare ocassions travel supplements may apply for Power BI training in Central London to cover additional expenses such as congestion charges, but we will endeavour to waive these when possible.

With our on-site Microsoft Power Bi courses our regional trainers come to your workplace throughout mainland UK, bringing the training to you regardless of whether you are in a major city such as London, Manchester, Birmingham or Leeds, or anywhere else. This offers a really cost-effective way to train small groups and entire departments in the comfort of familiar surroundings from the Capital City of London to The Cotswolds, from Hampshire to Northamptonshire, West Midlands to West Yorkshire, Sussex to South Yorkshire, Norfolk to Northumberland, Lancashire to Lincolnshire, Cambridgeshire to Gloucestershire, Bristol to Berkshire, Essex to the East Riding and everywhere inbetween.

Live Virtual Classroom Power BI Intermediate Courses, United Kingdom and Beyond

If you have a group of staff that you would prefer to be tutored remotely rather than having a trainer come out to you these small-group Power BI courses are also available Online as live virtual, interactive training sessions from the comfort of your own office or workplace. These live, instructor-led virtual courses are taught via Microsoft Teams.

Why choose virtual learning? As we are all becoming more used to Online learning and live virtual meetings it has become apparent that the virtual classroom method of delivery has many advantages over traditional face-to-face learning venues.

If you are looking for local training near you, then you can't get any closer to your doorstep than you can with virtual learning.

For live virtual Power BI training the maximum number of learners is eight per course and you can benefit from full and immersive interaction with your trainer just as if they were in the classroom with you, with engaging hands-on training via advanced live video conferencing that is further enhanced by features such as live chat, private chat, and sharing screens and documents.

You can find out more about live virtual classroom Power BI training delivered across Microsoft Teams video conferencing here: Learn More About Virtual Training with MS Teams.

Two Day Microsoft Power BI Intermediate Training Course Cost

Our Intermediate course is charged at £1,600.00 plus VAT and is available at this price for anywhere between one and six delegates. There is also a charge of £125.00 per day to cover the instructor's accommodation and travel costs to anywhere within the UK mainland (for offshore locations additional charges apply). If you have additional delegates you can add them for £50.00 plus VAT per person per day up to a maximum of 8 in total.

Please note that for tailored Power BI training courses, we can only provide you with a quote for training and courseware once we have evaluated your requirements.

Also see our three-day Power BI Desktop training course.

We really ❤ love helping UK organisations to master Power BI. Our only question is: Will it be yours?

Commercial and Corporate Power BI Intermediate Courses for the Public and Private Sectors

How Many People Should Attend Our Private Power BI Courses?

Whilst the number of people who attend our private Power BI courses is essentially up to you and dependant upon the number of learners you have who need to receive the training, we encourage all of our clients to keep your class sizes small where possible and recommend a maximum of eight learners for technical courses such as Power BI. This provides a more personable and effective learning experience for you and allows the trainer to give more individual attention to each and every student.

What is the Teaching Method for Our Power BI Courses?

The teaching method for our private Power BI courses is Instructor-led training (ILT), which means that our courses are engaging, immersive, hands-on and interactive, and thereby facilitate more effective learning and information retention. With this participatory learning method your staff will retain information better, whether they are studying Power BI subjects in-person or via live virtual classroom. And, whilst we are happy to provide lectures, demonstrations and show-and-tells for larger groups (plus drop-in surgeries for ad hoc technical advice and explanation), the instructor-led training approach is by far the most reliable teaching methodology to bring your Power BI know-how to life in a small-class-size setting.

How Long are our Power BI Courses?

Usual teaching hours for our Power BI courses are 9.30AM to 4.30PM with an hour for lunch and two short breaks morning and afternoon. This timetable is fairly standard across UK training providers and gives six hours of hands-on Power BI learning, which is an optimal day's training when it comes to comfortably absorbing knowledge, undertaking practice exercises and retaining information.

If you need an earlier or later start time for your course please let us know and we will do our best to accommodate you.

Courses are delivered week days, Monday to Friday during normal business hours.

More About Our Power BI Training Delivery Method for Closed Courses for Businesses

• Step-by-Step Courses: Instructor-led Power BI training provided in-person with step-by-step demonstrations, lessons and hands-on exercises.
  
  
• Q&A courses: Dynamic and interactive Power BI courses with plenty of time for questions and answers.
  
  
• Flexible Courses: Professional tuition that's tailored to match your team's present knowledge level and learning needs, and covering the Power BI functions, features and techniques that your trainee staff, co-workers or employees need the most.
  
  
• Small Class Sizes: Private, Power BI training for small group sizes with a maximum of 8 learners on any course.
  
  
• Scalable Courses: Can be run as a single course, tutorial or workshop; Or as a training rollout bringing whole teams, departments and organisations up to the benchmark level of Power BI knowledge and confidence that you require.

Microsoft Power BI Intermediate Training Course Outline

• Lesson 1: Power BI Introduction
  1. Power BI Concepts and Overview
  2. What are the Power BI App and the Power BI Desktop versions?
  3. Getting Familiar with the Power BI Interface
  4. Introduction to Basic Data Models
  5. Introduction to Basic Reporting
  6. Publishing
     
     
• Lesson 2: Working with Power BI Datasets
  1. Linking versus Uploading and when to use
  2. Dataset Navigation
  3. The Query Editor
     
     
• Lesson 3: Data Analysis Expression (DAX Measures)
  1. DAX Formula Language Overview (syntax, parameters and return values)
  2. DAX data types and operators
  3. Essential DAX functions
  4. Referencing other tables in DAX
  5. Working with the CALCULATE function
  6. Working with the EARLIER and EARLIEST functions
     
     
• Lesson 4: Reporting and Visualisation in Power BI
  1. Filtering, Sorting and Slicers
  2. Data Visualisation Types and Options
  3. Drill Through for Field Hierarchies
  4. Formatting your Visuals
  5. Working with Conditional Formatting
     
     
• Lesson 5: Power BI Dashboards
  1. What are Power BI Dashboards?
  2. What are Power BI Workspaces?
  3. What are Data Relationships?
  4. Q&A natural language queries
     
     
• Lesson 6: Power BI Workspaces
  1. Understanding Workspaces and Collaboration
  2. Creating Power BI Workspaces
  3. Setting Up Permissions and Roles for Workspace Collaboration
     
     

Other Power Platform Courses

Power Platform Master Class course

course duration - five days

Microsoft Power Automate Introduction

course duration - two days

Microsoft Power Automate Advanced

course duration - two days

Microsoft Powerapps Introduction

course duration - two days

Canvas Apps for Powerapps Training

course duration - three days

Microsoft Power BI Online Training

course duration - one day

Microsoft Power BI Desktop Training

course duration - three days

Power BI Beginners Training

course duration - one day

Power BI Intermediate Training

course duration - two days

Power BI Advanced Training

course duration - three days

Power BI Masterclass

course duration - four days

Power Apps and Power Automate Combined Training

course duration - four days

Microsoft Dataverse Beginners

course duration - three days

Back to top

Power BI Training Throughout the United Kingdom by Region and County

We have mobile trainers that can visit your company in any of the following places. These are specialist, versatile educators used to delivering flexible learning programmes in a closed course environment.

Power BI Courses North West of England Region

Power BI Courses Lancashire, Greater Manchester and Merseyside: Bolton, Lancaster, Liverpool, Manchester, Preston, Warrington, Altrincham, Barrow-in-Furness, Blackburn, Oldham

Power BI Courses Cheshire and Wirral: Birkenhead, Chester, Stockport, Ellesmere Port, Knutsford, Wallasey, Runcorn, Macclesfield, Crewe

Power BI Courses North East of England Region

Power BI Courses Northumberland and Tyneside: Alnwick, Newcastle-upon-Tyne, Morpeth, Hexham, Berwick-upon-Tweed

Power BI Courses County Durham: Durham, Sunderland, Stockton-on-Tees, Darlington, Gateshead, Washington, Hartlepool

Power BI Courses Yorkshire and the Humber Region

Power BI Courses West Yorkshire: Leeds, Bradford, Halifax, Huddersfield, Brighouse, Wakefield, Shipley, Dewsbury, Bingley

Power BI Courses North Yorkshire: York, Harrogate, Scarborough, Whitby, Northallerton, Middlesbrough

Power BI Courses South Yorkshire: Sheffield, Barnsley, Doncaster, Rotherham, Worksop

Power BI Courses Humberside / East Riding of Yorkshire: Kingston-upon-Hull, Bridlington, Cleethorpes, Scunthorpe

Power BI Courses East Midlands Region

Power BI Courses Northamptonshire: Northampton, Corby, Kettering, Wellingborough

Power BI Courses Lincolnshire: Lincoln, Market Rasen, Grantham, Sleaford, Boston, Grimsby

Power BI Courses Nottinghamshire: Nottingham, Mansfield, Worksop, Newark-on-Trent, Retford, Southwell, Long Eaton, Alfreton

Power BI Courses Derbyshire: Derby, Chesterfield, Ilkeston, Swadlincote, Buxton, Matlock, Ashbourne

Power BI Courses Leicestershire: Leicester, Loughborough, Hinckley, Melton Mowbray, Coalville, Lutterworth

Power BI Courses West Midlands Region

Power BI Courses West Midlands county & Warwickshire: Birmingham, Coventry, Nuneaton, Rugby, Solihull, Stratford-upon-Avon, Warwick, Wolverhampton, Walsall

Power BI Courses Staffordshire: Cannock, Lichfield, Stafford, Stoke-on-Trent

Power BI Courses Worcestershire: Dudley, Evesham, Kidderminster, Stourbridge, Halesowen, Malvern, Worcester

Power BI Courses East of England Region

Power BI Courses Norfolk: Norwich, Great Yarmouth, King's Lynn, Dereham, Cromer, Hunstanton

Power BI Courses Suffolk: Ipswich, Bury St. Edmunds, Lowestoft, Felixstowe, Sudbury, Haverhill, Bungay

Power BI Courses Essex: Chelmsford, Basildon, Romford, Southend, Colchester, Harlow, Brentwood, West Ham

Power BI Courses Cambridgeshire: Cambridge, Peterborough, Wisbech, Ely, March, Whittlesey, Chatteris, Linton

Power BI Courses Hertfordshire: Hertford, Watford, St. Albans, Hemel Hempstead, Stevenage, Hatfield

Power BI Courses Bedfordshire: Bedford, Luton, Dunstable, Leighton Buzzard, Biggleswade, Sandy

Power BI Courses Greater London Region

Power BI Courses London Central: London, Camden, Hackney, Hammersmith, Haringey, Islington, Kensington, Chelsea, Lambeth, Southwark, Wandsworth, City of Westminster

Power BI Courses London East: Bethnal Green, Bow, Chingford, East Ham, Hackney, Manor Park, Plaistow, Stratford, Victoria Dock, Walthamstow, South Woodford

Power BI Courses London South West: Chelsea, Clapham, Earls Court, South Kensington, Stockwell, West Brompton

Power BI Courses Battersea: Barnes, Mortlake, Putney, Streatham, Wandsworth, Wimbledon, West Wimbledon

Power BI Courses Paddington: Chiswick, Ealing, Hammersmith, Kensington, Maida Vale, North Kensington, Notting Hill, Shepherds Bush, West Ealing, West Kensington

Power BI Courses South West of England Region

Power BI Courses Somerset: Taunton, Bath, Bridgwater, Weston-super-Mare, Yeovil, Wells, Glastonbury

Power BI Courses Dorset: Dorchester, Bournemouth, Poole, Sherborne, Shaftesbury, Wimborne Minster, Weymouth

Power BI Courses Wiltshire: Trowbridge, Salisbury, Swindon, Chippenham, Devizes, Marlborough, Warminster

Power BI Courses Gloucestershire: Gloucester, Bristol, Cheltenham, Stroud, Cirencester, Tewkesbury

Power BI Courses South East of England Region

Power BI Courses Berkshire: Reading, Slough, Bracknell, Maidenhead, Newbury, Windsor, Wokingham

Power BI Courses Buckinghamshire: Aylesbury, Milton Keynes, Buckingham, High Wycombe

Power BI Courses Oxfordshire: Oxford, Abingdon, Banbury, Witney, Bicester, Henley-on-Thames, Carterton, Thame

Power BI Courses Hampshire: Winchester, Southampton, Portsmouth, Bournemouth, Basingstoke, Newport

Power BI Courses Kent: Maidstone, Canterbury, Bromley, Rochester, Margate, Folkestone, Dover, Greenwich

Power BI Courses East and West Sussex: Chichester, Brighton, Worthing, Crawley, Hastings, Eastbourne, Bognor Regis, Horsham

Power Platform Courses Scotland and Wales

Power Platform Courses Scotland: Aberdeen, Dundee, Dunfermline, Edinburgh, Fife, Glasgow, Inverness, Livingston, St Andrews, Stirling

Power Platform Courses Cymru (Wales): Aberystwyth, Cardiff, Monmouth, Swansea, Wrexham

Power Platform Courses Northern Ireland

Belfast, Derry, Lisburn, Newtownabbey, Bangor

Power Platform Courses British Dependencies & Self-Governing Territories

Bailiwicks of Jersey & Guernsey, British Virgin Islands, Cayman Islands, Gibraltar, Bermuda

Back to top

To book a training course simply call 0844 493 3699, or email info@foursquaretraining.co.uk