Autoplay
Autocomplete
Previous Lesson
Complete and Continue
DATA WRANGLING AND ETL USING POWER QUERY
INTRODUCTION TO THE COURSE
INTRODUCTION THE COURSE (3:21)
EXAMPLES
POWER QUERY - COMBINE DATA FROM MULTIPLE SHEETS (8:48)
POWER QUERY - INTRODUCTION TO THE INTERFACE (17:20)
POWER QUERY - COMBINE FROM MISMATCH COLUMNS (5:29)
POWER QUERY - COMBINE FROM MULTIPLE WORKBOOKS (4:05)
POWER QUERY - COMBINE FROM MISMATCH SHEETS (4:05)
POWER QUERY - COMBINE FROM MULTIPLE WORKBOOKS AND SHEETS (6:42)
POWER QUERY - GET A LIST OF ALL FOLDERS (2:40)
POWER QUERY - FILL MISSING VALUES (3:21)
POWER QUERY - LIST ALL POSSIBLE COMBINATIONS (3:24)
POWER QUERY - SPLIT BY DELIMITER (1:56)
POWER QUERY - SPLIT INTO ROWS (3:19)
POWER QUERY - COMBINE ROWS (3:57)
POWER QUERY - TARGET VS. ACHIEVEMENT (4:58)
POWER QUERY - FIND TOP ANALYST (10:06)
POWER QUERY - EXTRACT TEXT AND NUMBER (4:40)
POWER QUERY - UNPIVOT (3:58)
POWER QUERY - PARAMETRIZE GET DATA FROM SELECTED FILE (12:26)
POWER QUERY - RUNNING TOTAL (4:05)
POWER QUERY - REPLACE VLOOKUP (6:06)
POWER QUERY - GET DATA FROM INTERNET (2:59)
POWER QUERY - COLUMN FROM EXAMPLES (13:13)
POWER QUERY - CONNECT TO PDF (2:37)
POWER QUERY - CREATE DATE CALENDAR (3:53)
POWER QUERY - CALCULATE AGE (1:32)
POWER QUERY - CREATE INDEX COLUMN FOR GROUP (2:35)
POWER QUERY - RANDOM LIST (3:17)
POWER QUERY - SEARCHING FOR MISMATCHED NAMES USING FUZZY MATCH (10:01)
POWER QUERY - CONDITIONAL COLUMN (4:47)
POWER QUERY - REMOVE DUPLICATE ROWS (1:59)
POWER QUERY - SEE LIBRARY OF FUNCTIONS (1:57)
POWER QUERY - CONNECTING TO DATABASE (1:50)
POWER QUERY - CREATE CONNECTION (4:37)
POWER QUERY - EXCHANGE RATE (4:29)
SOLUTIONS
SOLUTIONS
GET YOUR CERTIFICATE
INTRODUCTION THE COURSE
Complete and Continue