Power BI Fundamentals Training Course
Length
1 days
Price
$899
Cities
Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth
Request Course Information
Why Choose This Course
Power BI Fundamentals is an instructor-led training course designed for professionals who want to develop practical business intelligence, reporting, and data analytics skills using Microsoft Power BI. The course provides a comprehensive introduction to the Power BI ecosystem, enabling participants to connect to data sources, prepare and model data, create interactive reports and dashboards, and share insights securely across their organisation.
As businesses increasingly rely on data-driven decision-making, the ability to transform raw data into meaningful insights has become an essential skill. Microsoft Power BI is one of the world’s leading business intelligence platforms, providing powerful tools for data preparation, analysis, visualisation, and reporting. This course helps participants build the confidence and practical skills needed to create effective analytics solutions using Power BI.
Participants begin by exploring the Power BI environment and learning how Power BI Desktop and the Power BI Service work together. Through practical exercises and instructor-led demonstrations, learners become familiar with the workflows and best practices used to create professional reporting and analytics solutions.
A major focus of the training is data acquisition and preparation. Participants learn how to connect to spreadsheets, databases, cloud applications, and online services. Using Power Query, learners gain hands-on experience cleaning, transforming, combining, and shaping data to create reliable datasets for analysis and reporting.
The course also covers data modelling concepts that support effective business intelligence solutions. Participants learn how to create relationships between tables, organise data structures, build semantic models, and develop scalable reporting environments that deliver consistent and accurate results.
Data Analysis Expressions (DAX) are introduced to help participants create calculations, measures, and key business metrics. These skills enable learners to perform more advanced analysis and provide meaningful insights that support business performance monitoring and decision-making.
Report development and dashboard design are key components of the curriculum. Participants learn how to create visually engaging reports using tables, charts, maps, scorecards, filters, slicers, and drill-through functionality. Best practices for report design, usability, accessibility, and visual storytelling are incorporated throughout the training.
The course also explores how to publish, share, and manage content within the Power BI Service. Learners gain practical experience with workspaces, dashboards, apps, refresh schedules, collaboration features, and governance controls. Security topics such as Row-Level Security (RLS), permissions management, and secure report sharing are also introduced.
Through instructor-led demonstrations, guided labs, and real-world business scenarios, participants develop the skills needed to create reports, analyse data, build dashboards, and support data-driven decision-making across organisations. The course provides an excellent foundation for further Power BI learning and advanced Microsoft analytics certifications.
This course is ideal for Business Analysts, Data Analysts, Reporting Specialists, Finance Professionals, Operations Managers, Project Managers, Team Leaders, Power BI Users, and anyone looking to develop business intelligence and reporting skills. Training is available across Melbourne, Sydney, Brisbane, Adelaide, Perth, and Canberra, as well as through live online delivery throughout Australia. A Certificate of Attendance is included upon completion.
Prerequisites
- There are no formal prerequisites for this course.
Exam Details
Candidates can achieve this certification by passing the following exam(s).
PL-300: Microsoft Power BI Data Analyst
Learning Resources
Delivery Options
- 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
- Connect to and combine data from common sources (files, databases, web and folders)
- Profile, clean and transform data using Power Query
- Build robust data models with relationships and hierarchies
- Create calculated columns and measures with DAX
- Apply time intelligence and aggregation techniques
- Optimise model performance and storage modes
- Design accessible, consistent report layouts and themes
- Use interactive features such as slicers, drillthrough and bookmarks
- Apply advanced visuals including decomposition tree, key influencers and Q&A
- Publish datasets and reports to the Power BI service
- Configure scheduled refresh and gateways
- Manage workspaces, apps and content sharing
- Implement row-level security for governed access
- Use deployment pipelines for lifecycle management
- Follow best practice for data governance and collaboration
Audience
This course is ideal for data analysts, business intelligence practitioners, reporting developers, and experienced Excel users who need to build reliable, interactive analytics with Power BI in a professional setting.
Outline
- Introduction to Power BI and the Power Platform
- Power BI Desktop, Service, Mobile and Gateway overview
- Data connections: files, databases, web and folders
- Query settings, data source credentials and privacy levels
- Data profiling and quality assessment
- Shaping data with Power Query (split, merge, append)
- Transforming and combining queries
- Structuring star schemas and denormalised tables
- Relationships, cardinality and cross-filter direction
- Hierarchies and role-playing dimensions
- DAX fundamentals: calculated columns and measures
- Time intelligence functions and common patterns
- Model optimisation: storage modes, aggregations and performance
- Report design principles: layout, navigation and themes
- Visuals: charts, tables, matrices, maps and custom visuals
- Interactivity: filters, slicers, drilldown and drillthrough
- Tooltips, bookmarks, buttons and parameter-like patterns
- Accessibility and usability best practice
- Publishing to the Power BI service
- Workspaces, apps and content distribution
- Dashboards vs reports: when and how to use each
- Scheduled refresh, incremental refresh and gateways
- Row-level security and object-level security
- Collaboration features: comments, endorsements and lineage
- Deployment pipelines and promoting content to production
- Dataflows and shared datasets for reuse
- Governance considerations and tenant settings
Power BI Fundamentals Course Schedule and Locations
Choose a city to view upcoming dates, prices and delivery formats.
Power BI Fundamentals Course Schedules Across Australia
| Type | Duration | Price | Start Date | Action |
|---|---|---|---|---|
| Part-Time (Weeknights): Mon & Tue Time: 6:00 pm to 9:00 pm | 1 Week | $899 | 14 Sep 2026 | Book Now |
| Part-Time (Weekends): Saturdays Time: 10:00 am to 5:00 pm | 1 Week | $899 | 19 Sep 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 01 Oct 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 05 Oct 2026 | Book Now |
| Part-Time (Weekends): Saturdays Time: 10:00 am to 5:00 pm | 1 Week | $899 | 17 Oct 2026 | Book Now |
| Part-Time (Weeknights): Mon & Tue Time: 6:00 pm to 9:00 pm | 1 Week | $899 | 19 Oct 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 02 Nov 2026 | Book Now |
| Type | Duration | Price | Start Date | Action |
|---|---|---|---|---|
| Part-Time (Weeknights): Mon & Tue Time: 6:00 pm to 9:00 pm | 1 Week | $899 | 14 Sep 2026 | Book Now |
| Part-Time (Weekends): Saturdays Time: 10:00 am to 5:00 pm | 1 Week | $899 | 19 Sep 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 01 Oct 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 05 Oct 2026 | Book Now |
| Part-Time (Weekends): Saturdays Time: 10:00 am to 5:00 pm | 1 Week | $899 | 17 Oct 2026 | Book Now |
| Part-Time (Weeknights): Mon & Tue Time: 6:00 pm to 9:00 pm | 1 Week | $899 | 19 Oct 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 02 Nov 2026 | Book Now |
| Type | Duration | Price | Start Date | Action |
|---|---|---|---|---|
| Part-Time (Weeknights): Mon & Tue Time: 6:00 pm to 9:00 pm | 1 Week | $899 | 14 Sep 2026 | Book Now |
| Part-Time (Weekends): Saturdays Time: 10:00 am to 5:00 pm | 1 Week | $899 | 19 Sep 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 01 Oct 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 05 Oct 2026 | Book Now |
| Part-Time (Weekends): Saturdays Time: 10:00 am to 5:00 pm | 1 Week | $899 | 17 Oct 2026 | Book Now |
| Part-Time (Weeknights): Mon & Tue Time: 6:00 pm to 9:00 pm | 1 Week | $899 | 19 Oct 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 02 Nov 2026 | Book Now |
| Type | Duration | Price | Start Date | Action |
|---|---|---|---|---|
| Part-Time (Weeknights): Mon & Tue Time: 6:00 pm to 9:00 pm | 1 Week | $899 | 14 Sep 2026 | Book Now |
| Part-Time (Weekends): Saturdays Time: 10:00 am to 5:00 pm | 1 Week | $899 | 19 Sep 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 01 Oct 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 05 Oct 2026 | Book Now |
| Part-Time (Weekends): Saturdays Time: 10:00 am to 5:00 pm | 1 Week | $899 | 17 Oct 2026 | Book Now |
| Part-Time (Weeknights): Mon & Tue Time: 6:00 pm to 9:00 pm | 1 Week | $899 | 19 Oct 2026 | Book Now |
| Full-Time (Weekdays): Mon - Wed Time: 9:30 am to 5:00 pm | 1 Day | $899 | 02 Nov 2026 | Book Now |
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)
What is the Power BI Fundamentals course?
Power BI Fundamentals is a practical training course that teaches participants how to connect to data sources, prepare and model data, create reports and dashboards, and share analytics using Microsoft Power BI.
Who should attend the Power BI Fundamentals course?
The course is ideal for Business Analysts, Data Analysts, Reporting Specialists, Finance Professionals, Operations Managers, Project Managers, and anyone seeking to build business intelligence and reporting skills.
Do I need previous Power BI experience?
No. The course is designed for beginners and provides a step-by-step introduction to Power BI Desktop, the Power BI Service, and core data analytics concepts.
What skills will I gain from Power BI Fundamentals training?
Participants learn data preparation with Power Query, data modelling, DAX fundamentals, report creation, dashboard development, data visualisation, Power BI Service administration, and secure content sharing.
Does the course cover Power BI Service and report sharing?
Yes. Participants learn how to publish reports, manage workspaces, create apps, configure data refresh schedules, use gateways, and securely share content using the Power BI Service.
Why is Power BI important for organisations?
Power BI helps organisations turn data into actionable insights through interactive reports, dashboards, and analytics. It improves decision-making, increases visibility into business performance, and supports self-service business intelligence initiatives.
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













