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 attendees).
Keys Training also delivers regular public courses at our venues. The price per place is £275.00 plus vat. If this is of interest, please contact to discuss further, including your needs and preferred location.
Please call 0845 402 2781 or email train@keystraining.com 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