End to End Power Query Data Cleaning Masterclass [FREE Workbook]

By Chandoo

Community Score: 50% | 18.8K views | 4w

0 community ratings: null thumbs up, null thumbs down

In this beginner to PRO session, learn Power Query to automate data cleaning, transformation tasks. We will be using a real-life dataset to perform data cleaning with Power Query (for Power BI). Sample workbook: https://chandoo.org/wp/wp-content/uploads/2026/04/pq-data-cleanup.xlsx What do I learn? ✔️ Introduction to Power Query in Power BI ✔️ How to understand Power Query UI ✔️ Data cleaning basics (removing columns, renaming) ✔️Text transformation examples ✔️ Working with Date columns ✔️ Conditional (IF THEN ELSE) columns in Power Query ✔️ Business operations on data ✔️ Reference queries (one data source, multiple outputs) ✔️ Dependency view and how to use it ✔️ Automation with Power Query - Parameters ✔️ Fixing errors ✔️ Basic analysis of data in Power BI after Load ✔️ Refresh process ​ Who is this for? 👶 Power Query beginners 👩‍💻People who work with lots of data (in Excel or Power BI) ⚙️ Looking to automate / simplify data management / cleaning processes 🚫NOT for peopl

Tags: power query tutorial, data analyst, how to become a data analyst, data analytics, power bi tutorial, clean data in excel, microsoft power bi, end to end power query project, Power Query class, Power Query course, Power Query for beginners