Menu

    Call us on:
    07477 578417

Power BI Training

We are now back to full face-to-face Power BI training at client site. We are also offering training by videoconferencing means, usually via Microsoft Teams or Zoom, if this is your preference. Click for more information about remote training.

If you’re looking for really great Power BI training you’re in the right place.

Companies large and small choose us – why? Your own tailored, Power BI training course, at your own premises at the same price as a standard course from elsewhere.

The JMD Training difference is clear:

  • We come to you – your training will be given on your site
  • You get to keep the manuals – training manuals are provided as PDFs
  • We can train using your own Power BI files
  • There will only be people from your company on your course
  • We offer a money-back guarantee if any delegates are not completely satisfied
  • The training date is around you, not us!
  • Our prices are astounding
  • We can assess all learners in advance for free
  • Our courses are never cancelled

Training locations

Our Power BI training courses London, are available not only in London, but Surrey, Middlesex, Richmond, Twickenham, Hounslow, Kingston, Woking, Reading, Croydon, Epsom, Banstead, Brentford, Putney, Wimbledon, Staines, Egham, Feltham, Farnham, High Wycombe, Crawley, Sutton, St Albans, Fulham – in fact anywhere within the Home Counties and M25 corridor.

Request Course Now »

Course Type Cost per day
1 to 1 training £375
2 to 4 delegates £625
5 to 8 delegates £845

Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £8645. All prices exclude VAT.

Visit our blog If Only I’d Known That,; we have called it that because we hear it so many times in training sessions. In fact, if only we had an extra £100 for every time someone says “If only I’d known that.” …. There are many useful hints and tips about using Microsoft Word on the blog; why not visit it to find out how many you knew!

Aims of the Power BI course

This course aims to introduce the learner to using Power BI.

Course Objectives

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

  • Demonstrate Power BI Desktop concepts and main features
  • Utilise data sources that are compatible with Power BI Desktop
  • Connect to data with Power BI Desktop
  • Explore Data Visualisations
  • Apply common query tasks to shape data in Power BI Desktop
  • Create and publish reports

The course is of two days’ duration.

How the course is run

This instructor-led course has a hands-on approach, with plenty of opportunity for delegates to practise the new skills they learn at the computer.

Pre-requisites - Familiarity with Excel including IF, XLOOKUP, Pivot Tables etc would be an advantage.

Provisional Course Outline

Getting Started

  • The Power BI Process
  • Launching Power Bi Desktop
  • The Four Views of Power BI
  • Creating Report Visuals

Getting Data

  • Connecting to Data Sources
  • Connecting to an Excel workbook
  • Connecting to a CSV file
  • Connecting to a Database
  • Connecting to a Web Sources
  • Connecting to a file folder
  • Creating a Data Table

Transforming and Appending Data

  • Cleaning Data in the Query Editor
  • Removing Rows by Filter
  • Replacing Values
  • Query Data Types
  • Detecting Data Types
  • Adding Custom Columns
  • Appending Data to a Query
  • Adding an Index Column
  • Resolving Error Issues
  • Performing Basic Mathematical Operations

The Power Query Editor

  • Filling Data Up and Down
  • Splitting Columns with Delimiters
  • Adding Conditional and Custom Columns
  • Merging Columns

Pivoting and Unpivoting Data

  • Pivoting Data in Power Query
  • Pivoting and Appending Data
  • Pivoting without summarizing
  • Unpivoting Data
  • Appending Mismatched Headers

Managing Table Relationships and Merging Queries

  • Table Join Kinds
  • Merging

Grouping Data in Power Query

  • Grouping Rows in a Table

Building a Data Model

  • Relating Tables in a Data Model
  • Cardinality
  • Data Modelling schema
  • Filter Flow
  • Joining Tables
  • Hiding in Report View

DAX Calculated Columns

  • Creating Calculated Columns
  • Best practice with calculated columns
  • DAX Syntax
  • Common Function Categories

Introduction to DAX Measures

  • DAX Rules
  • Turning off Field Summarisation
  • COUNTROWS function
  • DISTINCTCOUT function
  • CALCULATE function
  • SUMX function and when to use it

Introduction to Time Intelligence

  • Standard and Custom Calendars
  • Marking a Calendar as a Date Table
  • Time Intelligence functions
  • TOTALYTD functions

Creating Report Visualisations

  • Creating and formatting Visuals
  • Creating a Map Visual
  • Creating a Chart Visual
  • Formatting Map and Chart Visuals
  • Creating Table, Matrix and Card Visuals
  • KPI, Gauge and Waterfall Visuals
  • Formatting Table Visuals
  • Controlling a Visual’s Number format
  • Filtering Data with Slicers
  • Syncing Slicers Across Pages
  • Visuals from the Marketplace
  • Exporting Report Data to Excel

Hierarchy, Groups and Conditional Formatting

  • Creating a Hierarchy to “Drill” Data
  • Comparing Data in Groups
  • Conditional Formatting

Publishing and Sharing Reports Online

  • Publishing to the Online Power BI Service
  • Getting Reports from the Power BI Service
  • Getting Quick Insights
  • Sharing Reports

Request Course Now »