Preloader spinner

Microsoft Power BI Desktop Introduction

Image of laptop displaying an image containing the words Microsoft Power BI


1 Day

Course Aims:  

On completion of this course, you will have learnt to use Power BI (Business Intelligence) Desktop to create report visuals. You will understand how the reports can interact with each other and the great level of interactivity the audience can use to drill, filter, sort and create simple calculations.


Course Pre-requisites:

Delegates who wish to attend this course must have an Intermediate knowledge of Excel or be competent at working with formulas using absolute cell references, use basic functions like Sum, Average, Count, be able to create a simple chart and use filters.


Course Objectives:

 On completion of this course, delegates will be able to:

  • Understand basic Power BI desktop concepts and features
  • Connect to Excel data with Power BI desktop
  • Be able to perform simple calculations using calculated columns
  • Work with Power BI standard visuals
  • Apply, remove, and edit conditional formatting to Table visuals


 Course Content:

Introduction and Objectives


Power BI Desktop Basics

  • What is Power BI Desktop
  • Getting started with Power BI Desktop
  • Identify Report, Table and Model views
  • Explanation of other tools available in Power BI


Getting Data

  • Import an Excel file into Power BI


Working in Data View

  • Sorting and Filtering data
  • Formatting columns to currency, decimal places,and percentages



  • Create calculated column calculations in the data view using  Addition,Subtraction, Division and Multiplication

Working with Report Pages

  • Rename, Insert, Move, Delete and Copy pages
  • Format the page
  • Inserting Text boxes and images


Working in Filters Pane

  • Show and hide filters pane
  • Filter on this page and on all pages

Adding Visualisations to the Report Canvas

  • Donut
  • Pie
  • Clustered Column and Bar Chart
  • Slicers
  • Card
  • Table
  • Matrix
  • Line


Working with the Visuals

  • Formatting, Editing, Moving, Copying and Deleting visuals
  • Moving the fields around on the Visual
  • Sorting data on the visuals
  • Show data from the visual as a Table and as a Data point

Conditional Formatting

  • Applying and editing Conditional formatting to a Table visual
  • Removing Conditional formatting


Hints and Tips

  • Show and hide Gridlines

Related Courses

Download PDF Outline

Public Schedule

£495 per delegate
Our price:  
£450 per delegate

Virtual Private Training

Contact us for pricing

Onsite Training

Contact us for pricing


All prices exclude VAT at 20%.

VAT registration number: 450 4347 14

You may like...

Microsoft SharePoint Super User (Site Owner)

This course is aimed at people required to effectively manage SharePoint sites and pages as a Super User (Site Owner).

An icon of a person


An icon of a clock

2 Days

Microsoft Power Automate Introduction

This 1-day course explores the basic building blocks and allows you to create you own flows and understand how to develop your skills to the next level.

An icon of a person


An icon of a clock

1 Day

Microsoft Power Apps Introduction

Power Apps is a suite of apps, services, connectors, and a data platform that provides you with an opportunity to build custom apps for your business needs.

An icon of a person


An icon of a clock

1 Day

Enquire about this course

Microsoft Power BI Desktop Introduction
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Join our mailing list

Receive details on our new courses and special offers

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.