Microsoft · PL-300
Transform the data
PL-300 · Lesson 3 of 15 · 14:07
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 data types, column from examples, conditional and custom columns, Group By, pivot, unpivot, and transpose, and semi-structured JSON data. Includes three original practice questions.
Preview the topics
- A Customers table has a ZIP code column. After the import, a ZIP code like 02134 shows as 2134. Which data type should the column have?
- A budget sheet has a Product column and one column per month, and every month, finance adds a new month column. The query must unpivot every month, including future ones. What should the analyst do?
- A JSON file holds one record per order, and each record contains a list of items. The report needs one row per item, with the product and the quantity in their own columns. What should the analyst do?