Master Power BI Data Transformation in 20 Minutes (Split, Group By, Clean Data) | upGrad Learning
Power Query transform features can save you 10 or more hours every single week — most users just don't know they exist. In this video, I'll show you the exact transforms that eliminate repetitive manual work and make your data cleaning process fully automatic.If you're an Excel user dealing with messy data every week, or a data analyst who's tired of doing the same cleanup tasks over and over, this Power Query tutorial will change how you work with data forever.
Following are the concepts in this video:
00:00 - Introduction to transform options
00:33 - Review of previous session and introducing split columns
01:01 - Understanding multiple information in one column
01:29 - The importance of splitting columns
01:57 - Split column options (delimiter, number of characters, position, case changes)
02:28 - Splitting by delimiter (leftmost, rightmost, every occurrence)
02:56 - Example of splitting by leftmost delimiter
03:22 - Changing split settings (rightmost, every occurrence)
03:51 - Split into three parts and combining columns (brief mention)
04:20 - Splitting by number of characters
04:49 - Specifying number of characters for splitting
05:22 - Splitting once vs. repeatedly
05:50 - Splitting from right 06:20 - Splitting by position
06:51 - Example of splitting by position
07:23 - Advanced options for splitting (columns or rows)
07:52 - Splitting by lowercase to uppercase
08:22 - Explaining the logic of case-based splitting
08:49 - Splitting by uppercase to lowercase
09:22 - Splitting by digit to non-digit and non-digit to digit
09:55 - Example of splitting by non-digit to digit
10:25 - Cleaning date columns and error handling
10:54 - Understanding "Group By"
11:26 - Example of grouping by department
11:51 - Grouping options (column to group by, new column name, operation)
12:18 - Performing count aggregation with "Group By"
12:49 - Changing "Group By" settings (sum, average)
13:14 - Average aggregation example
13:40 - Advanced grouping options (multiple aggregations)
14:08 - Example of advanced grouping
14:38 - Changing data type (text, whole number)
15:03 - Impact of changing data type with errors
15:32 - Dangers of removing errors without proper cleaning
16:00 - Using the first row as a header (Promote Headers)
16:32 - Automatic header promotion by Power BI
16:59 - How Power BI detects and promotes headers
17:27 - Explaining automatic type change
17:55 - Demoting headers and manually specifying column names
18:22 - Replacing values
18:51 - Example of replacing "HR" with "Human Resource" and removing symbols
19:18 - Importance of cleaning before data type conversion
19:50 - Transform tab options (Group By, Use First Row as Header, Transpose, Reverse, Counter Row)
20:14 - Understanding Transpose
20:43 - Practical considerations for transposing data
21:10 - Reversing rows
#PowerBI #DataVisualization #DataTransformation #ExcelToPowerBI #PowerBITutorials #LearnPowerBI #PowerBITips #PowerQuery #PowerBIDashboard #MicrosoftExcel #PowerBITraining #Dashboards #upgrad #microsoftpowerbi