Power BI Desktop Course Overview
Our three-day Power BI course for the Desktop version of the software is intended for students who need to harness all the capabilities of the Power BI Desktop platform in order to build self-serviced business intelligence solutions.
The Microsoft Power BI Desktop training course is an instructor-led event which will be conducted either on-site at your premises or as a live virtual classroom event via MS Teams. We will provide all courseware and reference materials electronically to use for reference.
This is a three-day course covering best practices for Power BI Desktop's data modelling functionality. Power BI is a suite of business analytics tools used to analyse data and share insights. Power BI Desktop transforms enterprise data into impressively rich visuals for you to monitor your business and get straight answers and powerful insights quickly with rich reporting dashboards available for every device.
Email us or call 0844 493 3699 to find out more about booking Power BI training for your team.
Power BI Desktop Training Course Prerequisites
No previous knowledge of Power BI is required to attend this course. Students should have a good level of familiarity with Microsoft 365 and at least a basic understanding of the concepts of reporting upon and querying data. An understanding of Microsoft Excel or similar would be useful in this regard.
PDF Course Outline
On-site Power BI Desktop Training
These are corporate in-house training courses conducted at your workplace for small groups and are exceptional value and very popular. You will usually need to book at least one month in advance and the maximum number of learners is eight per course.
Our 'face-to-face' closed courses for Power BI are delivered as private courses for your delegates offering more flexibility than off-the-shelf public courses and topics taught can often be tailored to match your learning needs. One of our trainers will discuss your training requirements with you prior to the course.
Our trainers can attend anywhere in mainland UK (for overseas requirements, please enquire). On rare ocassions travel supplements may apply for Power BI training in Central London to cover additional expenses such as congestion charges, but we will endeavour to waive these when possible.
Live Virtual Classroom Power BI Desktop Courses
If you have a group of staff that you would prefer to be tutored remotely rather than having a trainer come out to you these small-group Power BI courses are also available Online as live virtual, interactive training sessions from the comfort of your own office or workplace. These live, instructor-led virtual courses are taught via Microsoft Teams.
Why choose virtual learning? As we are all becoming more used to Online learning and live virtual meetings it has become apparent that the virtual classroom method of delivery has many advantages over traditional face-to-face learning venues.
If you are looking for local training near you, then you can't get any closer to your doorstep than you can with virtual learning.
For live virtual Power BI training the maximum number of learners is eight per course and you can benefit from full and immersive interaction with your trainer just as if they were in the classroom with you, with engaging hands-on training via advanced live video conferencing that is further enhanced by features such as live chat, private chat, and sharing screens and documents.
You can find out more about live virtual classroom Power BI training delivered across Microsoft Teams video conferencing here: Learn More About Virtual Training with MS Teams.
Three Day Microsoft Power BI Desktop Training Course Cost
This course is charged at £2,400.00 plus VAT and is available at this price for anywhere between one and six delegates. There is also a charge of £125.00 per day to cover the instructor's accommodation and travel costs to anywhere within the UK (for long distances travel time charges may also apply). If you have additional delegates you can add them for £50.00 plus VAT per person per day up to a maximum of 8 in total.
Please note that for tailored Power BI courses, we can only provide you with a quote for training and courseware once we have evaluated your requirements.
Also see our one-day Power BI Online training course.
Our Power BI Trainers are:
Specialist educators with a wealth of experience and expertise, proven track records and excellent feedback.
Our Closed Power BI Courses are:
Flexible instructor-led courses catering to YOUR specific learning needs and training requirements.
Education is Our Passion:
Over 18,000 students trained across almost every industry, sector and background.
Call 0844 493 3699
Or email info@foursquaretraining.co.uk
Commercial and Corporate Power BI Desktop Courses for the Public and Private Sectors
How Many People Should Attend Our Private Power BI Courses?
Whilst the number of people who attend our private Power BI courses is essentially up to you and dependant upon the number of learners you have who need to receive the training (up to our eight delegate per course maximum), we encourage all of our clients to keep your class sizes small where possible and recommend a maximum of eight learners for technical courses such as Power BI. This provides a more personable and effective learning experience for you and allows the trainer to give more individual attention to each and every student.
What is the Teaching Method for Our Power BI Courses?
The teaching method for our private Power BI courses is Instructor-led training (ILT), which means that our courses are engaging, immersive, hands-on and interactive, and thereby facilitate more effective learning and information retention. With this participatory learning method your staff will retain information better, whether they are studying Power BI subjects in-person or via live virtual classroom. And, whilst we are happy to provide lectures, demonstrations and show-and-tells for larger groups (plus drop-in surgeries for ad hoc technical advice and explanation), the instructor-led training approach is by far the most reliable teaching methodology to bring your Power BI know-how to life in a small-class-size setting.
How Long are our Power BI Courses?
Usual teaching hours for our Power BI courses are 9.30AM to 4.30PM with an hour for lunch and two short breaks morning and afternoon. This timetable is fairly standard across UK training providers and gives six hours of hands-on Power BI learning, which is an optimal day's training when it comes to comfortably absorbing knowledge, undertaking practice exercises and retaining information.
If you need an earlier or later start time for your course please let us know and we will do our best to accommodate you.
Courses are delivered week days, Monday to Friday during normal business hours.
More About Our Power BI Desktop Training Delivery Method for Closed Courses
- Step-by-Step Courses: Instructor-led Power BI training provided in-person with step-by-step demonstrations, lessons and hands-on exercises.
- Q&A courses: Dynamic and interactive Power BI courses with plenty of time for questions and answers.
- Flexible Courses: Professional tuition that's tailored to match your team's present knowledge level and learning needs, and covering the Power BI Measures, features and techniques that your trainee staff, co-workers or employees need the most.
- Small Class Sizes: Private, Power BI training for small group sizes with a maximum of 8 learners on any course.
- Scalable Courses: Can be run as a single course, tutorial or workshop; Or as a training rollout bringing whole teams, departments and organisations up to the benchmark level of Power BI knowledge and confidence that you require.
Microsoft Power BI Desktop Training Course Outline
- Lesson 1 – Power BI Desktop Introduction
- Get the Power BI Desktop
- Power BI Desktop Overview and Terminology
- Imports
- Visualisations
- Filters and Queries
- Reports
- Lesson 2 – Power BI Data Sources
- Power BI Desktop Compatible Data Sources
- Get Data and Query Editor
- Direct Query vs Import Data
- Defining Hierarchies based on a single Table
- Set up and Manage Relationships between Tables
- Use Append Queries
- Merge Data Tables
- Lesson 3 – Power BI Visualisations
- Creating Visualisations
- Colour Formatting
- Setting Sort Order
- Scatter and Bubble Charts
- Slicers, Timeline Slicers and Sync Slicers
- Cross Filtering and Highlighting
- Visual, Page and Report Level Filters
- Drill Up, Down and Through
- Hierarchies
- Reference / Constant Lines
- Tables, Matrices and Conditional Formatting
- KPIs, Cards and Gauges
- Map Visualisations
- Custom Visuals
- Custom Report Themes
- Grouping and Binning
- Selection Pane and Bookmarks
- Lesson 4 – Querying Data with Power BI
- Query Editor
- Filters and Delimiters
- Transforms
- Pivot and Group By
- Creating Custom Calculated Columns
- Adding Conditional Columns
- Introduction to Data Analysis Expression (DAX)
- Histograms
- Lesson 5 – Reports and Exports in Power BI
- Personal vs App Workspaces
- Power BI Service
- Report Elements and Options
- Working with Pages
- Adding Graphics
- Report Level Filters
- Report Themes
- Export Power BI Data to CSV
- Create a Power BI Template
- Lesson 6 – Sharing Content in Power BI
- Sharing Dashboards with internal and external users
- Sharing content with Microsoft 365 groups
- Creating Power BI Apps
- Consuming Power BI Apps
- Using Publish to Web with Dashboards
- Lesson 7 – The Power BI App
- Supported Platforms
- Creating Dashboards for Mobile devices
- Accessing Reports and Dashboards from Mobile
- Lesson 8 – Data Analysis Expression (DAX)
- DAX Overview
- DAX data types and operators
- Common DAX functions
- Referencing other tables in DAX
- Using CALCULATE
- EARLIER and EARLIEST
- Lesson 9 – The Power BI Gateway
- Power BI Personal Gateway
- Working with OneDrive
- Working with SharePoint Lists
SharePoint Online Courses & Power Platform Courses
- Microsoft 365 Master Class
- course duration - tailored
- Introduction to Microsoft 365 for Users
- course duration - four days
- Introduction to Microsoft Viva
- course duration - one day
- Introduction to SharePoint Online for End Users
- course duration - one day
- SharePoint Online for Site Owners & Administrators
- course duration - two days
- SharePoint Online for Site Collection Administrators
- course duration - five days
- SharePoint Online Power User
- course duration - two days
- Power Platform Master Class course
- course duration - five days
- Microsoft Power Automate Introduction
- course duration - two days
- Microsoft Power Automate Advanced
- course duration - two days
- Microsoft Powerapps Introduction
- course duration - two days
- Canvas Apps for Powerapps Training
- course duration - three days
- Microsoft Power BI Online Training
- course duration - one day
- Microsoft Power BI Desktop Training
- course duration - three days
- Power BI Beginners Training
- course duration - one day
- Power BI Intermediate Training
- course duration - two days
- Power BI Advanced Training
- course duration - three days
- Power BI Masterclass
- course duration - four days
- Power Apps and Power Automate Combined Training
- course duration - four days
- Microsoft Dataverse Beginners
- course duration - three days
- SharePoint Consultancy
- duration - bespoke
- SharePoint Governance Training
- course duration - two days
- Planning and Implementing a SharePoint Strategy
- course duration - one day
☆ ☆ ☆ ☆ ☆ Five Star Review
Very Knowledgeable
SharePoint Training Chester
More like this...
On-Premise SharePoint Courses
- SharePoint for End Users
- course duration - one day
- SharePoint Power Users
- course duration - four days
- SharePoint Server Administrator
- course duration - three days
- SharePoint Designer
- course duration - three days
- SharePoint Developer
- course duration - five days
- Using InfoPath Forms in SharePoint
- course duration - two days
- SharePoint Enterprise Site Design Solutions
- course duration - two days
- SharePoint for Site Collection Administrators
- course duration - two days
- Planning and Implementing a SharePoint Strategy
- course duration - one day
- Using Visio in SharePoint
- course duration - one day
☆ ☆ ☆ ☆ ☆ Five Star Review