Power BI Training Courses in Manchester
Award-winning, small, friendly Power BI courses in Manchester, online & across the UK.
Hands-on training using real-world example for all levels from beginner to advanced
All courses CPD certified and include 6 months post-course support.
Learn how to transform raw data into actionable business insights.
Rated: Exceptional since 2013
Over 1,500 external reviews
-
Microsoft Partner-Learn with experts -
CPD Certified-Validated by specialists -
Rated Outstanding-14 years in a row -
Moneyback Guarantee-100% Peace of mind
Our Power BI Training Manchester Courses
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
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
Download full course details
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
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.
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.
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
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
- 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.
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
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.
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.
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.
Easy booking & payment
Money back guarantee
Post-course support
Power BI Manchester Training FAQs
For General FAQs and Booking questions, see our FAQ Page.
Claire Caple – Microsoft 365 Adoption & Change Manager – Rennie Grove Peace
“Alpesh was very knowledgeable, and I was confident in his training from the start.
He was enthusiastic and excited to help us get to know the software.
Alpesh gave us useful tips, everyone was comfortable and asked questions throughout.
We all took away ideas and felt able to start using Power BI immediately.”
The Client:
Rennie Grove Peace Hospice (Rennie Grove Peace) is a palliative care and bereavement support charity working in Buckinghamshire and Hertfordshire.
It was formed from the merger of Rennie Grove Hospice Care and Peace Hospice Care in 2022 and employs approximately 300 people across a range of functions spanning from fundraising and training to palliative care.
The Problem:
Rennie Grove Peace wanted to upgrade its business analytics capability and make better use of their data across the organisation.
Having decided that Power BI would be the best solution, team members from their fundraising, marketing, clinical reporting and IT teams wanted to learn how to use Power BI to analyse and present their data.
The Solution:
Rennie Grove Peace ultimately decided that a private Power BI course at their offices would meet their needs best.
Doing this was more cost-effective than attending public courses, saved on staff travel time and allowed the training to be focused on their exact requirements.
The Outcome:
A private one-day introduction to Power BI course was run at Rennie Grove Peace’s offices.
Everyone left having learned a huge amount about Power BI and ready to start putting it into practice.
After the course, each attendee was tasked with sharing what they learned with their department to broaden the organisation’s understanding of Power BI.
Our Power BI introduction training course is for complete beginners, you do not need any previous experience with Power BI to attend.
It is designed for people who will be:
- Using complex dashboards and reports which have been prepared by other analysts
- Creating simple data visualisations from scratch.
- Going on to attend our Advanced course and need to master the basics.
By the end of this course, you will be able to:
- Connect to a range of data sources using Power BI
- Prepare and transform your data.
- Create data visualisations like KPIs and charts.
- Publish reports that you have crated via the web or PDF.
This course gives you a high-level overview of Power BI and introduces basic best practices and its drag and drop functionality.
Our advanced training course is for people who are already Power BI users and want to develop their skills further.
It is designed for people who will be creating complex dashboards and reports from scratch.
By the end of this course, you will be able to:
- Customise a report.
- Use the query editor to interrogate the data in a data model, data relationships and hierarchies.
- Build interactivereports like drill-through reports and relative date reports.
- Creating a wide variety of compelling visualisations including maps, bullet and scatter charts.
- Set security and data permissions, and control when your data is updated.
We provide certificates of completion to everyone who completes one of our Microsoft Power BI programmes.
Our training is not an official PL-300 Microsoft Power BI Data Associate course, however, taken together our courses cover the vast majority of the syllabus and so would work very well for someone working towards that certification.
We have mapped our training in detail against the official Microsoft PL-300 exam syllabus, please contact us if you would like more details.
You do not need to be an advanced Power BI user to attend our introduction to DAX course.
The pre-requisite to attend is that you are comfortable using Power BI and understand it to at least the level that you would if you had attended our Introduction course.
This course covers creating basic DAX formulas using M langugage.
Power BI is Microsoft’s data analytics and business intelligence platform.
It allows you to connect to hundreds of data sources, prepare data, and create beautiful, interactive reports and dashboards converting raw data into easily actionable insights.
It was launched in 2014 and its main competitors are data tools like Tableau, Google Data Studio and Qlik.
It comes in a range of versions from Power BI Desktop which is free through to Power BI Premium which is a full enterprise business intelligence solution hosted in the cloud.
Microsoft Excel is widely used as a general purpose tool for all sorts of calculations and simple data management.
Power BI is a business intelligence platform designed specifically for data analytics and visualisation for large volumes of data which Excel could not handle. It allows users to very quickly and simply share data and business insights across their organisation.
Power BI toolkit is comprised of several key components:
1. Power Query: A data extraction and transformation tool used to connect to, clean, and shape data in Power BI Desktop.
2. Power Pivot: An in-memory data modeling component that allows for the creation of relationships between data tables.
3. Power BI Desktop: A free tool for building for analysing your data, building data models and designing reports.
4. Power BI Service: A cloud-based service for publishing, sharing (inc via mobile app) and collaborating on reports and dashboards.
5. DAX (Data Analysis Expressions): A formula language with a library of functions and operators. It allows you to create custom calculations, measures and calculated columns, and usee complex logic to derive deeper insights.
Power BI can connect to a wide variety of data sources, including Microsoft Fabric, Excel files, SQL Server databases, SharePoint lists, and online services like Google Analytics and Salesforce allowing you to bring all your data together in one place.
A Power BI report is a multi-page collection of visualisations and data created from a single dataset.
A dashboard is a single-page interface that provides a high-level overview of key metrics, with visualisations, drawn from multiple reports.
Where Do You Run Your Courses In Manchester?
Manchester Training Centre (Power BI Training)
Oxford Court
Manchester, M2 3WQ
Tel: 0161 821 1384
Manchester, M2 3WQ
Tel: 0161 821 1384
See the full Manchester Training Centre location details here.
- Facebook: https://www.facebook.com/profile.php?id=100066814899655
- X (Twitter): https://twitter.com/AcuityTraining
- LinkedIn: https://www.linkedin.com/company/acuity-training/