📈 Power BI Data Analyst PL-300 (Exam-Prep)
Free exam-prep for Microsoft Power BI Data Analyst (PL-300) with a signed certificate. Learn the modules, pass the 10-question exam, EN/FR/AR, no account.
Last updated: June 2026
An independent, free exam-preparation course that works through the publicly published PL-300 skills-measured outline — preparing the data, modeling the data, visualizing and analyzing the data, and managing and securing Power BI — with visual lessons, original self-check questions and a final exam. It is awareness and preparation only; it is not the official Microsoft course or exam and is not affiliated with or endorsed by Microsoft. The course is organized into 10 modules, ending with a final exam (pass mark 70%). It is independent, free exam-preparation training — not an official or accredited review course.
What you'll learn
- Get Data & Connection Modes: Import vs. DirectQuery
- Power Query: Clean, Transform & Shape Data
- Data Modeling: Relationships, Star Schema & Cardinality
- DAX Essentials: Measures, Calculated Columns & Time Intelligence
- Model Optimization & Performance
- Create Reports & Visualizations
- Formatting, Interactivity, Bookmarks & Accessibility
- Analyze Data: AI Visuals, Q&A, and Trends
- Manage Workspaces, Semantic Models & Deployment
- Security: Row-Level Security, Sharing & Governance
Learning objectives
- Understand that this is independent PL-300 exam-prep over the public skills outline, not the official Microsoft course or exam
- Name the four exam domains and their weightings: Prepare the data (25–30%), Model the data (25–30%), Visualize and analyze the data (25–30%), Manage and secure Power BI (15–20%)
- Connect to and profile data from files, databases, the web and dataflows, choosing import, DirectQuery or composite storage modes
- Clean, transform and shape data in Power Query (M): types, errors, pivot/unpivot, append/merge, and parameters
- Design a star-schema model with fact and dimension tables, correct relationships, cardinality and a dedicated date table
- Write DAX measures, calculated columns and tables, and apply time-intelligence and filter-context concepts
- Build effective reports: visual selection, formatting, interactions, drillthrough, bookmarks, tooltips and accessibility
- Identify patterns and outliers, use the Analyze and Q&A features, and apply AI visuals such as Key influencers
- Manage workspaces, apps, datasets, gateways, refresh schedules and row-level security (RLS)
- Sit a 10-question exam-style final (80% to pass) built from original questions spanning all four domains