Power BI Advanced Training Courses
Dive deeper into Power BI and further your skills
Dive deeper into Power BI and further your skills
4.74
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.
Intermediate Power BI skills recommended, including data import, Power Query, visualisations, filters, basic data modelling, calculated fields, and row-level security.
Take this course as part of the PL-300 Power BI Certification and save:
PL-300 Power BI Certification
Power BI BeginnerLearn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.
Power BI IntermediateLearn to build data models and calculations to produce intelligent dashboards. In-class and remote training.
Power BI DAXLearn Power BI DAX from our experienced trainers. Login remotely or attend our CBD locations nationwide.
Power BI Desktop Advanced ReportingMaster advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.
Power BI Data Transformation using Power QueryLearn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.
Data Visualisation with Power BI DesktopLearn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.
DA-100 Power BI Certification
Join remotely from Singapore, attend Nexacu Power BI training courses and prepare to sit the DA-100 exam to achieve your Power BI certification.
SG $2,245
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
What is Remote Training?
Remote training at Nexacu, 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 discussion 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.
Which courses are available remotely?
All of our Public Courses scheduled in across South East Asia and New Zealand are available to be delivered remotely. Book any course and you will receive login details to access our student portal. The Student portal contains all our your course information, instructions on getting set up for a remote class and free webinars.
What is Power BI?
Power BI is Microsoft's Data Visualization tool. The BI stands for Business Intelligence. Power BI enables users to connect with their data, cleanse it and build interactive dashboards to gain insights that drive actions.
Will the content in these Power BI Courses be relevant for the workplace?
Yes, our course writers and trainers have industry backgrounds. Our core principle is to deliver training that our students can not only use in the workplace but will actually drive increased efficiency and productivity gains. We teach the key elements of Power BI from Beginner to Advanced; starting with a focus on visualizations and quickly progressing to data manipulation and modelling. We also offer a DAX course.
How many students are typically in a Power BI Training Course?
While this varies from session to session, we typically have 5-8 students in our Power BI classes. We cap our classes at 10 students. This is to ensure the quality of training remains high and that all students can ask questions and engage in discussion.
Power BI BeginnerLearn to use Power BI to create interactive dashboards, custom reports, analyse data and share insights.
Power BI IntermediateLearn to build data models and calculations to produce intelligent dashboards. In-class and remote training.
Power BI DAXLearn Power BI DAX from our experienced trainers. Login remotely or attend our CBD locations nationwide.
Power BI Desktop Advanced ReportingMaster advanced Power BI reporting techniques in 1 day. Learn to create complex, layered, and interactive reports with custom visuals and navigation controls.
Power BI Data Transformation using Power QueryLearn Power Query for Excel and Power BI Desktop in 1 day. Master data transformation, query management, and M code to optimise your data workflows.
Data Visualisation with Power BI DesktopLearn to create powerful visualisations and reports in Power BI Desktop in 1 day. Master data modelling, visualisation techniques, and report sharing.
DA-100 Power BI Certification
Join remotely from Singapore, attend Nexacu Power BI training courses and prepare to sit the DA-100 exam to achieve your Power BI certification.
SG $2,245
At Nexacu, we are proud to be the trusted training partner for hundreds of leading organisations across Australia, New Zealand, and around the world. From government agencies to multinational corporations, we help teams build practical skills and achieve real outcomes through expert-led training.
Students
4 & 5 Star Reviews
Google Reviews
Businesses Trust Nexacu
Custom workbook included with a step by step exercises
Learn with expert instructors, wherever you are
Valued by Individuals
Australia
New Zealand
Hong Kong
Malaysia
Philippines
Thailand
Indonesia