Power BI Data Analyst Associate (PL-300) Cert Prep: Cleaning, Transforming, and Loading Data in Power BI
1h 16mIntermediate2023-04-18
Authors
Emilio Melo
Cloud solutions architect with 20+ years of IT experience
Course details
Do you work with Microsoft Power BI, or are you preparing for the Power BI Data Analyst (PL-300) exam? This course, from experienced cloud solutions architect Emilio Melo, can help you. In this course, you will learn how to clean, transform, and load data on Power BI. Build your understanding of Power Query by learning about the data treatment process, how to profile data, and how to clean, transform, and load it into Power BI. Learn how to transform rows and columns, as well as manipulate queries and tables, on Power Query. Plus, get a quick overview of additional resources you can use to prepare for the exam. This course is part of a series designed to help learners earn their Power BI Data Analyst Associate certification from Microsoft.
Skills covered
Power BIData EngineeringData AnalysisCert PrepData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Transform your data for accurate reporting with Power Query in Power BI
- 02 - The PL-300 certification and exam
1. Understanding Your Power BI Data
- 03 - The data treatment process on Power BI
- 04 - Profiling Power BI data
- 05 - Cleaning, transforming, and loading the data
- 06 - Profiling and loading your data
2. Transforming Rows and Columns on Power Query
- 07 - Cleaning up your data
- 08 - Row and column transformations
3. Manipulating Queries and Tables on Power Query
- 09 - Identifying keys on your Power BI model
- 10 - Shaping and transforming tables
- 11 - Referencing and duplicating queries
- 12 - Work with tables and queries
Conclusion
- 13 - Power BI - Additional resources