Power BI Data Analyst Associate (PL-300) Cert Prep: Cleaning, Transforming, and Loading Data in Power BI

Learn how to clean, transform, and load data on Power BI.

Introduction

• Transform your data for accurate reporting with Power Query in Power BI
• The PL-300 certification and exam

1. Understanding Your Power BI Data

• The data treatment process on Power BI
• Profiling Power BI data
• Cleaning, transforming, and loading the data
• Profiling and loading your data

2. Transforming Rows and Columns on Power Query

• Cleaning up your data
• Row and column transformations

3. Manipulating Queries and Tables on Power Query

• Identifying keys on your Power BI model
• Shaping and transforming tables
• Referencing and duplicating queries
• Work with tables and queries

Conclusion

• Power BI: Additional resources