Microsoft Power BI

Microsoft Power BI Training

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).

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