Microsoft Power BI
1 Day instructor-led course
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 0845 402 2781 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 0845 402 2781 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.