Clean That Data - Fast Data Cleaning Techniques in Power Query
Learn how to clean your data efficiently using Power Query! In this comprehensive tutorial, whether you're dealing with duplicates, missing values, or inconsistent data formats, Power Query has got you covered. Watch now and unlock the full potential of your data!
You can download the dataset here and follow along: https://docs.google.com/spreadsheets/d/19D_cTPUVzDp29YHWClTe2Z09bk194R2S/edit?usp=sharing&ouid=110473281517375131588&rtpof=true&sd=true
0:00 Introduction
0:45 Dataset Introduction
2:00 Loading Table into Power Query
3:12 Splitting Columns
4:35 Merging a Column
5:41 Text Transformations
7:09 Removing Spaces
7:54 Replacing Values
9:08 Removing Duplicates
10:32 Keep First Duplicate Value
12:44 Load Data Back to Excel
Видео Clean That Data - Fast Data Cleaning Techniques in Power Query канала EXCEL 4 UR PARENTS
You can download the dataset here and follow along: https://docs.google.com/spreadsheets/d/19D_cTPUVzDp29YHWClTe2Z09bk194R2S/edit?usp=sharing&ouid=110473281517375131588&rtpof=true&sd=true
0:00 Introduction
0:45 Dataset Introduction
2:00 Loading Table into Power Query
3:12 Splitting Columns
4:35 Merging a Column
5:41 Text Transformations
7:09 Removing Spaces
7:54 Replacing Values
9:08 Removing Duplicates
10:32 Keep First Duplicate Value
12:44 Load Data Back to Excel
Видео Clean That Data - Fast Data Cleaning Techniques in Power Query канала EXCEL 4 UR PARENTS
Power Query Data Cleaning Excel Tutorial Data Transformation Data Analysis Excel Power Query Data Management Data Preparation Remove Duplicates Handle Missing Values Data Formatting Power Query Tips Data Workflow Advanced Data Cleaning Automate Data Cleaning Excel Data Cleaning Power BI Data Cleaning Data Cleaning Techniques
Комментарии отсутствуют
Информация о видео
26 мая 2024 г. 0:18:46
00:13:57
Другие видео канала
