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.
Click on the sections below to see the detailed course syllabus.
What is Power BI and when do I use it?
Power BI installation and versions.
What is Power BI – a Pocket History
Power BI vs Competitors
Understanding Power BI Desktop vs Service
Power Query vs Report Builder
Power BI Workflow Summary
Different data sources: Files, Databases and the Web.
Optimising and transforming your Data
Removing Columns/Rows
Data Type Changes
Filtering data
Replacing Data
Splitting/merging/Extracting Data
Setting up the Report Canvas
Matrix
Charts
Cards
Tables
Inserting and Using Basic Slicers
This topic is only demonstrated showing how it could look as every company is set up differently
Power BI License Types
Workspaces – Permissions
Power BI Service Tour
Editing your Report
Sharing and Subscribing
Exporting to Web/PowerPoint/SharePoint
Creating a Dashboard
This topic is only demonstrated showing how it could look as every company is set up differently
Overview of the Data Gateway
Scheduling Data Refreshes
Refreshing On-Demand
Am I Ready?
You don’t need any prior knowledge of Power BI to come on this course.
This course assumes that you have a basic understanding of Data sources e.g. Excel/ CSV/ Databases etc.
Instructor
Oakley is one of our expert trainers for this course with deep Power BI expertise. He has been a Microsoft Certified Trainer for 8 years.
He has 19 years experience training across various Microsoft applications and a very broad foundation in the Microsoft ecosystem.. He has specialised in Microsoft Power BI since 2017, making him a veteran of the platform. This specialisation includes training delegates on advanced data modeling, DAX scripting, data visualisation best practices, and Power Platform integration, ensuring that you don’t just learn to use Power BI, but how to be an effective Power BI developer and analyst.
Editing Interactions for Slicer/Visual Interactivity
Custom and Conditional Formatting
Build a YTD Summary and Detailed Report
Time Intelligence (MTD, QTD, YTD, Prior Year)
Understanding CALCULATE to filter
Understanding IF and SWITCH
Understanding DIVIDE
Using Quick Measures
Creating % Ratio and % Change with DAX
Working with Charts
Optimizing the use of Maps
Managing and using imported Power BI Visuals
Working with Dynamic Images
Adding In-Page Navigation
Mobile Layout Design
Working with Related Tables
Model View and Relationship Management
Introduction to Join Types
Modelling best practice
Merging and Disabling Load
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.
Am I Ready?
This course assumes you already understand the basic of Power BI including measures and creating dashboard.
It is recommended that you have completed our Power BI Introduction workshop or have equivalent experience before attending this course. It is expected that you will have a working knowledge of Power BI, including Report design techniques and using Measures
Instructor
Oakley is one of our expert trainers for this course with deep Power BI expertise.
He has 19 years experience training across various Microsoft applications and a very broad foundation in the Microsoft ecosystem as a Microsoft Certified Trainer (MCT). He has specialised in Microsoft Power BI since 2017, making him a veteran of the platform. This specialisation includes training delegates on advanced data modeling, DAX scripting, data visualisation best practices, and Power Platform integration, ensuring that you don’t just learn to use Power BI, but how to be an effective Power BI developer and analyst.