Power BI Data Analyst
From raw data to secured reports: Power Query, star schemas, DAX, storytelling, workspaces and row-level security, with a DAX console in the browser.
Syllabus
5 skill areas following the official outline dated 20 Apr 2026. Free lessons are open to read now.
0
Start here
What Power BI is, the course dataset, and how it connects to the Power Platform.
2 lessons · 2 hrOrientation
Start here
What Power BI is, the course dataset, and how it connects to the Power Platform.
1
Prepare the data
Connect to sources, profile and clean data, and shape it with Power Query.
3 lessons · 3 hr25–30% of exam
Prepare the data
Connect to sources, profile and clean data, and shape it with Power Query.
- B.3 Get and connect to data50 min · lesson, lab and quiz Enrolled students
- B.4 Profile and clean data55 min · lesson, lab and quiz Enrolled students
- B.5 Transform and shape data55 min · lesson, lab and quiz Enrolled students
2
Model the data
Star schemas, relationships, DAX measures, CALCULATE, time intelligence and performance.
5 lessons · 5 hr25–30% of exam
Model the data
Star schemas, relationships, DAX measures, CALCULATE, time intelligence and performance.
- B.6 Star schema and relationships55 min · lesson, lab and quiz Enrolled students
- B.7 DAX fundamentals60 min · lesson, lab and quiz Enrolled students
- B.8 CALCULATE and filter context60 min · lesson, lab and quiz Enrolled students
- B.9 Time intelligence and advanced calculations60 min · lesson, lab and quiz Enrolled students
- B.10 Optimize model performance50 min · lesson, lab and quiz Enrolled students
3
Visualize and analyze
Build reports, tell stories with bookmarks and drillthrough, and find trends with AI.
3 lessons · 3 hr25–30% of exam
Visualize and analyze
Build reports, tell stories with bookmarks and drillthrough, and find trends with AI.
- B.11 Build reports55 min · lesson, lab and quiz Enrolled students
- B.12 Storytelling and usability55 min · lesson, lab and quiz Enrolled students
- B.13 Find patterns and trends55 min · lesson, lab and quiz Enrolled students
4
Manage and secure
Workspaces, apps, refresh, gateways, row-level security and sensitivity labels.
2 lessons · 2 hr15–20% of exam
Manage and secure
Workspaces, apps, refresh, gateways, row-level security and sensitivity labels.
- B.14 Workspaces, sharing and refresh60 min · lesson, lab and quiz Enrolled students
- B.15 Security and governance60 min · lesson, lab and quiz Enrolled students
Enrol in PL-300
Get in touch and your trainer will set up your student login. After PL-900.
Other courses
Based on Microsoft’s PL-300 study guide (skills measured as of 20 April 2026). Power BI Desktop runs on Windows. Check the official study guide before you book the exam.