Microsoft Power BI Fundamentals Course

Fundamentals Course Overview

Our 2-day Microsoft Power BI Fundamentals training course is the perfect introduction to using Power BI and has been designed for beginners. It can be booked as either online training, as a public course in London , or as a private course at your premises.

Call us on 0800 0199 746 to enquire or use our contact form to submit your details and we’ll get back to you as soon as possible.

During the course you’ll get a comprehensive overview of all the features and functions of Power BI that allow you to stay up to date with the information that matters to you. You’ll also come away with the skillset to design powerful interactive dashboards and reports that can be shared with colleagues and accessed via Power BI Mobile apps.

If you have already attended this course or feel you are ready for further training to improve your knowledge, consider booking our Advanced Power BI training course.

Book now

Our courses are available to book now on the following dates. It’s recommended to book in as early as possible as spaces do fill out quickly. If you have any questions, please call us on 0800 0199 746.

This course is run in London at CitizenM, Lavington Street London SE1 0NZ, or as a public, online instructor led course. If you require a private or bespoke course for your team, please contact us to arrange

What is Power BI?

Power BI is a cloud-based business analytics service that gives you a complete view of your most critical business data. You can generate powerful insights into your data by creating rich interactive reports with Power BI Desktop and then publish your reports to the cloud using PowerBI.com.

Public Courses

  • 28th Sep 2021 - 2 Days - CitizenM, Lavington Street, London SE1 0NZ - £620.00 + VAT per person

    Book Now
  • 7th Oct 2021 - 2 Days - Instructor Led Online Course - £ 595.00 + VAT per person

    Book Now
  • 13th Oct 2021 - 2 Days - CitizenM, Lavington Street, London SE1 0NZ - £620.00 + VAT per person

    Book Now
  • 9th Nov 2021 - 2 Days - CitizenM, Lavington Street, London SE1 0NZ - £620.00 + VAT per person

    Book Now
  • 6th Dec 2021 - 2 Days - CitizenM, Lavington Street, London SE1 0NZ - £620.00 + VAT per person

    Book Now
  • 11th Nov 2021 - 2 Days - Instructor Led Online Course - £ 595.00 + VAT per person

    Book Now
  • 9th Dec 2021 - 2 Days - Instructor Led Online Course - £ 595.00 + VAT per person

    Book Now

On-Site Courses

Who is this Power BI course for?

This course has been specifically designed for beginners to the Power BI application. Individuals, teams and departments can benefit from this introductory course to upskill and improve company-wide data analysis. This course is often booked by Business Development Managers, team leaders and professionals looking to learn more and further their career.

Prerequisites

As our main introductory course attendees require no prerequisites, nor a Power BI license as this is provided for the course. Designed for beginners, a knowledge of Excel, Pivot Tables and functions like SUMIFS and VLOOKUP are useful but not required.

What’s included?

  • Two fully qualified, expert Power BI trainers
  • Access to the latest Power BI license for the course
  • Laptops and equipment
  • Central London training room
  • In-course handbook
  • Free fast WiFi
  • Lunch, unlimited hot drinks and water
  • Ongoing support from your trainers

What do you need to attend the online course?

  • A good internet connection
  • An internet enabled device
  • A comfortable place to learn
  • The desire to upskill

Power BI Fundamentals Training Course London Outline

What does our fundamentals course cover? Whilst each session tailors to the attendees and has a Q&A element, our trainers will include the following to ensure you learn everything you need at this level to go away and use Microsoft Power BI productively.

What is Microsoft Power BI?

  • Understanding the components of Power BI: - Power Query, Data Modelling, Visualisations and Service.

Visualisations using Power BI Desktop

  • Exploring Power BI Desktop.
  • Connecting to a certified Dataset.
  • Creating a variety of visualisations.
  • Using the Formatting and Analytics options.
  • Looking at the Slicer visual to filter data.
  • Controlling interactions between visualisations.
  • Creating and using Hierarchies and Drilldown.
  • Using the Filters Pane.
  • Understanding Implicit Measures.
  • Controlling summarisation.
  • Use “ask a question” to generate visualisations.
  • Mapping geographic data.
  • Working with Custom visuals.

Publishing to Power BI Service

  • Publishing your Reports to PowerBI.com.
  • Creating and Customising Dashboards.
  • Sharing Reports and Dashboards with others.
  • Using Q & A for interactive data searching.

Connecting Services to Power BI

  • Connecting to a variety of cloud-based data sources including OneDrive, Google Analytics, Salesforce etc.

Creating a Data Model in Power BI

  • Importing a variety of data sources into Power BI.
  • Using Model View.
  • Creating and managing relationships.
  • Understanding the Star Schema.

Creating Measures using DAX

  • Understanding what Measures are.
  • Introduction to Filter Context.
  • Working with a variety of simple DAX functions: - SUM, AVERAGE and COUNTROWS

Using Power Query in Power BI Desktop

  • Understanding the role of Power Query in data import.
  • Cleaning and filtering data.
  • Exploring a variety of data transformations.

Power BI Licencing

  • Understanding the different Power BI licences.
  • Differences between Pro and Premium licences.

App Workspaces

  • Using Workspaces.
  • Using organisation Apps.
  • When to use Workspaces and Apps.

Data Refresh

  • Types of data refresh.
  • Manually refreshing data.
  • Requirement for a Gateway.
  • Scheduling automated refresh.

Using Power BI on Mobile Devices

  • Using Power BI on Smartphones and Tablets.
  • Features and functions of the mobile client.

We’re proud to have trained

Fatface CPJ Field & Co
Hornby Liverpool Victoria
RNLI Cash Converters
Targus Infinis
Lancashire Constabulary OCS
Hanon Carole Nash
Isle of Man Constabulary Informa
Sussex Chamber of Commerce DDD Limited
Ioma Group DW Windsor
Hadley Group Nyetimber
Aspen ECI
Higgidy Capespan
Experis Gatwick Diamond
Civil Aviation Authority Premium Choice
Creative Skillset CMS
Ofqual Lamp
Coats Sabien
Doughty Hanson & Co Campaign to Protect Rural England
Wiley Riverstone
The Cavendish Propellernet
Bradford District NHS Care Trust Hills
Wired Sussex Adur District Council
Specsavers University of Kent
Savills Combat Stress
AJW Aviation Plasa
HR Services Partnership Spellman
AXA Assistance HgCapital
Chichester District Council Mid Sussex District Council
Lewis Silkin Nominet
MPL Ammeraal Beltech
Downlands EDF Energy
Royal Academy of Dance Canterbury Christ Church University
Leonard Cheshire Disability Thomas Eggar
Chandlers Building Supplies Designate
Cemex Radix
Institute of IT Training Guttridge
Cmed National Youth Agency
Long Tall Sally Fatface
Envitia Londonwide LMCs
Beacon

Book this introductory Power BI course privately

As an experienced training provider we understand that each business’s requirements and goals are nuanced. To cater to all businesses and knowledge levels, this course is available to book on a private, onsite basis.

Call us on 0800 0199 746 or email [email protected] to arrange a training course at a date and time to suit you and your team, Taking place on your premises, we still provide everything needed to run and attend the course, including the latest Power BI license,

To get the best out of this course we recommend a maximum of 10 attendees although more can be accommodated if required. Whilst our public courses are all located in London, private courses can be booked across the UK.

Enquire or request a quote

Don’t hesitate to speak with us today about your requirements and for us to answer any questions about any of our Power BI training courses. We’re more than happy to discuss special requirements as well as consultancy on an ongoing basis, which can be incredibly helpful to companies rolling out Power BI for the first time.

Get in touch
  • This field is for validation purposes and should be left unchanged.