Power BI Fundamentals
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 course designed to help professionals learn how to connect to data, shape and model it, and build clear, interactive reports and dashboards using Microsoft Power BI. The course focuses on practical skills that align with the Microsoft certification pathway and common workplace scenarios, making it suitable for teams and individuals who want to adopt self-service analytics safely and effectively.
You will learn the end-to-end Power BI workflow: ingesting data from files, databases and online sources; transforming and cleaning data with Power Query; building reliable semantic models with relationships and DAX; and designing accessible reports that support decision-making. The course also covers the Power BI service for publishing, sharing and governing content, including workspaces, apps, refresh, security and gateways.
Training is available live online or in-class, with options suited to professionals in Melbourne, Sydney, Brisbane, Adelaide, Canberra and Perth. Practical exercises and guided labs ensure you can apply concepts immediately to your own reporting needs without relying on complex coding. 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
- 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.
Price
| Category | Full-Time (Weekdays) | Part-Time (Weeknights) | Part-Time (Weekends) |
|---|---|---|---|
| Days | Thu & Fri | Mon & Tue | 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 | 2 days | 2 weeks | 1 week |
| Price | $1699 | $1699 | $899 |
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
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 certification pathway?
Do I need coding experience to learn Power BI?
What software do I need for hands-on practice?
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
