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

Archway Computer Training provide tailored Power BI training.We offer Power BI training Wiltshire, Power BI training Dorset, Power BI training Somerset and Power BI training Hampshire. All Power BI training is delivered on client site where it can be tailored to the needs of the individual or organisation.

Number on coursePrice per day
1 - 1 training£375 + VAT
2 - 4 people£625 + VAT
5 - 8 people£845 + VAT

Aims of the 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

Clients who have benefitted from our Power BI training include:

To request further details of any of our courses, or to make a booking, please contact us by ringing 01747 820396 or 07477 578417 or by sending an email to info@archwayct.co.uk or filling in our contact form.