Microsoft · PL-300
Shape the tables for the model
PL-300 · Lesson 4 of 15 · 19:40
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the PL-300 exam (Microsoft Certified: Power BI Data Analyst Associate). In this lesson: fact and dimension tables, reference and duplicate queries and their impact on refresh, merge join kinds and append, surrogate and composite keys, and disabling load for staging queries. Includes three original practice questions.
Preview the topics
- A flat Sales table repeats the product name and category on every order line. The analyst wants a Product dimension with one row per product. Which steps fit?
- Five loaded queries reference a Sales query that calls a slow web API, and the refresh now takes far too long. Which change reduces the number of calls to the API?
- The analyst needs the products that were never sold. The Products query lists every product, and the Sales query holds every order line. Which merge fits?