Get data from files, databases and APIs - SkilBrill

Skip to content

Home
Courses
About
Contact
Blog
- Freshers

Search for:

Home - Lessons - PL-300 Microsoft Power BI Data Analyst Training - M2 — Power Query Essentials - Get data from files, databases and APIs

PL-300 Microsoft Power BI Data Analyst Training Get data from files, databases and APIs

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

Global Trusted Software Training Partner Since 2022

SkilBrill Training Institute delivers industry-focused technology education that bridges the gap between academic learning and real-world demands. Our structured programs combine foundational theory with practical application, ensuring every graduate is confident and job-ready from day one.

Learn More About Us

© 2026 SkilBrill Training Institute. All Rights Reserved. Privacy Policy Terms Refunds Outcomes

📞 Enroll Now

Start Your Journey

Fill in your details and our team will get back to you within 24 hours

Please enable JavaScript in your browser to complete this form.

Full Name *

Email *

Course Interested In *

Mode of Course *