PL-300: Model the Data (relationships, DAX, star schema)
Model the Data (relationships, DAX, star schema) is one of the skill areas tested on the Power BI Data Analyst (PL-300) exam. Below are free PL-300 practice questions with worked answers and a concept diagram — each with a plain-language explanation. Practice the first 10 questions of PL-300 free, no signup.
The concept, in one picture
Try a real PL-300 question
You are developing a Power BI report from an Azure SQL database called erp1. You import three tables: Products (the product catalog), Orders (order header information), and Order Line Items (product ID, quantity, and price for each line of an order). You must analyze orders over time with a total order value measure, and analyze orders by product attributes, while keeping visual interactions fast. What should you do first?
- ✓ In Power Query, merge the Orders query with the Order Line Items query.
- Use a DAX function to add a calculated column of product categories to the Orders table.
- In Power Query, merge the Order Line Items query with the Products query.
- Use a DAX function to count the number of orders per product.
Total order value needs the quantity and price stored in Order Line Items joined to each order. Doing that merge in Power Query resolves the join at load time so visuals respond quickly, making it the correct first step.
Practice PL-300 free
The first 10 questions of every exam are free. No signup, no email wall.
Start practicing →Get a free PL-300 study plan by email
A short plan to work through PL-300 by skill area, plus a note when we add new questions. Optional — the practice above stays free. No spam, unsubscribe anytime.