Advanced Data Modelling and Shaping with Power BI
Length
1 days
Price
$899
Cities
Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth
Request Course Information
Why Choose This Course
Advanced Data Modelling and Shaping with Power BI is an instructor-led course designed for professionals who need to connect, clean, transform, and model data to deliver reliable analytics in Power BI. The course focuses on best-practice data shaping with Power Query and robust semantic modelling with DAX, relationships, and star schema design, so you can build performant, trustworthy reports for business stakeholders across Melbourne, Sydney, Brisbane, Adelaide, Canberra and Perth. It aligns to the skills measured for Microsoft’s Power BI Data Analyst certification, covering preparation, modelling, visualisation and governance responsibilities in Power BI.
You will learn practical techniques to profile and clean data, apply transformations efficiently, and design models that use appropriate cardinality, cross-filter directions and role-playing dimensions. The course emphasises query folding, parameters, merging and appending queries, and converting semi-structured data to tabular structures. On the modelling side, you will create calculated columns and measures with DAX, use CALCULATE and time intelligence patterns, configure row-level security, and optimise performance using tools like Performance Analyzer and DAX query view. These practices are based on Microsoft’s guidance for transforming and modelling data and recommended architecture patterns for Power BI.
This training provides applied skills that are valued across industries, helping analysts, BI developers and data professionals produce maintainable analytics solutions without making absolute promises about outcomes. A certificate of course attendance is included.
Prerequisites
- There are no formal prerequisites for this course.
Exam
Candidates can achieve thi certification by passing the following exam(s).
PL-300: Microsoft Power BI Data Analyst
Books
Delivery
- Instructor-led Classroom Training at our premises
- Live Virtual Online Training attend in real-time from anywhere
- In-House Training at your premises (4+ participants)
Skills Gained
- Clean, transform and profile data with Power Query, including query folding, parameters, merge and append
- Design star schema models; configure relationships, cardinality and cross-filter direction
- Create calculated columns, tables and measures with DAX; apply variables and evaluation context
- Use CALCULATE and time intelligence patterns; build semi-additive measures
- Implement row-level security for governed access to model assets
- Optimise model performance and diagnose bottlenecks with Performance Analyzer and DAX query view
- Convert semi-structured data to tabular form; build fact and dimension tables
- Select DirectQuery or Import strategically and use composite models appropriately
Audience
This course is ideal for data analysts, BI developers, reporting specialists and power users who need to prepare, model and govern data for analytics in Power BI, including professionals building exam-aligned capability for the Microsoft Power BI Data Analyst role.
Price
| Category | Full-Time (Weekdays) | Part-Time (Weeknights) | Part-Time (Weekends) |
|---|---|---|---|
| Days | Monday to Wednesday | Mondays and Tuesdays | Saturdays only |
| Time | 9:30 am to 5:00 pm | 6:00 pm to 9:00 pm | 10:00 am to 5:00 pm |
| Duration | 1 day or 2 days | 1 week or 2 weeks | 1 week or 2 weeks |
| Price | $899 | $899 | $899 |
Outline
- Power BI architecture overview for modelling and governance
- Installing and updating Power BI Desktop (Store versus executable)
- Connecting to data and profiling with Power Query
- Data types, column transformations and applied steps
- Query folding concepts and performance implications
- Parameters, query reuse and reference versus duplicate
- M fundamentals: functions, logic and common operations
- Merging and appending queries across sources
- Converting semi-structured data to tables (pivot, unpivot, transpose)
- Designing star schemas: facts, dimensions and grain
- Relationship configuration: cardinality and cross-filter direction
- Role-playing dimensions and date tables
- Calculated columns and tables versus measures: when and why
- DAX fundamentals: evaluation context, variables and function categories
- CALCULATE deep dive and filter modification patterns
- Time intelligence patterns and semi-additive measures
- Quick measures and visual calculations
- Row-level security roles and membership configuration
- Model optimisation: reducing granularity, pruning columns and rows
- Performance Analyzer, DAX query view and troubleshooting
- DirectQuery versus Import, composite models and guidance
- Dataflows and self-service data preparation in Power BI
- Scheduling refresh and workspace-level governance (high level)
Terms & Conditions
The supply of this course is governed by our terms and conditions. Please read them carefully before enrolling, as enrolment is conditional on acceptance of these terms and conditions. Proposed course dates are given, course runs subject to availability and minimum registrations.
Frequently Asked Questions (FAQ's)
Is this course aligned to the Microsoft Power BI Data Analyst certification?
Do I need prior coding experience to benefit from the course?
Can I complete the hands-on labs on a Mac?
Our Partnership
Reliable certification testing is vital for validating professional skills in today’s tech-driven world. As a Pearson VUE Authorised Centre, we provide a secure environment for globally recognised IT exams. This partnership ensures convenient access to certifications with the highest standards of integrity and accuracy.
$118,530
Average advertised salary for BI Analyst roles in Australia (SEEK).
97%
Power BI reported in use across 97% of Fortune 500 companies.
375,000+
Global organisations using Power BI (2024).
0.3%
Online job ads up 0.3% in July 2025 nationally (JSA)
17 years
Microsoft named a Leader in Gartner’s Magic Quadrant for Analytics and BI Platforms (including 2024)
98%
Student satisfaction rate from our training programs.
Our Accreditations
