Microsoft PL-300T00 - Design and Manage Analytics Solutions using Power BI
Length
3 days
Price
$1999
Cities
Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth
Request Course Information
Why Choose This Course
Design and Manage Analytics Solutions using Power BI is an instructor-led course that builds the end-to-end skills required to prepare data, design reliable semantic models, create effective reports, and manage content securely in the Power BI service. The curriculum aligns to Microsoft’s role-based Power BI Data Analyst certification and current skills outline, focusing on the four core domains: prepare the data, model the data, visualise and analyse the data, and manage and secure Power BI.
Across practical labs, you learn to connect to diverse sources, resolve data quality issues with Power Query, and implement relationships, hierarchies and DAX calculations for performant, governed models. Report design emphasises clear layouts, interactivity and accessibility, while the service modules cover workspaces, apps, refresh, row-level security and sensitivity labels to support secure collaboration at scale.
This course suits analysts and BI professionals who collaborate with stakeholders, translate business requirements into trusted insights, and enable self-service analytics in enterprise environments. It reflects the skills Microsoft expects of a Power BI data analyst, including proficiency with Power Query and DAX, and the ability to deliver actionable, easy-to-comprehend visualisations. Training is available for professionals in Melbourne, Sydney, Brisbane, Adelaide, Canberra and Perth. 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
- Prepare data using Power Query, including profiling, cleaning, and transforming datasets
- Model data for accuracy and performance; configure relationships, hierarchies, and calculation logic
- Create calculated columns and measures with DAX, including time intelligence and visual calculations
- Design effective report pages that support storytelling and user experience best practice
- Apply analytics features such as drillthrough, bookmarks and decomposition to surface insights
- Manage workspaces, apps and content refresh; implement row-level security and sensitivity settings
- Optimise models and reports to improve query performance and usability
Audience
Data analysts, business intelligence practitioners, reporting developers and experienced Excel users who need to learn, prepare and manage analytics solutions with Power BI in a professional setting.
Price
| Category | Full-Time (Weekdays) | Part-Time (Weeknights) | Part-Time (Weekends) |
|---|---|---|---|
| Days | Mon – Thu | 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 | 3 days | 3 weeks | 3 weeks |
| Price | $1999 | $1999 | $1999 |
Outline
- Role and responsibilities of a Power BI data analyst; stakeholder collaboration and requirements
- Getting started with Power BI Desktop and the Power BI service; building blocks and concepts
- Introduction to end-to-end analytics using Microsoft Fabric (usage scenarios)
- Preparing data: connecting to files, databases, online services; privacy levels and credentials
- Data profiling; resolving errors, nulls and inconsistencies; value replacement and type conversion
- Power Query transformations: split, merge, append, pivot and unpivot; Advanced Editor basics (M)
- Choosing a model framework: Import, DirectQuery and composite models; storage mode selection
- Designing semantic models: tables, granularity, relationships, cardinality and cross-filter direction
- Date tables, hierarchies and role-playing dimensions; common configuration patterns
- DAX fundamentals: column vs measure, variables, iterator functions and time intelligence
- Visual calculations and common analytical expressions for report logic
- Model optimisation: performance diagnostics, aggregations and best practice naming conventions
- Report design: layout, themes, navigation, accessibility and consistent formatting
- Interactivity: filters, slicers, drilldown and drillthrough; bookmarks and buttons
- Analytics features: decomposition tree, key influencers, Q&A and explanatory visuals
- Publishing content to the service; distributing dashboards and reports via apps
- Managing workspaces; endorsements, lineage and usage monitoring
- Configuring refresh (scheduled and incremental) and gateways for hybrid connectivity
- Governance and security: row-level security, sensitivity labels and data protection basics
- Exam-aligned review: mapping course outcomes to PL-300 skills measured
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 programming experience to learn Power BI at this level?
What topics are emphasised for exam preparation?
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
