Power BI Training - Advanced Course
Dive deeper into Power BI's modelling power with advanced skills
Dive deeper into Power BI's modelling power with advanced skills
5.00
The course focuses on DAX; Row Context, Functions, Calculated Columns, Measures and working with Various Data Sources.
Learn how to use powerful modelling and data sourcing capabilities to become a Power BI power user in our one-day course. In this advanced course, we focus heavily on the complex theory of DAX and how to work with different data sources. Take your business intelligence analysis to the next level. View our full Power BI Advanced course outline below.
Courses will commence at 11am New Zealand standard time and are delivered remotely.
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
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 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. Remote training in New Zealand.
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
Become a Microsoft Power BI certified expert in New Zealand. Attend our Nexacu Power BI courses, sit the DA-100 exam and become certified!
NZ $2,230
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. Remote training in New Zealand.
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
Become a Microsoft Power BI certified expert in New Zealand. Attend our Nexacu Power BI courses, sit the DA-100 exam and become certified!
NZ $2,230
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
Resit your course for free within 6 Months
Australia
Singapore
Hong Kong
Malaysia
Philippines
Thailand
Indonesia