Power BI Advanced
Learn with Wales leading Microsoft Office training provider
Courses available on all Microsoft Office applications
Microsoft certified trainers with 5 Star customer ratings
Classroom, Onsite and Virtual courses available
Bespoke Microsoft Office training courses available
Welsh Government funding accepted
Duration: 1 Day
Accredited: Available upon request
Exams: N/A
Funding: Accepted
Type: Classroom, Onsite, Virtual
Company group booking discount availableCourse Information
Course Overview
In this Power BI Advanced level course delegates will explore advanced features of Power BI by utilising multistep calculations in DAX, visualisation and parameters.
After completing this course delegates will be able to:
- Build and use data hierarchies
- Use variables to create multistep calculations
- Set data parameters
Outline
Power BI Advanced
- Creating and Using Data Hierarchies
- Understanding Power BI Variables
- What is a variable
- Creating Variables
- Introduction to using variables in expressions
- Using AI Visualisations including
- Key Influencers
- Smart Narrative
- Decomposition Tree
- Creating a Data Set to access via Onelake Data hub
- Creating a Parameter Table and using Parameters
- Exploring Table functions
- Using Role-based security
Assessment
Power BI Advanced
There is no formal assessment for this course and learners knowledge will be tested with informal activities throughout the session. For accredited Microsoft Office training options please view our ICDL courses or contact us for further options.
What's Included
- 1-day training from NILC’s Microsoft certified trainers
- Microsoft Office 365 training account for learners to use throughout the course
- PDF Power BI workbook
- Recording from each training day (virtual-live courses only)
- Course completion certificate
Dates & Prices
Choose your location
Virtual
Start Date: Thu 21 December 2023
Spaces:Available
£350.00excl. VAT
Spaces:Available
Virtual
Start Date: Tue 30 January 2024
Spaces:Available
£350.00excl. VAT
Spaces:Available
Virtual
Start Date: Tue 27 February 2024
Spaces:Available
£350.00excl. VAT
Spaces:Available
Virtual
Start Date: Tue 26 March 2024
Spaces:Available
£350.00excl. VAT
Spaces:Available
Virtual
Start Date: Tue 30 April 2024
Spaces:Available
£350.00excl. VAT
Spaces:Available
Virtual
Start Date: Tue 28 May 2024
Spaces:Available
£350.00excl. VAT
Spaces:Available
Virtual
Start Date: Tue 25 June 2024
Spaces:Available
£350.00excl. VAT
Spaces:Available
Virtual
Start Date: Tue 30 July 2024
Spaces:Available
£350.00excl. VAT
Spaces:Available
Power BI Masterclass Bundle
Course Includes:
Power BI Introduction
Power BI Intermediate
Power BI Advanced
Total: £1,050.00excl. VAT
Bundle Price: £945.00excl. VAT (Saving £105.00)
Create your own
Looking to do 2 or more courses? Contact us to create your own bundle
Can't find the course dates, location or delivery type you are looking for?
Fill out the request dates form above and we'll try our best to accommodate or contact us directly.
Why choose NILC for your training?
Learn why we should be your training provider of choice.
Awarding Winning Training Courses with industry leading customer satisfaction rates
A family business with customer service at the heart of everything we do
Trusted Training Partner to multiple colleges, government departments, businesses and unions
UK based Trainers that are industry experts and fully qualified
Rated "Excellent" with over 500+ Trustpilot Reviews
How we deliver our courses
Virtual
Our virtual courses allow you to access live instructor-led training from the same expert instructors that deliver our classroom courses, without leaving the comfort of your home or office. All virtual courses are fully interactive, and learners can communicate with their trainer and peers at any time.
Many of our virtual courses are also recorded, so you can recap over the content you learnt as many time as you wish.
Classroom
Our classroom courses allow you to learn and interact face-to-face with our expert instructors in a comfortable and modern training environment. All of our classroom based courses take place at NILC centers, or high quality training facilities, and include all required IT and physical equipment.
We also limit our class sizes to help promote better discussions and to ensure your learning experience is comfortable as possible.
Onsite
Save time and hassle by arranging for one of our expert instructors to come to you. Our onsite courses allow you to learn in a location of your choosing, and you can train as many or as few people as you want – from a single person or team to whole departments. We can also fully customize the course content to the specific requirements of your business or project.
We offer onsite courses throughout the UK and it can be a great team building opportunity for colleagues to come together, bond and discuss.
Online
Our Online Self Paced courses allow you to learn new skills from our expert instructors, in your own time and at your own pace. Our flexible online learning platform allows you to access content on your computer, tablet or mobile device, whether you’re on the move or at home. All our online courses come with immediate access and you can start learning straight away, from any internet enabled compatible device.
We also offer online email support from our expert instructors, so they’re always on hand and happy to help you with any questions which may arise.
Why choose NILC for your training?
Learn why we should be your training provider of choice.
Awarding Winning Training Courses with industry leading customer satisfaction rates
A family business with customer service at the heart of everything we do
Trusted Training Partner to multiple colleges, government departments, businesses and unions
UK based Trainers that are industry experts and fully qualified
Rated "Excellent" with over 500+ Trustpilot Reviews
Testimonials
“Highly Recommended”
A complex course subject was delivered clearly and with great passion and enthusiasm by our tutor. Subjects were explained in clear, real-life examples. Without doubt, I'm sure my successful result is in large part due to his experience and skill in this area.
- Neil Wilson
“Fantastic Course Thank You”
Fantastic course. Amazing from start to finish. Julie was absolutely outstanding. She was professional and has given me the knowledge and confidence to continue my studies. I cant thank Karim and team enough.
- Jodie Gee
“Great Tuition"
Great tuition. Felt really comfortable to ask questions and the course was engaging. Tony and Karim were brilliant.
- Amy Jones
“Great Instructor”
Great instructor. Well delivered and knows the subject inside and out. Friendly and provides a warm atmosphere conducive for feeling relaxed. A lot of context to cover in a short time.
- David Schofield
“Five Star Quality Course”
I received all the resources in advance which helped me prep for the course. The tutor was engaging and explained complex topics really well. The exam coaching was a unique selling point for me as it got me prepared for the exams so that nerves were less of a factor. Great communication throughout, thank you Tony and the whole team.
- Kim Darkin
Microsoft Office 365 FAQ's
Are your Microsoft Office 365 courses accredited?
Our Microsoft Office 365 courses are focused around the key skills individuals and businesses require on a daily basis, so are not accredited. If you wanted an accredited course please contact us to discuss the options we have available.
Are your virtual Microsoft Office 365 courses recorded?
Yes all of our Microsoft Office 365 courses are recorded. Learners will receive a copy of the recording which was taken during their session at the end of the course.
What is the Microsoft Office 365 training account?
The Microsoft Office 365 training account is a 365 account which learners will have access to throughout the course duration to practice the skills being taught. This is completely separate to any Office 365 accounts learners currently use, so will not have any impact on your data or documents used in your personal or business 365 account.
Can you deliver Microsoft Office courses at our offices?
Yes we can arrange for our trainers to deliver courses onsite at your business premises. Please contact us for onsite course pricing.
Will I get a certificate?
Yes all our Microsoft Office courses come with a course completion certificate. This will be emailed to you upon course completion.
Related Courses
Office Applications
Microsoft Teams Masterclass
½ day- Microsoft Teams courses from expert trainers
- Classroom, Virtual, and Onsite courses
£125.00 excl. VAT
Find out moreOffice Applications
Power BI Introduction
1 Day- Power BI courses from expert trainers
- Classroom, Virtual, and Onsite courses
£350.00 excl. VAT
Find out moreOffice Applications
Microsoft Office 365 End Users
1 Day- Microsoft Office 365 courses from expert trainers
- Classroom, Virtual, and Onsite courses
£350.00 excl. VAT
Find out moreOffice Applications
Microsoft Power Apps Intermediate
1 Day- Microsoft Power Apps courses from expert trainers
- Classroom, Virtual, and Onsite courses
£350.00 excl. VAT
Find out moreOffice Applications
Microsoft Power Automate
1 Day- Microsoft Power Automate courses from expert trainers
- Classroom, Virtual, and Onsite courses
£350.00 excl. VAT
Find out moreOffice Applications
Microsoft Teams Introduction
1 Day- Microsoft Teams courses from expert trainers
- Classroom, Virtual, and Onsite courses
£205.00 excl. VAT
Find out more