Microsoft DP-605T00 - Prepare and Visualise Data with Microsoft Power BI
Length
1 day
Price
$799
Cities
Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth
Request Course Information
Why Choose This Course
Prepare and Visualise Data with Microsoft Power BI is an instructor-led course designed for professionals who want to learn how to connect to data sources, prepare and model data, and design clear, interactive reports for decision-making. The course follows the current Microsoft learning path and official curriculum for DP-605, introducing the Power BI workflow from data acquisition through Power Query to building a semantic model and publishing reports in the Power BI service, including recent capabilities such as Copilot in Power BI and guidance aligned with Microsoft Fabric usage scenarios.
Learners will practise preparing data from files, relational databases and online services; shaping and combining queries; creating relationships, hierarchies and calculations; and selecting appropriate visuals to communicate insights effectively. The focus is on practical application with exam-aligned content that maps to the core domains assessed in the Microsoft Power BI Data Analyst certification, including preparing data, modelling data, visualising and analysing, and managing and securing Power BI.
This course supports teams adopting self-service analytics across Melbourne, Sydney, Brisbane, Adelaide, Canberra and Perth. It helps analysts and reporting specialists reduce manual reporting, improve data quality and create trustworthy dashboards that can be shared securely via workspaces and apps. Participants gain hands-on experience with Power BI Desktop for Windows and the Power BI service, guided by experienced instructors who emphasise safe, repeatable patterns. 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 data from files, relational databases, online services and NoSQL sources
- Profile, clean and transform data using Power Query and the Advanced Editor (M)
- Design a semantic model with relationships, cardinality, hierarchies and date tables
- Create calculated columns, measures and quick measures with DAX
- Select and configure visuals, filters, slicers and layouts for accessible reporting
- Publish reports, manage workspaces and promote content for collaboration
- Configure scheduled and incremental refresh; use gateways for on-premises connectivity
- Apply row-level security and governance practices in the Power BI service
- Use Copilot in Power BI to accelerate report creation and exploration
Audience
- Data analysts, business intelligence practitioners, reporting developers and experienced Excel users who need to learn, prepare and visualise data with Power BI in a professional setting.
Price
| Category | Full-Time (Weekdays) | Part-Time (Weeknights) | Part-Time (Weekends) |
|---|---|---|---|
| Days | Friday | 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 | 1 day | 1 week | 1 week |
| Price | $799 | $799 | $799 |
Outline
- Getting started with Power BI: services, building blocks and the Power BI service tour
- Getting data: files, relational sources, parameters, NoSQL databases and online services
- Storage modes and performance considerations when importing or connecting data
- Troubleshooting data import errors and performance issues
- Shaping data with Power Query: split, merge, append and transform patterns
- Data profiling and quality checks; changing column data types consistently
- Advanced Editor basics: editing M for repeatable transformations
- Designing semantic models: tables, dimensions, granularity and relationships
- Date tables, role-playing dimensions and cross-filter direction
- Calculations: DAX measures vs calculated columns, quick measures, visual calculations
- Model optimisation techniques aligned to certification guidance
- Report design: layout, navigation, themes and accessible formatting
- Selecting visuals to match analytical requirements and audience needs
- Filters, slicers and advanced filtering techniques for consumption-time scenarios
- Copilot in Power BI: generating report pages and exploring model context
- Publishing to the Power BI service; distributing reports and dashboards
- Managing workspaces, endorsements and lineage for governed content
- Gateway configuration and scheduled or incremental refresh
- Applying row-level security and basic data protection settings
- Promoting and managing semantic models; collaboration best practices
- Introduction to end-to-end analytics using Microsoft Fabric (usage scenarios)
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 training aligned with the Microsoft Power BI certification pathway?
Do I need programming experience to learn Power BI?
Is Power BI Desktop required?
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 Business Intelligence Analyst roles in Australia’s ICT sector.
97%
Fortune 500 companies reported using Power BI, reflecting strong enterprise adoption.
375,000+
Organisations worldwide using Power BI as of 2024, indicating broad global uptake.
17 years
Microsoft named a Leader in Gartner’s Magic Quadrant for Analytics and Business Intelligence Platforms
5,000+
Australian companies recognise or employ staff with power bi expertise.
98%
Student satisfaction rate from our training programs.
Our Accreditations
