80% of data analysis is cleaning data. This course teaches you how to automate that entire process. Learn how to use Power Query (in both Excel and Power BI) to build unbreakable Extract, Transform, Load (ETL) pipelines that clean messy data with a single click.

• Automate the consolidation of dozens of files from folders into a single, clean dataset.
• Perform complex transformations including unpivoting data, splitting columns, and conditional logic.
• Understand the basics of M Code to edit advanced queries and troubleshoot transformation errors.