Microsoft 365 · 1 dayMicrosoft Excel
Our most popular course, from first formulas to PivotTables and macros.
From£195 per delegate
Microsoft 365 & Copilot
Microsoft Power BI
Build reports that turn data into decisions
A hands-on, one-day instructor-led Power BI course: delivered live online, at your premises or at our UK classrooms, tailored to the data your team actually reports on.
Length1 day
LevelAll levels
FormatsIn-house · Live online · Public
Group sizeUp to 8 per group
About the Microsoft Power BI course
This practical one-day instructor-led course introduces your team to Microsoft Power BI and how it can help in building and designing reports. You will discover what Power BI is, how to access it, and how to use it to extract and clean Excel data, build reports and charts, and publish and share your work.
Courses can be delivered live online, at your premises or at one of our classrooms in Preston, Manchester, Liverpool, Leeds and Birmingham, and every course can be tailored to your team’s own data.
- Free training needs analysis before your course
- Tailored with your real workplace data
- Free post-course telephone & email support
Datasets & Power Query
Load data from Excel, then clean and transform it in Power Query.
Reports & Visuals
Build interactive reports with charts, matrix visuals and slicers.
Maps, KPIs & Charts
From pie charts and maps to KPIs, gauges and decomposition trees.
Publish & Share
Publish to the Power BI service and view reports on mobile apps.
What the day covers
5 modules · tailored to your team on in-house courses
Getting Started with Power BI3 topics
- What is Power BI?
- Power BI terminology
- The Power BI Desktop window
Working with Datasets4 topics
- Creating a dataset
- Getting & loading data from Excel
- Cleaning data in Power Query Editor
- Relationships between data tables
Visualising Your Data4 topics
- Building a report using visuals
- Matrix visualisation
- Formatting a visual
- Using slicers
Types of Visualisations4 topics
- Area & combo charts
- Pie charts & doughnuts
- Decomposition tree & maps
- Funnel & gauge charts, KPIs
Publishing & Sharing3 topics
- The online Power BI service
- Sharing reports & dashboards
- Power BI mobile apps
By the end of the course, delegates will be able to
- Connect to data sources such as Excel files, CSVs and other common sources
- Clean and transform data using Power Query
- Create relationships between tables and build a simple data model
- Design interactive reports and dashboards with a range of visuals
- Use slicers and filters to make reports dynamic
- Publish and share your reports with others in your organisation
Ways to book this course
Public Course
Classroom Place
£325+ VAT
One-day classroom · per person
- Preston, Manchester, Liverpool, Leeds & Birmingham
- Small groups with 1-to-1 support
- Materials, certificate & refreshments
Virtual Delivery
Live Online
£695+ VAT
One-day live online · up to 6 people
- Delivered via Microsoft Teams or Zoom
- Tailored to your team’s own data
- No travel – join from anywhere
Most popularIn-House
At Your Premises
£745+ VAT
One-day onsite · up to 8 people
- Tailored with your team’s own data
- Our trainers visit you, UK-wide
- Reference materials & certificates
Who the course is for
Before you attend
Delegates should have a basic knowledge of Windows, web browsers and Excel, and be confident using a mouse and keyboard. We recommend having the free Power BI Desktop application installed to get the most out of this highly practical day.
Join a scheduled course
One-day courses, 9:30am to 4:30pm, with refreshments, lunch, reference materials and a certificate. Book 2 or more places for a discount.
| Date | Venue | Price | Book |
|---|---|---|---|
| Wednesday 21 October9:30am to 4:30pm | Liverpool | £325 + VAT per delegate | Request a place |
| Wednesday 28 October9:30am to 4:30pm | Leeds | £325 + VAT per delegate | Request a place |
| Wednesday 4 November9:30am to 4:30pm | London | £325 + VAT per delegate | Request a place |
| Wednesday 4 November9:30am to 4:30pm | Manchester | £325 + VAT per delegate | Request a place |
| Wednesday 11 November9:30am to 4:30pm | Birmingham | £325 + VAT per delegate | Request a place |
| Wednesday 11 November9:30am to 4:30pm | Preston | £325 + VAT per delegate | Request a place |
| Wednesday 18 November9:30am to 4:30pm | Liverpool | £325 + VAT per delegate | Request a place |
| Wednesday 25 November9:30am to 4:30pm | Leeds | £325 + VAT per delegate | Request a place |
| Tuesday 5 January9:30am to 4:30pm | Liverpool | £325 + VAT per delegate | Request a place |
| Monday 11 January9:30am to 4:30pm | Leeds | £325 + VAT per delegate | Request a place |
More than just a training day
Dedicated account managerOne named contact who knows your organisation and your history with us.
Pre-course evaluationFree skills check forms so every delegate lands on the right level.
Course tailoringWe plan and customise closed courses around your roles, systems and files.
CertificatesA Keys Training certificate for every attendee, for training records and ESR.
Management feedbackPost-course feedback reviews so you can see what landed.
Free aftercareTelephone and email support for every delegate after the course.
Frequently asked questions
Do I need prior experience of using Power BI?
Our typical one-day introduction course requires no prior knowledge of using Power BI. However, attendees should have basic Windows and Excel skills, and be comfortable using a mouse and keyboard.
Do I need Power BI Desktop installed on my laptop?
Yes. Keys Training recommends having Power BI Desktop installed to get the most from practice tasks and to ensure that the skills have been fully mastered and can be applied confidently in the workplace.
Can the course topics be customised to our needs?
Yes. We are able to make reasonable adjustments and course tailoring to ensure the training meets your needs. We can:
If you’d like a tailored course, let us know your objectives and current challenges when you enquire.
- Focus on the types of reports and dashboards you need
- Emphasise specific data sources you use
- Adjust the pace and content for different skill levels
- Where appropriate, incorporate examples similar to your own data
Ready to put your data to work?
View upcoming scheduled dates, or speak with a training advisor to arrange a tailored Power BI course for your team.
View Scheduled DatesEmail an Enquiry
Or call us on 0345 450 0051 to speak with a training advisor today.
Keep going
Courses that pair well with this one
Microsoft 365 · 1 day
Microsoft 365 · 1 dayMicrosoft Copilot
Put AI to work in the Microsoft 365 apps your team already uses.
From£445 per group
Microsoft 365 · 1 dayMicrosoft Project
Two levels. Plan, schedule and track real projects.
From£275 per delegate
Microsoft 365 · 1 dayExcel Introduction
The right start for beginners and the self-taught.
From£195 per delegate
Get your team trained properly.
Tell us the course, rough numbers and where you are. A training advisor will reply within one working day with options and a fixed fee.
Build your quote or call a training advisor0345 450 0051