Australia
New Zealand
Singapore
Hong Kong
Malaysia
Philippines
Thailand
Power BI Training - Advanced Courses
Dive deeper into Power BI's modelling power with advanced skills
Dive deeper into Power BI's modelling power with advanced skills
5.00
Dive deeper into Power BI's modelling power with advanced skills
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 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 with our Power BI Advanced course. View our full Power BI Advanced course outline below.
Course Details
Download Course PDF
Upcoming Courses
Power BI Training Courses
Power BI Beginner Power BI Intermediate Power BI Advanced Power BI DAX 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 DesktopThis 1-day course focuses on producing high-quality reports using the full range of visualisations available in Power BI Desktop. You will gain a comprehensive understanding of the Power BI ecosystem, learn how to acquire and model data, and overcome common challenges related to map visualisations, relationships, and data types. The course also covers report publishing and sharing strategies, ensuring that your visualisations can be effectively communicated.
DA-100 Power BI Certification
Achieve your Power BI certification with Nexacu. Join remotely from Jakarta while you attend training courses and prepare to sit the DA-100 exam.
RP 25.200K
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
Common questions
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.
