Module 2: Data preparation with Power Query

Overview This module introduces Power Query, the engine behind data extraction, transformation, and loading (ETL). You’ll learn how to clean, shape, and combine data from multiple sources before analysis. What You’ll Learn Understanding the ETL process in Power BI. Navigating the Power Query Editor interface. Importing data from multiple sources (Excel, Web, SQL Server, CSV). Performing data cleaning: remove duplicates, fill nulls, rename columns. Applying transformations: merge, append, pivot/unpivot. Understanding query dependencies and applied steps. Creating reusable transformation logic with M language basics. Hands-On Practice Import multiple datasets and perform basic cleaning. Merge two tables using common keys. Create a calendar table from scratch in Power Query. Apply column transformations (split, replace, change data type).