Power BI Training Course

Duration :2 DaysCost: From £595
Venues :Online | Manchester | Birmingham

Power BI Dashboard - training course

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

google-logo.jpg
5
  • 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

google-logo.jpg
5
5
You may also be interested in
  • Advanced Excel Course

    advanced-excel-banner small-min.jpg 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

    Sharepoint for Admin thumb.png 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

    SharePoint End User Training.jpg 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

    Google analytics training tn.jpg 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.
    Find out more
PEOPLE THAT HAVE ENJOYED OUR COURSES
  • AZ 2.png
  • BC 2.png
  • brother.png
  • chanel 2.png
  • coop manchester 2.png
  • liverpool training 2.png
  • Manchester City training 2.png
  • nestle training 2.png
  • barclays-course.png
  • skym-courses.png (1)
  • clientlogo-manchester.png
  • client logo leeds.jpg
  • manchester-training-client-logo4.jpg
  • leeds-training-client-logo3.png
  • PTL-Manchester-training-client-logo-200.png
  • Manchester client logo 8.png
  • nhs-logo.png (1)
Head Office: Unit 40, Greenheys, Manchester Science Park, Pencroft Way, Manchester, M15 6JJ Birmingham Office: Innovation Birmingham, Faraday Wharf, Birmingham B7 4BB Tel: 0121 648 2222
Click here to sign up for offers, advice and industry news Sign Up