Power BI Fundamentals (Online)

online2%20%282%29.jpg

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

Online

Session information

Sessions

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

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

          Online

          Session information

          Sessions

          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

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

                  Online

                  Session information

                  Sessions

                  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

                          Description

                          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