Data Cleaning and Transformation

In this lesson, we will learn data cleaning and transformation in Power BI. We will understand how to clean text, handle blank and duplicate values, use Replace Values, Split Column, Merge Columns, Conditional Column, and Refresh logic with Power Query. ## Lesson objective In this lesson, we will learn data cleaning and transformation in Power BI. In the previous lesson, we learned how to import data into Power BI and covered Power Query basics. We learned how to import Excel and CSV files, understand the Navigator window, the difference between Load and Transform Data, Power Query Editor, Applied Steps, renaming columns, and changing data types.