Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

J. JollyMicrosoft Power BI Data Analyst Certification CompanionCertification Study Companion Serieshttps://doi.org/10.1007/978-1-4842-9013-2_4

4. Clean, Transform, and Load the Data

Jessica Jolly¹  

(1)

Evanston, IL, USA

 

This chapter covers exam topics around cleaning data, transforming data, and loading that data into Power BI where it can be analyzed. We cover the Power Query Editor, the M language that underlies transformations, and various topics relating to data quality.

Accessing the Power Query Editor

After initiating the Get data procedure within the Desktop, the Power Query Editor (PQE) will open in a new, separate window. This is intentional—the two ...