Microsoft Power BI Training
(One-day instructor course)
Microsoft Power BI
Our trainers will visit and teach one-day tailored MS Power BI courses at your premises for £745.00 plus vat (up to 8 people can attendee).
Keys Training also delivers regular public courses at our classrooms. The price per place is £325.00 plus vat. If this is of interest, please contact to discuss further, including place availability and your preferred location.
Please call 0345 450 0051 or email [email protected] to discuss your needs.
Introduction
This one-day instructor led course is designed to introduce people to using MS Power BI and how it can help in building and designing reports. You will discover what Power BI is and how to access it. You will learn how to use Power BI when extracting and cleaning Excel data, building reports and charts, and publishing and sharing your reports.
Course Objectives
To understand the basics features and uses of Power BI
To create and manage datasets
Create views to arrange items of information
Building reports using visualisation options
An understanding of publishing and sharing your reports
Pre-requisites
Delegates should already have a basic knowledge of MS Windows, web browsers and MS Excel and be confident using a mouse and keyboard.
Delegates should ensure they have the Power BI Desktop application downloaded to get the most out of this highly practical day.
Course Content
Getting Started with Power BI
What is Power BI?
Power BI Terminology
The PBI Desktop Window
Working with Datasets
Creating a Dataset
Getting / Loading Data from Excel
Transforming and Cleaning Data in Power Query Editor
Creating the Relationships Connections Between the Multiple Data Tables
Visualising Your Data
Building a Report Using Visuals
Matrix Visualisation
Formatting a Visual
Using Slicers
Types of Visualisations – creating several visualisations including;
Area Charts
Single and Multi-Row Number Cards
Combo Charts – Column and Line etc
Pie Charts and Doughnuts
Decomposition Tree
Maps
Funnel and Gauge Charts
KPIs
Publishing and Sharing
An introduction to using the online Power BI publishing service for viewing and sharing reports and dashboards
Power BI mobile apps – for viewing reports and dashboards on the go
FAQs for Microsoft Power BI training
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:
- 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
If you’d like a tailored course, let us know your objectives and current challenges when you enquire.
What will I be able to do after the course?
By the end of the course, you 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
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:
- 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
If you’d like a tailored course, let us know your objectives and current challenges when you enquire.
What will I be able to do after the course?
By the end of the course, you 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
View Dates & Book Course
Please view our up coming course dates using the link below.
Scheduled Microsoft Office Course Dates
To book onto any course please email [email protected] or telephone 0345 450 0051 to speak with a training advisor and check availability.
*Prices are per delegate
*Book 2 or more places on the same course and receive significant discounts.