Power BI Training Course

  • 2 Days
  • Manchester | Liverpool | Online | In House

Learn how to use Power BI to create dynamic, interactive visualisations of your business data on this 2 day course.

Make an Enquiry/Booking

Choose a Public Course or Private Course below

From

£495 +vat
Make an Enquiry
  • Small class sizes
  • 5 Star Rated Course
  • Practical courses
  • 3 month support

2 Day Power BI Training

Our 2 Day Power BI course is designed for professionals who want to gain advanced skills in creating sophisticated reports and dashboards with Power BI.

Over two days, you will explore the full capabilities of Power BI and how to transform raw data into insightful visualizations that drive business performance.

This course will cover everything from the basics of connecting and preparing data, to advanced topics like creating dynamic reports, using Data Analysis Expressions (DAX), and building complex dashboards.

By the end of the course, you’ll have the expertise to create and share interactive Power BI reports that are clear, actionable, and tailored to your organization's needs.

Power BI Training Course Outline

  • Introduction to Power BI

    • Power BI Programs
    • Licensing options
    • Limitations of Power BI
    • Compatible Data Sources

     

    Multiple Page Reports

    • Creating Multiple Pages for your Power Bi Reports
    • How to use Filtering
    • When would you a Filter

     

    Power BI Dashboards

    • Creating a Dashboard
    • Adding Tiles to a Dashboard
    • Sharing a Dashboard
  • Creating a Data Set

    • The difference between a Data Set and a Data Source
    • Connecting to Data Sources
    • Linking Multiple Data Sources
    • Using Multiple Data Sources
    • Editing the Data Queries

     

    Publishing & Sharing

    • Publishing Reports
    • Sharing the Reports
    • Scheduling Refreshes
    • Embedding a Report

     

    DAX (Data Analysis Expressions)

    • Understanding DAX
    • What are calculated columns?
    • When and how to use a calculated column
    • What are measures?
    • When and how to use a measure
    • Using DAX in dynamic reporting
    • Advanced DAX features
  • Visualising your Data

    Creating visualisations from your data including:

    • Stacked Bar Charts / Stacked Column Charts
    • 100% Stacked Bar / Column Charts
    • Clustered Bar Charts / Clustered Column Charts
    • Line Charts / Area Charts & Stacked Area Chart / Ribbon Charts
    • Line & stacked column Charts / Line & Clustered Columns Charts
    • Pie Charts & Donut Charts
    • Waterfall ChartsScatter Charts
    • TreemapsMaps / Filled Maps / Arc
    • GIS Maps for Power BI
    • Funnel Charts
    • Gauge Charts
    • Slicers / Cards & Multi-Row Cards
    • KPI MetricsTables and Matrices
    • Customising the Visualizations you have created

Why Choose M Training

  • Small class sizes

    We run small classes so that there is more interactivity, opportunity for questions and is more personal.

  • Convenient Locations

    Public courses are held in Manchester, Liverpool and Online. Private courses can be ran anywhere in the UK. 

  • Course Materials

    Detailed course materials are provided for each delegate as well as post course notes

  • Expert Trainers

    Run by an experienced Microsoft trainer and consultant

  • Follow up support

    Along with the course notes, you also recieve 3 months email support for any follow up questions that you may have. 

  • 5 Star Rated

    Our courses are rated 5 stars by delegates, through post-course feedback forms, on Google and Facebook.

Who should attend this Power BI course?

This course is perfect for professionals who are responsible for creating and sharing business reports using data.

Whether you’re a business analyst, data analyst, manager, or executive, this course will provide you with the skills necessary to build interactive, data-driven reports and dashboards.

This course is ideal for those with some familiarity with Power BI, but no prior experience is required, as we will cover all the fundamentals..

Familiarity with Excel and Office 365 will help you maximize your learning during this course.

If you are looking at just creating a quick dashboard with Power Bi take a look at the Power Bi Essentials 1 day course.

 

Power BI Course - 2 Day Topics

Over the course of two days, you’ll gain hands-on experience with a range of essential Power BI features. Here’s a breakdown of the topics we’ll cover:

Introduction to Power BI
Understand the capabilities of Power BI and how it can transform your data into actionable insights. We'll also discuss the licensing options and limitations to ensure you're using the tool to its full potential.

Creating Data Sets for Reports
Learn how to connect to multiple data sources, combine them into datasets, and edit data queries. You'll also learn the difference between data sources and datasets, and how to manage large datasets effectively.

Visualizing Your Data
Master the creation of a wide variety of charts and visuals, including bar charts, line graphs, maps, and more. We'll teach you how to choose the right type of visual for your data to communicate insights clearly and effectively.

Creating Multiple Page Reports
Learn how to design multi-page reports and implement filters to display data effectively. Understand the role of filters in your reports and when to use them for optimal performance.

Publishing and Sharing Reports
Understand how to publish your reports to Power BI, schedule data refreshes, and share your reports with stakeholders. We’ll also cover embedding options to make your reports accessible across different platforms.

Building Dashboards
After creating reports, you’ll learn how to build interactive dashboards that summarize key data points and metrics. We’ll teach you how to add tiles to your dashboards and share them with others.

Using DAX (Data Analysis Expressions)
Gain an in-depth understanding of DAX to perform more advanced data manipulation. Learn how to create calculated columns and measures, and use them to enhance your reports with dynamic, real-time insights.

Download the full course outline

 

Power BI 1 Day Course Day Details

Our 5 star rated Power BI training courses are practical courses with small class sizes, a maximum of 6 delegates, which allows for plenty of time to interact with the trainer and ask any questions!

These are held as in-person classroom courses or as live, online courses (over Zoom). All courses, run from 9:30 am to 4:30 pm, with plenty of breaks.

Scheduled 2 Day Power BI Courses

Our scheduled public Power BI training courses are run in Manchester, Liverpool and Online. Dates for these can be found below.

Private / Bespoke Power BI Courses

We run private one to one and group Power BI Courses at our training centres, or at a location to suit you, anywhere in the UK. These can also be held Online.

Course Reviews

Lara had excellent knowledge of the [Power BI] subject and was very clear in her delivery. She allowed plenty of opportunities to ask questions which she answered fully

Ghazalla H
UK Parliament

Course Reviews

Trainer was extremely knowledgeable and created a relaxed but engaging environment.

Grace D
HarperCollins

Course Reviews

Rachel was a great teacher and was able to go through each [Advanced Excel] subject with us explaining in detail and was able to assist where needed with extra questions and help with assigned tasks to make things clear. Thank you

Nicola W
Expert Complete Property Maintenance Ltd

Course Reviews

Rachel was very personable and knowledgeable. I have already started to use some of the functions she demonstrated so I definitely think it will benefit me in my role. Thank you

Samantha S
Outwood Grange Academies Trust

Course Reviews

Excellent [Advanced Excel] training learned a lot from it and course was very well put together and informative.

Julian S
J & J Fire Engineering

Course Reviews

It was perfect and met my needs fully. Rachel was brilliant, a great trainer and very knowledgeable. I would highly recommend Rachel and M Training. I am planning to do more courses with them.

Torquil M
Star Brands Ltd

Course Reviews

Rachel was brilliant and very helpful. The way the [Advanced Excel] course was delivered was very easy to understand and Rachel answered any questions with detailed explanations.

Rebecca S
Tarnwest Ltd

Course Reviews

John was very informative and he explained why things are the way they are, not just how to do them. John went above and beyond to solve any issues and questions we had, even following up on these after the course was complete.

Lucy Lloyd
Aura Brands

Course Reviews

John was really helpful and engaging, made each section of the course [SharePoint] easy to understand and I really leant a lot. Thanks!

Lisa Scott
Bumble Bee Conservation

Course Reviews

It was an excellent [SharePoint] course and well delivered by Mike

Lee Evans
Choice Fire & Security

Public 2 Day Power BI Course Dates

Browse all public 2 Day Power BI course dates below or use the filter to show only dates in specific locations.

For other dates or for private courses please contact us on 0161 226 6032 or info@mtraining.co.uk

Enquire about a private course
Filter by venue:
  • Course Dates
  • Venue
  • 16 December 2025 - 17 December 2025
  • Online
  • View
  • 21 January 2026 - 22 January 2026
  • Manchester
  • View
  • 27 January 2026 - 28 January 2026
  • Online
  • View
  • 25 February 2026 - 26 February 2026
  • Manchester
  • View
  • 25 February 2026 - 26 February 2026
  • Liverpool
  • View
  • 03 March 2026 - 04 March 2026
  • Online
  • View
  • 26 March 2026 - 27 March 2026
  • Manchester
  • View
  • 31 March 2026 - 01 April 2026
  • Online
  • View
  • 08 April 2026 - 09 April 2026
  • Liverpool
  • View
  • 22 April 2026 - 23 April 2026
  • Manchester
  • View
  • 28 April 2026 - 29 April 2026
  • Online
  • View
Enquire about a private course

FAQs

  • Will I receive a certificate?

    Yes, all participants receive an M Training certificate of completion. This can be used for CPD records or as evidence of professional development in training skills.

  • Can I pay by invoice / PO?

    Yes. We provide an invoice for every booking. This will be emailed to you once the booking has been made, it contains our bank details, for payment by Bank transfer, along with a link to make payment Online with a credit or debit card.

    If you require to set us up as a supplier, that is fine, just let us know and we can provide you with all the information you need.

  • What's the difference between Private & Public Courses?

    Public courses are scheduled and open for anyone to book on to. There is a maximum of 6 delegates on our public course to ensure that everyone receives tailored training.

    Private Courses are courses that are arranged specifically for individuals or groups, no one else can book on to these courses. Private course content can be tailored to suit your requirements

  • Can I take these courses online?

    Absolutely. We offer live, instructor-led online versions of all courses. You’ll get the same expert guidance, interactive activities, and practical tools as the in-person sessions, just delivered virtually via Zoom or Teams.

  • How interactive are the courses?

    Our courses are highly interactive. You’ll take part in discussions, group activities, and practical exercises designed to build real-world training skills in a supportive environment.

  • Where in Manchester is this course held?

    All our courses in are run from 9.30 am to 4.00 pm at our head office:

    Manchester Science Park
    Pencroft Way
    Manchester
    M15 6LR

    Public Transport/Parking:

    The closest public park is Manchester Science Park Visitor Car Park or Cecil Street Car Park - 5 min walk

    Manchester Oxford Road Train Station - 15 min walk

    Manchester Piccadilly Train Station - 30 min walk

    Access

    Please let us know in advance if you have any mobility issues and will need any assistance. Disabled parking is provided.

    More Information about our Manchester training courses, along with a map, can be found on our Manchester Training Page

  • Where in Liverpool is the course held?

    The course in Liverpool is usually held at:

    The Plaza
    100 Hall Street 
    Liverpool
    L3 9QJ

    (subject to change)

     

    Parking

    There are several public car parks close to The Plaza.

    The closest are:

    St Paul’s Square Car Park: 0.02 Miles ~ 1 Minute Walk 

    NCP Liverpool Pall Mall Car Park: 0.2 Miles ~ 4 Minute Walk

     

    Public Transport

    We encourage all delegates to use public transport where possible.

    The Plaza is a 20 minute walk from Lime Street Station and a 4 minute walk from Moorfields train station.

  • How do the Online courses work?

    The Online courses are run on Zoom.

    You will be sent a link to join the training session the day before the course along with any course materials needed.

    The courses run from 9:30 am to 4/4:30 pm and follow the same course outline as the classroom courses and you will be able to interact with the trainer and group and ask questions.

    Because we limit the number of delegates to a maximum of 6 on our public courses specific timings are flexible, but generally, the day will run as follows:

    9.20 am | Sign in

    9.30 am | Start - First session

    11.00 am | 15 min break

    11.15 am |  Second session

    12.30 pm  | 30 min break

    1.00 pm  | Third session

    2.15 pm | 15 min break

    2.30 pm | Fourth session

    3.50 pm | Finish & Q&A

    4.30pm | End

    Find out more about how our online courses work on the Online Courses Page

  • How can advanced Power BI skills help my team make better business decisions?

    Advanced Power BI training teaches professionals to create dynamic dashboards, automate reporting, and consolidate data from multiple sources.

    This enables teams to uncover insights faster, monitor KPIs in real time, and make data-driven decisions with confidence.

  • What types of business problems can Power BI solve that go beyond basic reporting?

    Power BI can handle complex scenarios like trend analysis, multi-source data modelling, interactive KPI tracking, and scenario planning.

    A structured advanced course shows professionals how to design reports that reveal patterns, spot anomalies, and support strategic decisions.

  • Which advanced Power BI features are most useful for analysts and managers?

    Features like DAX calculations, calculated measures and columns, complex visualisations (waterfall, funnel, and maps), and multi-page dashboards allow analysts to create highly customised reports.

    These tools help managers track performance metrics and explore data in ways spreadsheets cannot.

  • Can learning advanced Power BI techniques save time and reduce errors in reporting?

    Absolutely. With advanced skills, you can automate data refreshes, create reusable report templates, and link multiple sources in a single dashboard.

    This reduces repetitive manual work, ensures data accuracy, and frees up time for analysis rather than data preparation.

  • How does advanced Power BI training help professionals grow in data analytics?

    Learning advanced Power BI features gives professionals a strong foundation in data modelling, interactive reporting, and calculation logic.

    These skills open up opportunities for deeper analysis, predictive insights, and strategic reporting roles within a business.

Other Courses You Might Be Interested In

1 Day Power BI Course: The Essentials

Learn the essential skills needed to create powerful reports and dashboards on this 1 day Power BI Course

£295
MORE INFO...

Advanced Excel Course

This is a one day training course that takes you through some of the more advanced features of Excel. It is designed for people who know the basics but want to extend their knowledge/skills in using Excel.

From £195
MORE INFO...

Power Query Course

One-day Power Query course to streamline Excel data tasks and improve reporting accuracy.

From £295
MORE INFO...

Intro to VBA in Excel

Learn VBA for Excel, build practical macros, and streamline business workflows with this 5 star rated practical VBA Training.

MORE INFO...
PEOPLE THAT HAVE ENJOYED OUR COURSES
  • AZ 2.png
  • Amazon
  • barclays-course.png
  • BC 2.png
  • Bt
  • Bupa
  • chanel 2.png
  • Jd Sports
  • Jet2com
  • Manchester client logo 8.png
  • Manchester City training 2.png
  • nestle training 2.png
  • Next
  • nhs-logo.png (1)
  • M Training Clients 10.png (1)
  • PTL-Manchester-training-client-logo-200.png
  • skym-courses.png (1)
  • client logo leeds.jpg
  • coop manchester 2.png
  • Tui
  • liverpool training 2.png
  • Siemens
  • Kraftheinz
  • HM Government
Manchester: Base, Greenheys Lane, Manchester Science Park, Manchester, M15 6LR
Leeds: West One, 114 Wellington St, Leeds, LS1 1BA
Birmingham: Innovation Birmingham, Faraday Wharf, Birmingham, B7 4BB
Liverpool: The Plaza 100 Old Hall Street Liverpool L3 9QJ
Click here to sign up for offers, advice and industry news Subscribe
Book this course