← Back to courses
Data Science and AI
Power Query Data Cleaning
One week to turning messy data into a clean table
A one-week classroom course on the first skill area of Microsoft's PL-300 outline, prepare the data: connecting to sources, profiling and cleaning, and transforming and loading. It covers one skill area of four and prepares for no exam on its own.
5Modules
BeginnerLevel
1 weekDuration
COURSE THUMBNAIL
What you will be able to do
Connect Power Query to files and databases
Find and fix data quality problems
Reshape and combine tables ready for analysis
Course outline
01
Getting or connecting to data
02
Profiling data: statistics and column properties
03
Resolving nulls, errors and inconsistencies
04
Transforming columns; pivot and unpivot
05
Merging and appending queries
Tools you will use
Power QueryPower BI DesktopMicrosoft Excel
What you need
Comfortable working with spreadsheets
