Power BI Training Course
Duration :2 DaysCost: From £595
Venues :Online | Manchester | Birmingham
Power BI Training Course
Learn how to use Power BI to create dynamic, interactive visualisations of your business data on this 2-day course.
Power BI Course Introduction
This two-day course will provide you with the skills you need to create useful, dynamic, interactive reports that visualise your data using Power BI dashboards.
These visualisations can be used to provide insights that will help your business improve its performance.
Who should attend this Power BI course?
This course is designed for anyone with responsibility of creating reports using organisational data.
Ideally, you should have some knowledge of Excel and Office 365.
Power BI Course Topics
Introduction to Power BI
Including the ways in which you can use Power BI to create insightful reports, the limitations of Power BI and the licensing options.
How to create Data Sets for a Report
This topic includes how to connect different data sources to Power BI and how to combine them within your reporting. It also includes editing Data Queries.
Visualising the Data
In this module, you will cover how to create a variety of charts, maps, tables, cards, and matrices to visualise your data.
Creating Multiple Page Reports
During this module you will learn how to create multiple page reports and the use of filters and when to use a filter.
Publishing & Sharing Reports
This module will cover the publishing and sharing of reports and how you can automate scheduled reports.
Creating Dashboards
Once you have mastered reports we will cover the creation of Dashboards in Power BI and how these can be used and shared.
Using DAX (Data Analysis Expressions)
In the final module we cover the use of DAX including measures, calculated columns, using DAX in dynamic reports and some advanced DAX features.
Why choose M Training's Power BI Course
- Run by a highly experienced Microsoft 365 and Power BI consultant and trainer
- This course is limited to 6 places so you are guaranteed personal support throughout the course
- Held at our head office in Manchester, our Birmingham office or Online
- Private courses available throughout the UK
- Course notes and support material provided
- Lunch and refreshments provided
- Certificate of achievement
-
6 No more than 6 delegates
-
5 star rated courses
-
Online Courses Available
-
Convenient Locations
-
Tailored Course Content
For dates and prices of our Public courses please select the name of the city, or Online, below. For Private courses please select the private course tab above.
Private Power BI Training
We are happy to run private Power BI courses at your offices, at our Manchester office, or at a venue to suit you.
The course content can be adapted to suit your requirements. Our trainer will contact you to discuss what you are looking to achieve and the level of prior knowledge the delegates have.
Private Power BI courses are ideal if you have a number of people to train, or you want a different course outline; or simply can't make the dates of the public scheduled courses.
Private classroom-based courses are available from £690 plus VAT
Private Online Power BI courses are available from £450 + VAT (6 Hours).
To get a quote please complete the form below or call us on 0161 226 6032.
Private Power BI Course Enquiry
Power BI Training Course Outline
-
Introduction to Power BI
- Power BI Programs
- Licensing options
- Limitations of Power BI
- Compatible Data Souces
-
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
-
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 Charts
- Scatter Charts
- Treemaps
- Maps / Filled Maps / ArcGIS Maps for Power BI
- Funnel Charts
- Gauge Charts
- Slicers / Cards & Multi-Row Cards
- KPI Metrics
- Tables and Matrices
Customising the Visualizations you have created -
Multiple Page Reports
- Creating Multiple Pages for your Power Bi Reports
- How to use Filtering
- When would you a Filter
-
Publishing & Sharing
- Publishing a Reports
- Sharing the Report
- Scheduling Refreshes
- Embedding a Report
-
Power BI Dashboards
- Creating a Dashboard
- Adding Tiles to a Dashboard
- Sharing a Dashboard
-
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
Online
The timings of our online courses vary and because we only have 6 delegates on these courses we can be flexible.
The standard timings for the Power BI Online course are as follows:
9.15am | Sign in - to check everyone is up ad running on the software (MS Teams)
9.30am | Start - First session
11.00am | 15 min break
11.15am | Second session
12.45am | 45 min break
1.30pm | Third session
3.00pm | 15 min break
3.15pm | Fourth session
4.30pm | Finish & Q&A
4.45pm | End
Manchester
Our Manchester Venue:
Private Outlook courses can be held at your offices or our Manchester training venue.
The courses run 9.30am to 4.30pm at:
Greenheys Business Centre
Manchester Science Park
Pencroft Way
Manchester
M15 6JJ
Public Transport/Parking:
Free visitor parking is available at car park at the front of Greenheys building.
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
Birmingham
Our Birmingham Venue:
Our public Google Analytics courses in Birmingham are usually ran from 9.30 am to 4.30 pm at:
Innovation Birmingham,
Faraday Wharf,
Holt Street,
Birmingham,
B7 4BB
Public Transport /Parking:
Parking is available at Faraday Wharf and is located on Love Lane off Holt Street. Please note that parking here is charged and subject to availability.
Both Birmingham Snow Hill and Birmingham Moor Street rail stations are situated just a short 15-minute walk away from the Innovation Birmingham Campus.
More Information about our Birmingham training courses, along with a map, can be found on our Birmingham Training page
-
Find out more
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. -
Find out more
SharePoint for Administrators Course
This is a 1 day Training Course for Administrators to learn the skills to Design, Create and Manage their own SharePoint sites -
Find out more
SharePoint For End Users Course
This is a 1-day course for End Users of Sharepoint to learn how to create pages, manage documents & much more to help you get the most out of the platform -
Find out more
Google Analytics
This is a one day training course that will give you a good understanding of how to set up Google Analytics, how it works and what data you can obtain. In addition, it provides guidance on how to use the data to improve your website performance and your marketing.
Catherine Powell, NCC Group