I will teach you power query from scratch

This online course teaches you how to automate the process of extracting, cleaning, transforming, and loading data using Power Query (available in both Microsoft Excel and Power BI). Instead of spending hours manually copying, pasting, reformatting, and fixing spreadsheets, you will learn how to build automated, repeatable workflows that clean and format messy data with just a single click.

Key Learning Objectives

• Connect & Import Data: Extract raw data from multiple sources, including Excel workbooks, CSV files, databases, and entire folders.
• Clean & Transform Data: Standardize messy data by handling missing values, splitting text, modifying data types, and removing duplicates.
• Reshape Datasets: Master advanced structural transformations such as Pivoting, Unpivoting, grouping, and aggregating data for analytical modeling.
• Combine & Integrate Queries: Append multiple files or tables together and perform joins using Merge Queries.
• Automate Data Loading: Load transformed datasets back into Excel or Power BI Data Models, setting up simple refresh mechanisms for future updates.
• Introduction to M Language: Gain foundational insights into the underlying code behind Power Query steps to