Getting & Shaping Data with Power Query

Learning Objectives

• Import multiple related CSV files into one Power BI file
• Clean and transform columns using the Power Query Editor
• Correct data types, trim text, and handle blank or duplicate values
• Explain what Close & Apply does and when to use it

Key Topics Covered

• The Power Query Editor and Applied Steps
• Data types and why they matter
• Renaming, removing, and reordering columns
• Trimming text and fixing dates/currency
• Finding duplicates and blanks
• Conditional columns