Power BI: Fundamentals


Delivered live online over Zoom, our two-day Microsoft Power BI Fundamentals training course is the perfect introduction to using Power BI

2 days, 10:00 AM - 04:30 PM


Session information


Session 1
10:00 GMT - 12:30 GMT
2 hours, 30 minutes
    Session 2
    14:00 GMT - 16:30 GMT
    2 hours, 30 minutes
      Session 3
      10:00 GMT - 12:30 GMT
      2 hours, 30 minutes
        Session 4
        14:00 GMT - 16:30 GMT
        2 hours, 30 minutes
          • £595.00 excl. VAT


          The first thing to say about our live online Training is that it’s not a webinar or video. You will connect live with us and we’ll run the course using Zoom so you can see and chat with us. With these tools we’ll be able to share our screen view with you and use online chat, polls and discussions to create an interactive learning environment. You’ll be able to ask questions, get us to explain or go back over points again as required.

          We’ve split our Power BI course up unto four segments outlined below. Before and after the online segments you’ll have access to all the training files and resources used in the course. At the end of the course we’ll provide the video recording of all the online sessions and you’ll still be able to ask questions over email as you start to use the skills learned in the training

          To get the most from this course

          The minimum requirement is to have a Laptop or PC and an internet connection! You can check your computer and internet is good enough for the online classroom by going to Zoom.us/test and trying the test meeting there. Additional refinements would be a headset and a second screen, but these are optional. You’ll probably also want to install Power BI Desktop if you don’t already have it on your machine and get a Power BI licence (Either Free or Pro). Other than that, you’ll need to be able to put the time aside when the sessions are running, ideally in a quiet space so you can concentrate. Our sessions are really interactive and you’ll be expected to interact, react and take part in the training.

          What this course will do for you

          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.

          What you will learn

          Session 1/Day 1 - 10:00am to 12:30 pm

          What is Power BI ?

          • Visualisations Using Power BI
          • Creating a variety of visualisations
          • Formatting and Analytics Options
          • Looking at the Slicer visual
          • Using Hierarchies and Drilldown
          • Using the Filters Pane
          • Working with Custom Visuals

          Session 2 / Day 1 - 2:00pm to 4:30pm

          Power BI Service

          • Publishing PBIX, XLSX and other files
          • Publishing differences
          • Sharing Reports & Dashboards

          Working with Table Visuals

          • Understanding Implicit Measures
          • Controlling Summarisation Options
          • Working with the Data Model
          • Creating and managing Relationships.

          More Visualisations

          • Mapping you data

          Session 3/Day 2 - 10:00am to 12:30 pm

          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 & Excel

          • Understanding the role of Power Query
          • Cleaning and filtering data
          • Exploring a variety of data transformations
          • Understanding the Load options in Excel

          Session 4 / Day 2 - 2:00pm to 4:30pm

          Power BI Desktop & Service in Context

          • How all the elements of Power BI work together

          Power BI Service

          • Dashboards
          • Q&A and Ad Hoc Queries
          • Distributing & Sharing Dashboards and Reports
          • Workspaces & Power BI Apps
          • Refreshing & Managing Reports and Apps

          Smartphone Interface