• Microsoft Partner
    -
    Learn with experts
  • CPD Certified
    -
    Validated by specialists
  • Rated Outstanding
    -
    11 years in a row
  • Moneyback Guarantee
    -
    100% Peace of mind

Our Power BI Training Manchester Courses

1 Day Power BI Introduction Course

Introduction to Power BI Course

CPD Certified
4.79 / 5
1 day.
Client Site Courses Available.
Classroom, Online & Client Site.

This Power BI for beginners course covers all of Power BI’s basics. It is ideal if you will be working with dashboards and reports created by others.

  • Overview of Power BI
  • Importing data (various sources)
  • Ways to manage your data
  • Creating data visualisations
  • Publishing & sharing reports
  • Automatically refreshing data

Overview

This Power BI for beginners course covers all of Power BI’s basics. It is ideal if you will be working with dashboards and reports created by others.

  • Overview of Power BI

  • Importing data (various sources)

  • Ways to manage your data

  • Creating data visualisations

  • Publishing & sharing reports

  • Automatically refreshing data

Full Syllabus

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.

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £495.00 (+VAT)

Book Now
2 Day Advanced Power BI Course

Advanced Power BI Course

CPD Certified
4.83 / 5
2 days.
Client Site Courses Available.
Classroom, Online & Client Site.

Become a Power BI  power user. Learn to create dashboards and reports, use it for data storytelling and manage data governance and security.

  • Create and customise reports in Power BI
  • Use Drill Down and Drill Through
  • Use Custom Tooltips and Bookmarks
  • Optimize your Data and Relational model
  • Design best practices
  • Security, permissions & ChatGPT

Overview

Become a Power BI  power user. Learn to create dashboards and reports, use it for data storytelling and manage data governance and security.

  • Create and customise reports in Power BI

  • Use Drill Down and Drill Through

  • Use Custom Tooltips and Bookmarks

  • Optimize your Data and Relational model

  • Design best practices

  • Security, permissions & ChatGPT

Full Syllabus

  • Main Concepts
  • Transformation with Power Query
  • Report Design with Report Builder
  • M-Code vs DAX
  • Working with Power BI Backgrounds
  • Introduction to DAX
  • Creating Measures & Calculated Columns
  • DAX Measure and Column Syntax
  • SUM vs SUMX
  • FORMAT & WEEKDAY functions
  • Build a Monthly Sales/Profit Report
  • Using Slicers and Filters
  • Working with Power BI Panes
  • Building Tabular Reports
  • Working with Matrix Layouts
  • Types of Conditional Formatting
  • Adding Drill-Downs
  • Creating Drill-Through Reports
  • Custom ToolTips
  • Bookmarks
  • Creating a Comparison Page
  • 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.

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £995.00 (+VAT)

Book Now
3 Day MS Power BI Training Course: Introduction & Advanced (SAVE £100)

Combined Power BI Course (£100)

CPD Certified
4.8 / 5
3 days.
Client Site Courses Available.
Classroom, Online & Client Site.

Our combined course is the fastest way to learn Microsoft Power BI. Go from complete beginner to expert in 3 days.

Save £100 when you book our Introduction and Advanced Power BI courses at the same time.

Overview

Our combined course is the fastest way to learn Microsoft Power BI. Go from complete beginner to expert in 3 days.

Save £100 when you book our Introduction and Advanced Power BI courses at the same time.

Full Syllabus

Am I Ready?

Instructor

CPD Accreditation

Dates, Prices & Booking

STEP 1. Choose location

STEP 2. Select your date

STEP 3. Price

Price: £1390.00 (+VAT)

Book Now

Easy booking & payment

Money back guarantee

Post-course support

Where Do You Run Your Courses In Manchester?

Manchester Training Centre (Power BI Training)

Oxford Court
Manchester, M2 3WQ
Tel: 0161 821 1384