Microsoft PL-300T00 - Design and Manage Analytics Solutions using Power BI

Duration

3 days / 3 weeks

Price

$1999

Cities

Melbourne, Sydney, Brisbane, Adelaide, Canberra, Perth

Request Course Information

Why Choose This Course

PL-300T00: Design and Manage Analytics Solutions using Power BI is an instructor-led training course designed for professionals who want to develop the skills required to prepare, model, analyse, visualise, and manage data using Microsoft Power BI. Aligned with the Microsoft Certified: Power BI Data Analyst Associate certification, this course provides hands-on experience building end-to-end analytics solutions that transform data into meaningful business insights.

As organisations increasingly rely on data-driven decision-making, Power BI has become one of the leading business intelligence platforms for reporting, analytics, and data visualisation. This course helps participants develop the practical knowledge required to create trusted datasets, deliver interactive reports, and support business intelligence initiatives across a wide range of industries.

Participants learn how to connect to multiple data sources, prepare and transform data using Power Query, and build scalable data models that support accurate and efficient reporting. The course explores best practices for data preparation, cleansing, shaping, and modelling to ensure high-quality analytics outcomes.

A major focus of the training is data modelling and Data Analysis Expressions (DAX). Learners gain practical experience creating relationships, calculated columns, measures, hierarchies, and business metrics that enable advanced analysis and meaningful reporting. These skills help organisations generate deeper insights and improve decision-making.

The course also covers report development and dashboard design. Participants learn how to create visually engaging reports, interactive dashboards, drill-through experiences, filters, and data visualisations that help stakeholders understand trends, performance metrics, and business outcomes.

Analytics capabilities are integrated throughout the curriculum, allowing participants to explore data, identify patterns, monitor performance, and support informed decision-making. The course highlights how Power BI can be used to deliver actionable insights across finance, operations, sales, marketing, and executive reporting environments.

Managing and securing Power BI content is another key area of study. Participants learn how to publish reports, manage workspaces, configure refresh schedules, implement Row-Level Security (RLS), apply governance controls, and support secure collaboration using the Power BI Service.

Through hands-on labs and practical scenarios, participants develop the skills required to design, implement, and manage enterprise-ready Power BI solutions while preparing for the Microsoft Certified: Power BI Data Analyst Associate certification.

This course is ideal for Data Analysts, Business Analysts, Business Intelligence Professionals, Reporting Specialists, Finance Analysts, Power BI Developers, Operations Managers, and professionals responsible for analytics and reporting solutions. 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 thi certification by passing the following exam(s).

    PL-300: Microsoft Power BI Data Analyst

Learning Resources

Prepare and Visualise Data with Microsoft Power BI course material included.

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

  • 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.

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

Microsoft PL-300 Course Schedule and Locations

Choose a city to view upcoming dates, prices and delivery formats.

Microsoft PL-300 Course Schedules Across Australia

TypeDurationPriceStart DateAction
Part-Time (Weeknights): Mon & Tue
Time: 6:00 pm to 9:00 pm
3 Weeks$2,69914 Sep 2026Book Now
Part-Time (Weekends): Saturdays
Time: 10:00 am to 5:00 pm
3 Weeks$2,69919 Sep 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69901 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69905 Oct 2026Book Now
Part-Time (Weekends): Saturdays
Time: 10:00 am to 5:00 pm
3 Weeks$2,69917 Oct 2026Book Now
Part-Time (Weeknights): Mon & Tue
Time: 6:00 pm to 9:00 pm
3 Weeks$2,69919 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69902 Nov 2026Book Now
TypeDurationPriceStart DateAction
Part-Time (Weeknights): Mon & Tue
Time: 6:00 pm to 9:00 pm
3 Weeks$2,69914 Sep 2026Book Now
Part-Time (Weekends): Saturdays
Time: 10:00 am to 5:00 pm
3 Weeks$2,69919 Sep 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69901 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69905 Oct 2026Book Now
Part-Time (Weekends): Saturdays
Time: 10:00 am to 5:00 pm
3 Weeks$2,69917 Oct 2026Book Now
Part-Time (Weeknights): Mon & Tue
Time: 6:00 pm to 9:00 pm
3 Weeks$2,69919 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69902 Nov 2026Book Now
TypeDurationPriceStart DateAction
Part-Time (Weeknights): Mon & Tue
Time: 6:00 pm to 9:00 pm
3 Weeks$2,69914 Sep 2026Book Now
Part-Time (Weekends): Saturdays
Time: 10:00 am to 5:00 pm
3 Weeks$2,69919 Sep 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69901 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69905 Oct 2026Book Now
Part-Time (Weekends): Saturdays
Time: 10:00 am to 5:00 pm
3 Weeks$2,69917 Oct 2026Book Now
Part-Time (Weeknights): Mon & Tue
Time: 6:00 pm to 9:00 pm
3 Weeks$2,69919 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69902 Nov 2026Book Now
TypeDurationPriceStart DateAction
Part-Time (Weeknights): Mon & Tue
Time: 6:00 pm to 9:00 pm
3 Weeks$2,69914 Sep 2026Book Now
Part-Time (Weekends): Saturdays
Time: 10:00 am to 5:00 pm
3 Weeks$2,69919 Sep 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69901 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69905 Oct 2026Book Now
Part-Time (Weekends): Saturdays
Time: 10:00 am to 5:00 pm
3 Weeks$2,69917 Oct 2026Book Now
Part-Time (Weeknights): Mon & Tue
Time: 6:00 pm to 9:00 pm
3 Weeks$2,69919 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69902 Nov 2026Book Now
TypeDurationPriceStart DateAction
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69901 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69905 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69902 Nov 2026Book Now
TypeDurationPriceStart DateAction
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69901 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69905 Oct 2026Book Now
Full-Time (Weekdays): Mon - Wed
Time: 9:30 am to 5:00 pm
3 Days$2,69902 Nov 2026Book 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 (FAQs)

What is PL-300T00: Design and Manage Analytics Solutions using Power BI?

PL-300T00 is a Microsoft Power BI training course that teaches professionals how to prepare data, build data models, create visualisations, perform analysis, and manage Power BI content within enterprise environments.

The course is ideal for Data Analysts, Business Analysts, Business Intelligence Professionals, Finance Analysts, Reporting Specialists, Power BI Developers, and professionals responsible for analytics and reporting.

Participants learn Power Query data transformation, semantic data modelling, DAX calculations, report and dashboard design, analytics techniques, workspace management, content deployment, governance, and security best practices.

Yes. The course provides hands-on experience using Power Query for data preparation and DAX for creating measures, calculated columns, business metrics, and advanced analytical calculations.

Power BI provides features such as Row-Level Security (RLS), workspace permissions, sensitivity labels, data governance controls, and secure content sharing to support enterprise reporting requirements.

Yes. The course aligns with the Microsoft Certified: Power BI Data Analyst Associate certification objectives and covers the skills measured in the PL-300 certification exam.

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.

Our Accreditations

Scroll to Top