Power BI Masterclass Training Course - UK wide
Power BI Masterclass Course Overview
Our four-day Power BI masterclass training course provides an in-depth instructor-led course that takes novices through to an expert level of knowledge modelling data with Power BI's self-service business intelligence solutions.
This four-day, in-depth Zero-To-Hero Power BI Masterclass provides everything your organisation needs to start engaging with data modelling, analytics and visualisations at a sophisticated level of competence.
The Microsoft Power BI Masterclass is an interactive instructor-led event which will be conducted either on-site at your premises or as live virtual classroom via MS Teams. Courseware will be provided electronically.
Our expert trainers come to you and can deliver this masterclass Power BI course at your premises anywhere in mainland UK.
Power BI Masterclass Prerequisites
Whether your staff have only ever used the Online Service version of Power BI before, or they have no previous experience at all with Power BI, this is the course they should undertake if you need an end-to-end bootcamp which takes rookie users from scratch and converts them into skilled data modellers with the Desktop version of Power BI. Some prior understanding of data management would be advantageous.
Who should take this Power BI Masterclass course?
If you need to get your staff from absolute beginners through to an advanced level of competency with Power BI in under a week then this is the course that we recommend.
If your learmers already have a fair level of experience working with the Power BI desktop, then we recommend our three-day advanced course instead.
On-site Power BI Masterclasses in the United Kingdom
These are corporate in-house training courses conducted at your workplace for small groups. You should aim to book at least a month in advance and the maximum group size is eight per course.
Our 'face-to-face' closed courses for Power BI are delivered as private events and afford more flexibility than off-the-shelf courses with opportunities to tailor content to fit your particular learning needs. Your trainer will discuss your requirements with you prior to the course date.
We can attend anywhere in mainland UK (for overseas requirements, please enquire).
With our on-site Microsoft Power BI courses our trainers come to your workplace throughout mainland UK, bringing the training to you whether you're in a major city such as London, Manchester, Birmingham, Leeds, or anywhere else.
This offers a cost-effective way to train Power BI for 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 Masterclasses - UK & Beyond
If you'd rather that your team learns remotely, these small-group Power BI masterclasses are also available as live virtual, interactive sessions from the comfort of your office or workplace. These courses are taught via Microsoft Teams.
Why choose virtual learning? As we've all become used to Online learning (and live virtual meetings) it is clear that virtual classroom delivery has some advantages over traditional face-to-face learning.
If you're looking for local training, then you can't get closer to your doorstep than you can with virtual learning.
The maximum group size is eight per course and you 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 enriched by features such as live chat, private chat, and sharing screens and documents.
Learn More About Virtual Training with MS Teams.
Four-Day Microsoft Power BI Masterclass Cost
Our masterclass course is charged at £3700.00 plus VAT inclusive up to six delegates. There is also a cost of £125.00 p/d to cover accommodation and travel within mainland UK (for offshore requirements additional costs apply). More learners can be added for £50.00 plus VAT per person p/day up to a limit of 8.
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.
We really ❤ helping UK organisations to become Power BI virtuosos. Our only question is: Will it be yours?
We come to you: Our Power BI trainers and consultants cover mainland UK for on-site visits including the English regions of the North West, North East and Cumbria, Yorkshire and the Humber, Greater London, the East of England, West Midlands, East Midlands, South West of England and the South East of England Region. We also cover Scotland and Cymru (Wales). Virtual classroom courses are available from anywhere via live video conferencing.
Our Power BI Trainers are:
Inspirational subject experts with a wealth of experience, proven track records and excellent feedback.
Our Closed Power BI Courses are:
Flexible instructor-led courses catering to YOUR specific learning needs and training requirements.
Education is Our Passion:
Over 24,000 students trained across almost every industry, sector and background.
Commercial and Corporate Power BI Masterclasses for the Public and Private Sectors
What is the Teaching Method for Our Power BI Courses?
The teaching methodology for our Power BI courses is Instructor-led training (ILT), which means that our courses are engaging, immersive, hands-on and interactive. With this participatory learning method your staff will retain information better, whether they're studying Power BI subjects in-person or via live virtual classroom.
And, whilst we're happy to provide lectures, show-and-tells and drop-in surgeries, the ILT approach is by far the best way 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 a lunch hour and short breaks morning and afternoon. This timetable is fairly standard across the industry and gives six hours of hands-on Power BI learning, which is an optimal day's training for comfortably absorbing and retaining information and completing practice exercises.
If you want a different start time for your course please let us know.
Courses are run week days, during normal business hours.
More About Our Power BI Training Delivery Method for Closed Courses
- Step-by-Step Courses: Instructor-led Power BI training provided in-person with engaging step-by-step demos, lessons and hands-on exercises.
- Q&A Courses: Dynamic and interactive Power BI courses with ample time for questions and answers.
- Flexible Courses: Expert tuition, tailored to your team's knowledge level and learning needs, and covering the Power BI Measures, features and techniques that your trainees need most.
- Small Class Sizes: Private, small-group training with a maximum of 8 learners to ensure personalised attention.
- Scalable Courses: Can be run as one or more courses, or as a training rollout bringing entire departments and organisations up to the benchmark of Power BI knowledge and confidence needed.
Microsoft Power BI Masterclass Outline and Agenda
- Lesson 1: Power BI Overview
- Understanding the different Power BI Products and Services
- Power BI Desktop version (What does it do? / What is it for?)
- Understanding Power BI Licensing
- Lesson 2: Loading Data into PBI
- Load Data from CSV Text Files, Excel Worksheets and from MS SQL Server databases
- Comparing Import and DirectQuery Storage Modes
- Load Data from OneDrive and SharePoint sources
- Load Data from a Webpage
- Connecting Live to a Published Dataset
- Lesson 3: Transforming Data with PBI
- Profiling, Cleaning & Transforming Data
- Optimising CPU usage and memory capacity with Query Folding
- Shaping and Sculpting Datasets
- Merging and Appending Data
- Applying Fuzzy Lookups1
- Structuring and Managing your Queries
- Viewing Query Dependencies
- Power Query Parameters
- Using Power BI Template Files
- Using the M Language2
- Lesson 4: Data Modelling in PBI
- Basic Data Modelling Concepts
- Configuring Tables
- Categorising Data
- Sorting Columns
- Creating Hierarchies
- Organising Content with Display Folders and Views
- Using Relationships
- Understanding Filter Propagation
- Lesson 5: The DAX Language3 for PBI
- Introduction to DAX
- Using Calculated Columns
- Creating Custom Groups
- Using DAX Measures
- Using the Filter Context with CALCULATE
- Using Variables
- The DAX Query View Environment
- Iterator Functions
- Using the FILTER Function
- Creating Calculated Tables
- Dynamic Format Strings
- Lesson 6: Visualising Data in PBI
- Formatting Tables and Matrix Visuals
- Conditionally Formatting Visual Content
- Using Card Visuals
- Formatting Charts
- Report Themes
- Using Sparklines for quick-reference chart visualisations
- Using Tooltips
- Continuous Axis versus Categorical Axis
- Automatically Identify Clusters of Data
- Working with Animating Scatter Charts
- Using the Analytics Pane
- Forecasting and Anomaly Detection
- Using the Analyse Feature
- Using Tree Maps for hierarchical, nested data
- Analysing Data with a Decomposition Tree4
- Using Gauges and KPIs
- Using Map Slicers5
- Using Filters
- Importing Visuals
1) A fuzzy lookup allows you to return results based upon parameterised similarities as opposed to ones based upon exact matches.
2) Not dissimilar to DAX (see below), M Language is a Power Query formula language which allows you to use functions to filter and combine data from one or more sources.
3) Simply put, DAX measures are what you might refer to as functions and/or formulas in other applications such as Excel. The DAX formula language is more specialised than this suggests though and it provides measures for working with relational data and aggregating data from multiple sources. As a formula language, DAX consists of all the components of a formula including its functions, constants and operators.
4) In its simplest sense, a decomposition tree is a type of visualisation in Power BI which allows you to drill down through your data (with AI) to perform "root cause analysis". The term orginates from graph theory which uses the tree decomposition model to map the fastest computational route to solving a mathematical question.
5) Power BI Slicers provide a means of quickly filtering portions of your data model with the click of a button. In Power BI Slicers provide a really simple way of sculpting your visualisations. The two main types of slicer tools are dropdown slicers and slider slicers.
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 Power Apps Introduction
- course duration - two days
- Canvas Apps for Power Apps 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
☆ ☆ ☆ ☆ ☆ Five Star Review
Fantastic trainer.
Another fabulous course.
Power BI Training Portsmouth
More like this...
0844 493 3699
email us