Power BI Advanced Training Courses
Dive deeper into Power BI and further your skills
All courses available in-class or remotely. To attend remotely, select "Remote East" or "Remote West" as your location on book now.
This course focuses on streamlining report creation, working with multiple date-dimension tables and role-playing dimensions, understanding filter context, using DAX to modify filter context, dynamic row-level security and using advanced report features such as drill-through, custom tooltips and report navigation.
In this one-day course you will gain a deeper understanding of evaluation of DAX measures and wider exposure to features within Power BI Desktop. Take your business intelligence analysis to the next level with our Power BI Advanced course. View our full Power BI Advanced course outline below.
Course Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDF
Upcoming Courses
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
We currently have no public courses scheduled. Please contact us to register your interest.
Power BI Training Courses

Learn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.

Learn to build data models and calculations to produce intelligent dashboards. In-class and remote training.

Advance your Power BI skills by learning DAX; Row Context, Functions, Calculated Columns, Measures and more.

Learn Power BI DAX from our experienced trainers. Login remotely or attend our CBD locations nationwide.

Become a Microsoft Power BI certified expert. Attend our Nexacu Power BI courses, sit the PL-300 exam and become a Power BI Data Analyst Associate.
$2,170 inc GST
Power BI Advanced Course Content
- Course Introduction
- Overview of Power BI
- Data Model
- Data modelling in the real world
- The dataset
- Themes, Parameters and Templates
- Report themes
- Parameters for changing the data source
- Report templates
- Advanced Slicing
- Working with multiple date dimension tables
- Create a date dimension table using DAX
- Role-playing dimensions
- Create hierarchies
- DAX Measures and Filters
- What is DAX?
- DAX measures
- Measures table
- Filters on a measure
- Filter context
- DAX Measures and Filters cont'd
- Measure evaluation with empty filter context
- Measure evaluation with propagation of filters
- Adding to the filter context
- Using DAX to modify the filter context
- Basic Filtering with CALCULATE
- CALCULATE basics
- CALCULATE with simple filters
- Filter behaviour
- CALCULATE with table expression filters
- CALCULATE and Filter Modifiers
- USERELATIONSHIP
- REMOVEFILTERS
- ALLSELECTED
- KEEPFILTERS
- CROSSFILTER
- Filter context follows relationships
- Bidirectional cross filtering
- Temporarily change the cross-filter direction
- Report Features
- Bin data
- Group data
- Drill through
- Custom report tooltips
- Manually setting a report tooltip
- Add navigation
- Page navigator
- Page navigation buttons
- Drill-through buttons
- Row-Level Security
- USERNAME
- Parent-child hierarchy
- PATH
- LOOKUPVALUE
- Dynamic row-level security
- Publish and test RLS
- Extended Exercise – API Data Sources
- Query a real API data source
- HTTP and JSON terminology
- Transform a JSON response
- Publish to the Power BI Service
- Extended Exercise – Data Streaming
- Stream data from PubNub
- Extended Exercise – Files in Folders
- Query a folder of files
- Column consistency
- Understanding the folder query
- View Query Dependencies
- Extended Exercise – Power Query M Language
- Syntax
- Lots of hashes
- The let and in statements
- Basic exercises in M
- Values, records and lists
- Operators
- Extended Exercise – Power Query M Language cont'd
- Conditional testing – if
- Errors and error handling
- Accessing table data
- More advanced M language exercises
- Each expression
- Refer to other queries
- Understanding a web query
- Remove rows by filtering
Frequently asked questions
What is Power BI?
Power BI is Microsoft's powerful data visualisation tool that is commonly used for business analytics. With the ability to connect to data, clean and transform it, and create interactive dashboards, users can gain valuable insights to support informed decision-making. In our courses, you will gain hands-on experience using both Power BI Desktop and the Power BI service to create compelling visualisations. Learning Power BI has never been easier, and our courses will provide you with the skills you need to leverage this powerful tool effectively.
How difficult is Power BI Training?
The difficulty level of Microsoft Power BI courses can vary depending on factors such as prior experience with the Microsoft Power BI desktop itself, data analysis, familiarity with business intelligence concepts, and the depth of knowledge one aims to achieve. For beginners, Power BI training can present a learning curve as they navigate the platform's features, data modeling, visualisation techniques, and understanding DAX formulas. However, with the availability of comprehensive learning resources, official documentation, and training courses, individuals can gradually build their skills and proficiency in Power BI. The structured learning paths offered by Microsoft and the supportive online community further contribute to easing the learning process. With dedication, practice, and a willingness to learn, individuals can overcome the initial challenges and become proficient in leveraging Power BI effectively for data analysis and visualisation.
Will the content in these Power BI Courses be relevant for the workplace?
Our training courses for Microsoft Power BI are designed with a focus on real-world application, and our experienced course writers and trainers bring their industry backgrounds to the table to provide you with the knowledge and skills you need to achieve efficiency and productivity gains in your workplace. We offer a comprehensive curriculum that covers everything from the basics of visualisations to advanced data modelling and analysis, with an additional course for advanced users on the DAX language. By learning Power BI with us, you'll be equipped with the tools to create effective reports and dashboards, allowing you to excel with efficiency in your role.
How many students are typically in a Power BI Training Course?
At Nexacu, we deliver the highest quality of training where we strive to maintain a high level of quality instruction and foster active participation and dialogue. As such, we generally limit the number of students in each class to 5-8 individuals, with a maximum cap of 10. This approach ensures that you receive comprehensive and effective training, while also providing ample opportunities for asking questions and engaging in discussions with the instructor and fellow students.
What is Remote Training?
Remote training means our team of experienced trainers will deliver your training virtually. With remote learning, students can access our usual classroom training courses via video conferencing, ask questions, participate in discussions and share their screen with the trainer if they need help at any point in the course. Students have the same level of participation and access to the trainer as they would in classroom training sessions. Essentially, you will learn Power BI from our Microsoft-certified trainers online.
I previously attended a course with Excel Consulting, will the training be similar?
Yes, we rebranded from Excel Consulting in October 2019. The business quickly outgrew its original name. Our new brand Nexacu, better reflects our direction, continued innovation and commitment to deliver next-level learning. We have continually refined and updated our courses while retaining our excellent trainers and delivering the same high-quality content.
Where do I start with learning the Power BI Courses?
Check our Power BI Course syllabus to see our vast set our course offerings from Beginner, Intermediate, Advanced, and DAX, leading to the ultimate Microsoft Power BI certification. Starting with the Beginner course, you will develop a fundamental understanding of data visualization tools necessary for analyzing data and leveraging data analysis expressions. Proceeding with our Intermediate course, you will explore data analytics and data models necessary for data transformation. Our Advanced course offers a comprehensive introduction to DAX functions, features, and different Power BI tools. Finally, once you reach DAX, expect mastery of more complex DAX tools and achieve more in-depth Microsoft Power BI skills.
Why should I choose Nexacu?
With years of experience in delivering Microsoft Power BI training, Nexacu has successfully served a vast number of students who have enrolled in our Beginner, Intermediate, Advanced, and DAX courses. We take pride in offering highly coveted Power BI courses, which attracts professionals from diverse industries, eager to enhance their data analysis skills and excel in developing impactful BI reports. Join us on a journey towards becoming a data analysis expert with our comprehensive Power BI training programs. Our Microsoft Power BI training combines our highly successful courses, a comprehensive syllabus, the official exam, and certification, all at an exceptional value. For the price of four Power BI training courses, you'll also receive unlimited Microsoft practice exams, a free re-sit, unlimited study support, additional study materials, and the official Microsoft certification upon passing the exam. Propel your career in data analytics with this comprehensive package.
Course Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFCourse Details
Download Course PDFContact Us
Can’t find a suitable date or have questions about the course? Fill out the form below, and our team will get back to you promptly.
Locations In-Person & Online
Find the nearest location and date that works for you
-
Power BI Training in Brisbane
View Dates -
Power BI Training in Melbourne
View Dates -
Power BI Training in Sydney
View Dates -
Power BI Training in Adelaide
View Dates -
Power BI Training in Perth
View Dates -
Power BI Training in Parramatta
View Dates -
Power BI Training in Canberra
View Dates -
Power BI Training in Remote Online
View Dates
Locations In-Person & Online
Find the nearest location and date that works for you
Locations In-Person & Online
Find the nearest location and date that works for you
-
Power BI Training in Brisbane
View Dates -
Power BI Training in Melbourne
View Dates -
Power BI Training in Sydney
View Dates -
Power BI Training in Adelaide
View Dates -
Power BI Training in Perth
View Dates -
Power BI Training in Parramatta
View Dates -
Power BI Training in Canberra
View Dates -
Power BI Training in Remote Online
View Dates
Locations In-Person & Online
Find the nearest location and date that works for you
-
80K+
Students
-
76K+
4 & 5 Star Reviews
-
4.7/5
Google Reviews
-
1.3K+
Businesses Trust Nexacu
Step by Step Courseware
Custom workbook included with a step by step exercises



Free Refresher
Resit your course for free within 6 Months