Cross-filter direction - SkilBrill

PL-300 Microsoft Power BI Data Analyst Training Cross-filter direction

PL-300 Microsoft Power BI Data Analyst Training

0% Completed

M1 — Power BI and PL-300 Scope

PL-300 skills measured

Power BI Desktop vs Service

Licensing overview

Tour of the desktop tool

M2 — Power Query Essentials

Get data from files, databases and APIs

Data types and locale

Pivot / Unpivot, merge, append

M3 — Data Modelling with Star Schema

Fact and dimension tables

Relationships and cardinality

Cross-filter direction

Role-playing dimensions

M4 — DAX Fundamentals

Calculated columns vs measures

Filter context and row context

CALCULATE, FILTER, ALL

Time intelligence

M5 — Advanced DAX

Iterator functions (SUMX, AVERAGEX)

Variables and optimisation

Advanced time intelligence

DAX query view and performance

M6 — Reports and Visuals

Bookmarks and selection pane

Drillthrough and tooltips

Accessibility in reports

M7 — Power BI Service

Workspaces and apps

Datasets, reports and dashboards

Data refresh schedules

Gateways for on-prem sources

M8 — Dataflows, Datasets and Endorsement

Shared datasets

Endorsement and certification

M9 — Deployment Pipelines and ALM

Dev → Test → Prod workflow

Rules and parameter rules

Git integration

REST APIs for automation

M10 — Security, Row-Level and Object-Level

Row-level security roles

Object-level security

Workspace roles

Sensitivity labels

M11 — AI Insights and Performance Tuning

AI visuals: decomposition tree, key influencers

Smart narratives

Performance analyser

Optimising models

M12 — Capstone and PL-300 Mocks

End-to-end BI solution

Stakeholder presentation

PL-300 mapped mocks

Announcements Course Info