© 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 Jolly1  
(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 ...

Get Microsoft Power BI Data Analyst Certification Companion: Preparation for Exam PL-300 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.