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

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/upl... 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 people who already know & use Power Query a lot 🕐 Video Chapters 0:00 - Introduction 5:30 - Brief Intro Power Query and how it fits in 11:40 - Sample Data & how to load it into PQ in Power BI 19:00 - Power Query UI Explained 24:00 - Data Cleaning basics with Power Query - Removing columns 28:00 - Date cleanup 32:30 - Text transformations in Power Query 37:30 - Arithmetic operations 41:00 - How to think about Power Query 44:30 - Salary bucket (conditional columns) 52:00 - Reference queries, multiple outputs from one source 56:30 - Using dependency view to understand various queries in your data 58:30 - Introduction to parameters and automation with PQ 1:02:00 - Closing & loading the data, testing everything in Power BI 1:05:30 - Adding new data, changing file names (parameter testing) 1:07:40 - Fixing refresh errors 1:11:00 - Using other sources (demo with SQL Server) 1:13:30 - Q&A 1:26:30 - Doing the same in Excel (demo with Blank Query, Copy pasting M Code) #POWERQUERY #POWERBI