• 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 an end user 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
  • DAX fundamentals

Overview

This Power BI for beginners course covers all of Power BI’s basics. It is ideal if you will be an end user 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

  • DAX fundamentals

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.
  • Different data sources: Files, Databases and the Web.
  • Repointing to Moved Data Source
  • Removing Columns/Rows
  • Data Type Changes
  • Filters
  • Group
  • Split
  • Duplicate
  • Combine: Append and Merge
  • Pivot/Unpivot
  • Columns: Add Column, Custom Function, Conditional Column
  • Index
  • Extract
  • Model View and Relationship management
  • Join Kinds
  • Hierarchies
  • Working with Related Tables
  • Formula
  • Measures
  • Quick Measure
  • Date Table Rules
  • Setting the Date Table
  • External and Internal
  • Automatic Date Table
  • Time Intelligence Formulas and Measures
  • Matrix
  • Conditional Formatting
  • Chart
  • KPI (Key Performance Indicator)
  • Spatial Intelligence
  • Filter: Basic and Advanced
  • Top 10
  • Slicer
  • Drill Through
  • Publishing to the Web
  • PDF

Am I Ready?

You don’t need any prior knowledge of Power BI to come on this course.

It is helpful if you have completed our Excel Advanced level course, or have equivalent experience.

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 administrator and power suer. Learn to create dashboards and reports, use it for data storytelling and manage data governance and security.

  • Measures & calculated columns
  • Creating & optimising reports
  • Drill-through & date reports
  • Design best practice
  • Automatically updating data
  • Security, permissions & ChatGPT

Overview

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

  • Measures & calculated columns

  • Creating & optimising reports

  • Drill-through & date reports

  • Design best practice

  • Automatically updating data

  • Security, permissions & ChatGPT

Full Syllabus

  • 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 & Optimising 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.

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 Introduction to Power BI course or have equivalent experience.

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