Microsoft · PL-300
Profile and clean the data
PL-300 · Lesson 2 of 15 · 8:46
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: column quality, distribution, and profile, inconsistent and null values with Replace values, Trim, and Fill down, step-level and cell-level errors, and common import errors. Includes three original practice questions.
Preview the topics
- The column quality of a Price column shows 100% valid values. Yet the analyst knows that some prices further down the file are typed as text. What should the analyst do first?
- In a sales sheet, the store name appears only on the first row of each block, and the rows below it are null. Every row must show its store. Which transformation fits?
- After a refresh, a Discount column shows Error in about twenty cells, where the source has the text none. The report must load, and those discounts must count as zero. What should the analyst do?