Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn to automate your data-cleaning workflow using Power Query and eliminate repetitive tasks forever in this 19-minute tutorial. Import messy data and apply powerful transformation tools to build a refreshable cleaning process that updates with a single click. Master techniques for handling inconsistent formatting, removing duplicates, splitting columns, and standardizing data types while creating reusable queries that can be applied to new datasets automatically. Discover how to connect to various data sources, perform complex transformations without writing code, and establish a systematic approach to data preparation that saves hours of manual work. Perfect for Excel users who want to achieve faster, cleaner, and more reliable results while building scalable data processing workflows that adapt to changing requirements.
Syllabus
Data Cleaning With Power Query (Automate Boring Tasks)
Taught by
Simon Sez IT