Training Course

Microsoft Power BI Desktop

Download Course PDF

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
Date Location Price
11 Sep - 12 Sep 2024
Virtual
£585
21 Oct - 22 Oct 2024
Durham
£685
20 Nov - 21 Nov 2024
Virtual
£585
16 Dec - 17 Dec 2024
Durham
£685
06 Feb - 07 Feb 2025
Virtual
£585
21 Apr - 22 Apr 2025
Virtual
£585
09 Jun - 10 Jun 2025
Virtual
£585
10 Sep - 11 Sep 2025
Virtual
£585
20 Oct - 21 Oct 2025
Durham
£685
19 Nov - 20 Nov 2025
Virtual
£585
15 Dec - 16 Dec 2025
Durham
£685

Private Training

Flexible dates, location and content. All prices exclude VAT.

Course Duration

2 Days

Microsoft Power BI Desktop Course Overview

Power BI Desktop is part of the suite of tools from Microsoft which enable data to be analysed and published from a variety of sources.

With Power BI Desktop, you get a report authoring tool that enables you to connect to and query data from different sources using the Query Editor. From the datasets you build with Query Editor you can create Reports and Visualizations or dashboards within Power BI Desktop. Reports can then be published.

This course covers the use of Power BI Desktop to connect to data, create Visualizations, query the data and publish reports.

This course does not cover MS Power BI Pro, Power BI accessed via Office 365 or SharePoint Services.

Course Prerequisites

    • Please note that this course is not suitable for new Excel or database users
    • Ability to create, format chart outputs
    • An understanding of basic data concepts
    • Excel Level 3 and above knowledge and experience required

Course Objectives

    • Power BI Desktop Concepts and Main Features
    • Data Sources compatible with Power BI Desktop
    • Connecting to Data with Power BI Desktop
    • Explore Data Visualizations
    • Apply Common Query Tasks to Shape Data in Power BI Desktop
    • Create and publish Reports

Target Audience for this Course

    • Anyone who is an experienced user of Microsoft Office applications and who needs to work with data in order to connect to, process, analyse in order to produce suitable output at all levels within an organisation.
    • It is assumed that attendees on the course are already familiar with charts and PivotTable concepts.

Included with this course

    • Lunch and refreshments when training is delivered at our training venues
    • Comprehensive course materials and exercises
    • Telephone and Email Support

Microsoft Power BI Desktop Course Content

  • Getting Started with Power BI Desktop

    Power BI Concepts and Overview
    Introduction to Main Features
    Report View
    Data View
    Relationship View
    Query Editor
    Using and interacting with reports

  • Connecting to Data Sources with Power BI Desktop

    Types of Data Sources in Power BI Desktop
    Get Data
    Connecting to Excel, CSV, Text
    Connecting to web data
    Connecting to databases (Access, SQL etc)
    Connecting to multiple sources
    Refresh connections

  • Getting Started with Data Visualizations

    Overview of Data Visualizations
    Tables and Matrix Views
    Simple Charts
    Pie, Columns and Bar Charts
    Tree Maps
    Simple Geo Maps
    Interactive Data and Date Slicers
    Drill Visualizations to see underlying data
    Adding Titles
    Adding Data Labels
    Setting Font and Colour Formatting
    Applying Conditional Formats

  • Querying and Cleaning Data

    Setting Data Types and calculation types
    Geocode Data
    Query Editor
    Replace Values
    Fix Errors
    Remove, Duplicate and Move Columns
    Filter out unneeded data
    Split Columns
    Pivot and UnPivot
    Creating Custom Columns
    Adding Conditional Columns
    Columns by Example
    Merge Queries
    Append Queries

  • Modelling Data

    Connecting to multiple tables
    Adding relationships to data
    AutoDetect
    Types of relationships
    Creating Date Table to add functionality

  • Introduction to DAX calculations

    DAX Expressions
    Calculated Columns
    Measures
    Time Intelligence
    Year on Year comparisons
    Year to date calculations
    Same Period last year comparison
    Quick Measures

  • Reports and Output Options

    Report Elements and Options
    Working with Pages
    Adding Graphics
    Visual and Filter Settings
    Export Power BI Data to CSV
    Publishing options

  • Advanced Visualisations and Report options

    Mapping Data
    ArcGIS Maps and options
    Combo Charts
    Gauge Charts
    Funnel Charts
    KPI’s
    Custom Visuals
    Word Clouds
    Record Grouping and Binning in Visualizations
    Drill Visualizations with using Dates
    Analytics and Forecast Lines in Visualizations

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
Date Location Price
11 Sep - 12 Sep 2024
Virtual
£585
21 Oct - 22 Oct 2024
Durham
£685
20 Nov - 21 Nov 2024
Virtual
£585
16 Dec - 17 Dec 2024
Durham
£685
06 Feb - 07 Feb 2025
Virtual
£585
21 Apr - 22 Apr 2025
Virtual
£585
09 Jun - 10 Jun 2025
Virtual
£585
10 Sep - 11 Sep 2025
Virtual
£585
20 Oct - 21 Oct 2025
Durham
£685
19 Nov - 20 Nov 2025
Virtual
£585
15 Dec - 16 Dec 2025
Durham
£685

Private Training

Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Have a Question?
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • Microsoft Power BI Desktop Course Options
    Public Scheduled
    Public Scheduled
    Fixed course content, fixed date, fixed location, fixed length, multiple organisations - All you need to do is choose which course you would like to attend and contact us to book!
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

Brilliant course

A. Kookaburra, Microsoft Power BI Desktop

Great course and content great trainer

D.J. Public course, Microsoft Power BI Desktop

Excellent clear training

G.T. Public course, Microsoft Power BI Desktop

Covered at an appropriate pace to accommodate all learners in the group

G.T. Public course, Microsoft Power BI Desktop

An excellent course and [the trainer] was very help and patient when addressing group questions.

G.T. Public course, Microsoft Power BI Desktop

Great facilities and really helpful trainer

V.P. MGL, Microsoft Power BI Desktop

Which part of the course did you find particularly valuable How it was very interactive, using the software rather than just watching the trainer is much more useful

H.S. Durham County Council, Microsoft Power BI Desktop

I will be putting the new skills I have learned into practice immediately

H.S. Durham County Council, Microsoft Power BI Desktop

Absolutely loved this course, I've been working with PowerBI for a couple of months, so great to have a better understanding of the power of the app and all it has to offer.

A.F. PX Limited, Microsoft Power BI Desktop

Not used Power BI before but now have ideas on where we can use it, so will start implementing.

R.W. PX Limited, Microsoft Power BI Desktop

It's improved my overall perception of Power BI, and has given me a good foundation to explore further, as well as hopefully help others.

C.B. PX Limited, Microsoft Power BI Desktop

Understanding how the data feeds into PowerBI was most useful.

R.B. NOCN, Microsoft Power BI Desktop

Brilliant session, great trainer.

S.H. NOCN, Microsoft Power BI Desktop

Following this training what are you going to do differently Be more confident to build my own reports making me more selfsufficient. Be more strategic in my methods.

L.B. NOCN, Microsoft Power BI Desktop

All aspects of the course were very valuable.

G.S. Northern Power Grid, Microsoft Power BI Desktop

Following this course, the reports that we will create will be more robust and interactive

G.S. Northern Power Grid, Microsoft Power BI Desktop

I now understand how to use PowerBi and feel confident that I will be able to create my reports through this system

P.H. Northern Powergrid, Microsoft Power BI Desktop

The course was fabulous

A.R. NOCN Group, Microsoft Power BI Desktop

[The trainer] covered the basics of using Power BI in a really accessible manner which was easy to understand.

L.C. NOCN Group, Microsoft Power BI Desktop

As someone who had never used power BI previously this was an interesting introduction and an impressive tool that will produce good quality and informative management information.

Z.B. NHSBSA, Microsoft Power BI Desktop

This will help in our reporting so firstly I am going to have a practice with our own data sets and have no doubt we will use Power BI regularly as the reporting is much more impressive and I am sure the visuals will be very well received by budget managers.

Z.B. NHSBSA, Microsoft Power BI Desktop

I very much enjoyed the training and hope I can now put it into practice.

Z.B. NHSBSA, Microsoft Power BI Desktop

Very happy with the whole thing

S.D. Nexus, Microsoft Power BI Desktop

I was a beginner at course start and found it to be an excellent introduction to all aspects of the program.

T.W. Network Rail, Microsoft Power BI Desktop

Following this training what are you going to do differently Will be leading the effort to replace a large number of reports currently done in Excel with Power BI variants to better present the data, and make reproduction far faster.

T.W. Network Rail, Microsoft Power BI Desktop

Il was a good pace and well explained

S.H. Macmillan Cancer Support, Microsoft Power BI Desktop

One of the best courses I have ever attended. The pace was good and their were not any questions that the trainer could not answer.

K.H. LDEUTC, Microsoft Power BI Desktop

Which part of the course did you find particularly valuable As a new user to Power BI I found the whole course really valuable but Stuart's explaining of the 7 steps to setting up a report was especially valuable.

J.H. NHSBSA, Microsoft Power BI Desktop

Any other comments or recommendations Being able to do this course remotely was a huge advantage

J.H. NHSBSA, Microsoft Power BI Desktop

For me, this was one of the best training courses I have attended, in my whole career. It was pitched at exactly the right level and covered all of the things I need to know to get me up and running with Power BI. The trainer was excellent. I'll be recommending this course to other BI colleagues.

P.M. NHS North Tyneside CCG, Microsoft Power BI Desktop

The whole course was extremely useful and applicable to my role.

L.S. Northumbria Healthcare NHS FT, Microsoft Power BI Desktop

Following this training what are you going to do differently Now feel confident to try out DAX in calculations and to make alterations to layouts, etc.

A.R. Durham County Council, Microsoft Power BI Desktop

Following this training what are you going to do differently I will share my reports more widely

A.L. Proctor & Gamble Product Supply UK Ltd, Microsoft Power BI Desktop

Which part of the course did you find particularly valuable All of it the data part was particularly valuable in understanding how the data is structured and related. The visuals and presentation part was really useful in understanding how to share. Also was really useful to be able to look at our own data.

E.W. northumbria university, Microsoft Power BI Desktop

Looking forward to putting what I've learnt into practice!

C.G. Northumbria University, Microsoft Power BI Desktop

Which part of the course did you find particularly valuable Being able to extract multiple bits of data from multiple data sources in such little time

N.Y. Broker Network, Microsoft Power BI Desktop

Which part of the course did you find particularly valuable I found the information on bookmarks and page navigation to be particularly helpful. I had previously used Power BI however as I was self taught I had never explored this before. I also found the terminology to be very useful, for example 'Content Pack' it is important to work to the true standards after all.

J.I. NHS BSA, Microsoft Power BI Desktop

Following this training what are you going to do differently I am going to be incorporating the standards I have learned and produce more comprehensive content packs.

J.I. NHS BSA, Microsoft Power BI Desktop

Following this training what are you going to do differently Perform the majority of data manipulation within Power BI rather than within the data source itself.

C.L. Paragon Customer Communications, Microsoft Power BI Desktop

Which part of the course did you find particularly valuable DAX language, manipulating the data, creating visuals, how to export data into PowerPoint

L.B. NEPO, Microsoft Power BI Desktop

[The trainer] was very patient, and very helpful

L.F. Durham County Council, Microsoft Power BI Desktop

Would recommend to others in performance reporting posts

L.F. Durham County Council, Microsoft Power BI Desktop

Really enjoyed the training and found it useful.

K.M. Durham County Council, Microsoft Power BI Desktop

+ View More Training Reviews

 

Public Scheduled Course Dates

Prices per delegate. All prices exclude VAT.
Date Location Price
11 Sep - 12 Sep 2024
Virtual
£585
21 Oct - 22 Oct 2024
Durham
£685
20 Nov - 21 Nov 2024
Virtual
£585
16 Dec - 17 Dec 2024
Durham
£685
06 Feb - 07 Feb 2025
Virtual
£585
21 Apr - 22 Apr 2025
Virtual
£585
09 Jun - 10 Jun 2025
Virtual
£585
10 Sep - 11 Sep 2025
Virtual
£585
20 Oct - 21 Oct 2025
Durham
£685
19 Nov - 20 Nov 2025
Virtual
£585
15 Dec - 16 Dec 2025
Durham
£685

Private Training

Flexible dates, location and content. All prices exclude VAT.

Other Courses In This Training Series

Excel Level 2 Course Course Overview: In Microsoft Office Excel Level 1, delegates created, edited, formatted, and printed basic spreadsheets. This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gai Excel Level 3 Course Course Overview: This course will benefit those who are already up to speed with Microsoft Excel but would now like to automate some common tasks and apply advanced analysis techniques to more complex data sets. This Excel course is aimed at anyone desiring to gain the skills necessary to create macros, audit and an Excel Analysing and Presenting Data with Dashboards and Pivot Tables Course Course Overview: This outline below contains an overview of a wide range of features within Excel that when used together can be used to create interactive visual reports and dashboards. The course will show delegates how these features can be used individually to present data but can also be used in combination to Excel Advanced Macros Course Course Overview: This course is designed to introduce you to the Macro environment of Excel, it will provide you with the confidence to record macros in Excel and then be able to gain a better understanding of the code and make changes to it. We even teach you some commands that cannot be recorded, such as how to sh VBA Essentials using Excel Course Course Overview: This course is aimed at those people who find they have reached their limit with the menu items of Excel and need to modify Excel to be better suited to their environment, by creating their own functions and procedures. Excel Level 1 - Essentials Course Course Overview: Microsoft Excel is a spreadsheet program that can be used for storing, organising and manipulating data.This Excel introductory course will enable delegates to gain a good general understanding of the main features of Microsoft Excel, giving them the ability to produce standard spreadsheets, create Excel Business Intelligence using Excel Power Tools Course Course Overview: This course is split into 3 main areas:1. Get and Transform (Power Query)2. Power Pivot - Data Models and DAX calculations3. Dashboard Creation with Pivot Tables, Charts and SlicersIt is aimed at users who want to analyse data from multiple sources and want to create effective data dashboards.Thi

 

 

Please contact us to discuss your Microsoft Power BI Desktop course, we have many solutions available to ensure you receive the best training possible.
Your Power BI course can be delivered online or in-person.  You can choose your learning path and delivery style.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible Microsoft Power BI Desktop course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master Power BI, please contact us to book a place or request a quote for your Microsoft Power BI Desktop course.

General Information

Microsoft and Microsoft Access are Registered Trademarks Microsoft Power BI Desktop Training Course available throughout North East England including Newcastle, Durham, Washington, Sunderland, Darlington, Leeds, Middlesbrough and Northumberland. Power BI Training in Newcastle
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:9/9/2024 2:45:24 AM