Technologies / Data & Analytics

Microsoft Power BI Data Analyst (PL-300) — Exam Preparation

A four-day course preparing for Microsoft exam PL-300 (Power BI Data Analyst Associate). The programme covers the four exam areas in the skills outline effective 20 April 2026: preparing data in Power Query, modelling and DAX, reports (including a Copilot demonstration), and managing and securing the Power BI service.

A four-day course preparing for Microsoft exam PL-300 and the Microsoft Certified: Power BI Data Analyst Associate certification.

Microsoft Power BI Data Analyst (PL-300) — Exam Preparation is an EITT programme built around the skills outline Microsoft publishes for this exam. Each day covers one of the four exam areas, and the module titles show their weights so participants know where to focus. The course runs on-site or online.

The training programme covers the key areas:

Day 1 - Prepare the data (25–30% of the exam)
Day 2 - Model the data and DAX (25–30% of the exam)
Day 3 - Visualize and analyze the data (25–30% of the exam)
Day 4 - Manage and secure Power BI (15–20% of the exam) and a practice exam

Exercises use a single dataset throughout: from raw files in Power Query, through the model and DAX measures, to a published report secured with row-level security. On the last day participants take a practice exam and review with the trainer the areas that need more work before their exam date.

The exam is not included in the course price — it is booked separately through your Microsoft Learn profile.

Benefits

Prepare and clean data in Power Query and shape it into fact and dimension tables
Design a data model with correct relationships, a date table and role-playing dimensions
Write DAX measures with CALCULATE, time intelligence and calculation groups, and diagnose their performance
Build reports with navigation, bookmarks and drillthrough, and know what Copilot can do in reports
Publish and share content in workspaces and secure it with RLS and roles
Assess your own readiness for exam PL-300 based on a practice exam

Who is this training for?

Data and business analysts who build reports in Power BI and want to pass exam PL-300

Controlling and reporting specialists moving from Excel to Power BI

Report authors responsible for publishing and sharing content in the Power BI service

Anyone planning to earn the Microsoft Certified Power BI Data Analyst Associate certification

Prerequisites

Hands-on work with Power BI Desktop (at least basic reports)
Excel skills at the level of PivotTables
Basic database concepts: table, key, relationship
Some DAX is helpful — it can be covered in the "DAX Fundamentals in Power BI" course

Training program

Connecting to data sources and to a shared semantic model; data source settings, credentials and privacy levels
Choosing Import, DirectQuery or DirectLake — impact on performance and refresh
Parameters in Power Query
Profiling data: column statistics, null and unexpected values, import errors
Data types, conditional and custom columns, grouping and aggregating rows
Pivot, unpivot and transpose; converting semi-structured data to a table
Merging and appending queries; reference versus duplicate queries
Fact and dimension tables, relationship keys, query load configuration

Table and column properties, role-playing dimensions, a common date table
Relationship cardinality and cross-filter direction
Calculated columns and tables versus measures — when to use which
Aggregation measures, the CALCULATE function, time intelligence
Semi-additive measures, basic statistical functions, quick measures
Calculation groups
Model performance: removing unnecessary rows and columns, reducing granularity, Performance Analyzer and DAX query view

Selecting and formatting visuals, themes, conditional formatting, slicers and filters
Copilot in reports (demonstration): narrative visual, a new report page and suggested content for it
Configuring the report page, sorting visuals, visual calculations in DAX; when to use a paginated report
Bookmarks, custom tooltips, visual interactions, navigation and drillthrough
Sync slicers, the Selection pane, export settings, reports for mobile devices
Personalised visuals, report accessibility, automatic page refresh
Patterns and trends: the Analyze feature, grouping, binning and clustering, AI visuals, reference lines, error bars, forecasting, outliers and anomalies, semantic model summary with Copilot (demonstration)

Creating and configuring workspaces, roles, publishing and updating items, Power BI apps
Dashboards, distribution methods, subscriptions and data alerts
Promoting and certifying content, data gateways, semantic model scheduled refresh
Item-level and semantic model access, row-level security (RLS) and group membership in roles, sensitivity labels
Exam logistics: registration, question formats, passing score, certification renewal
A practice exam and a review of the areas participants found hardest

Delivery Methods

Online

Convenience of participating from anywhere
Interactive live sessions with trainer
Materials available for 30 days
No travel costs

On-site

Direct contact with trainer and group
Intensive hands-on workshops
Networking with other participants
Full focus on learning

Training Topics

Frequently asked questions

Does the course price include the PL-300 exam?

No. The course prepares you for the exam; the exam itself is booked and paid for separately through your Microsoft Learn profile. Participants take a practice exam at the end of the course.

What score do I need to pass exam PL-300?

According to Microsoft's PL-300 study guide, a score of 700 or greater is required to pass.

Does the programme reflect the current exam scope?

Yes. The programme follows the skills outline Microsoft publishes for exam PL-300, in the version effective 20 April 2026: prepare the data (25–30%), model the data (25–30%), visualize and analyze the data (25–30%), and manage and secure Power BI (15–20%).

How long is the Power BI Data Analyst Associate certification valid?

Microsoft associate certifications expire annually. You can renew by passing a free online assessment on Microsoft Learn.

How much does the course cost and how do I sign up?

The course costs PLN 4,500 net per person. To sign up or request a group offer, contact us by phone or through the form on this page. We also run closed courses for companies.