Business Booking Details

Payment Of Invoices

For bookings from established businesses, we do not require payment at the point of booking.

We will send you an invoice which you can submit to your accounts payable system.

Purchase Orders

If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.

  • If you already have a P.O. number when booking add it to the PO number box on the booking form, and we will include it on your invoice.
  • If you need an invoice to generate a P.O. number in your accounts system, please book the course as normal and add a note in the PO number box – to be provided
  • We will send you an invoice (without a P.O.) which you can use to generate a P.O..
  • We will then re-issue your invoice with your P.O. included when you provide us with it

PAYMENT METHODS:

You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.

We accept payment either via direct bank transfer or card

Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.

Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.

Master Power BI’s most powerful functions on this 2 day Advanced Power BI training course

This is a hands-on course. You get lots of time to practise creating and editing reports and data visualisations. This ensures that you really get to grips with what you are being taught.

By the time you finish, you’ll be an expert Power BI user.

A course covering all of Power BI’s most advanced functions.
Plenty of one-to-one attention and time to ask questions.
Friendly expert trainers, small groups and a comfortable place to learn.
All the materials and extras that you’ll ever need.
Ongoing support and help with issues you have after the course.

What Will I Learn?

This course will allow you to master Power BI’s most powerful functions.

By the end of this Power BI course you will be able to confidently:

  • Create and customise a report in Power BI.
  • Drilldown into the data in a model.
  • Build drill-through reports and relative date reports.
  • Create stunning data visualisations including maps, bullet and scatter charts.
  • Refresh your data manually and also at pre-set intervals.
  • Set security and data permissions.

 

The Trainer

Oakley is one of our regular trainers for this course. He has been a Microsoft certified trainer for 8 years.

He has been training Microsoft applications for 19 years, and focuses on Power BI and Project.

 

Am I Ready For This Course?

This course assumes you are already a comfortable Power BI user. 

It is recommended that you have completed at least our introduction to Power BI course, and ideally our Excel BI training course. or that you have equivalent experience, before attending this course.

The course assumes that you already have a good understanding of the basics of Power BI including using DAX and measures and creating dashboards.

If you are new to Power BI but keen to become an advanced user we would recommend that you look at our combined power bi course which offers you both introduction and advanced training with a £100 reduction.

The Training Day

We provide everything that you’ll need for a really fun, productive day of Power BI training. You don’t need to bring anything with you.

Our training courses run from 9.30am to approximately 4.30pm with a break for lunch and plenty of refreshments and biscuits throughout the day.

We offer comfortable, fully air-conditioned training facilities and some of the nicest instructors on the planet.

Also, you’ll receive:

A full-colour manual which covers everything in the course.
Your course exercises so that you can practice at home.
A Certificate of Attendance.

 

Course Details

  • What is Power BI?
  • The main concepts the course will cover
  • Power Query
  • Power BI Desktop
  • Introduction to DAX
  • Implicit vs Explicit Measures
  • Creating Measures & Calculated Columns
  • Commonly Used DAX Functions
  • SUM, AVERAGE, COUNT, DISTINCTCOUNT
  • Time Intelligence (MTD, QTD, YTD, Prior Year)
  • Understanding ‘CALCULATE’ and the filter context
  • Using Quick Measures
  • Build a Monthly Trend Report
  • Types of Slicers and Filters
  • Using Field, Format, Analytics Pane
  • Building Tabular Reports
  • Replicating Excel Pivot Tables
  • Types of Conditional Formatting
  • Optimizing the Matrix Layouts
  • Adding Drill-Downs
  • Creating Drill-Through Reports
  • Filtering Reports by Relative Dates
  • Viewing the Underlying Data Driving a Visualization
  • Customizing Report Visual Interactivity
  • Exporting Data from Power BI
  • Build a Qty Shipped Vs Qty Sold Report
  • Building Reports using Q&A
  • Optimizing Report Slicers
  • Choosing Visuals Based on Context
  • Using Custom Visuals
  • Optimizing the use of Maps
  • Getting Value from Scatter, Ribbon & Bullet Charts
  • Adding & Optimizing Tool Tips
  • Visual Alignment Tips
  • Custom Page Sizing
  • Using Logos & Custom Icons
  • Formatting Tips & Tricks
  • Understanding Row Level Security
  • Creating and Testing Security Roles
  • Publishing Models to the Cloud Service
  • Basic Sharing of Dashboards & Reports
  • Creating App Workspaces
  • Adding Users & Editing Workspaces
  • Connecting to Apps / MS Teams
  • Overview of the Data Gateway
  • Scheduling Data Refreshes
  • Refreshing On-Demand

From 1st July during this course, we will briefly introduce you to ChatGPT and its possibilities when using Power BI.

  • ChatGPT vs Bard vs Other AI tools
  • Some of the ways you can use ChatGPT with Power BI
  • A very simple example

As this section is a brief taster, it is not covered in our course materials or post-course support.

Online Training Requirements

To attend this Power BI course online, you will need:

Power BI running on a Windows PC with a camera, speakers & microphone
A stable internet connection capable of running Zoom
To be a confident computer user and able to use Zoom

If you have access to a second screen, we would encourage you to use it as it improves the experience.