DATA WRANGLING AND ETL USING POWER QUERY
Course Curriculum
INTRODUCTION TO THE COURSE
Available in
days
days
after you enroll
EXAMPLES
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
Please purchase from:
https://www.havishmconsulting.com/shop
Login details will be shared immediately once payment is received.