Data Cleaning in Power BI Tutorial | ZOMATO Dataset(From Kaggle) | Using Power Query Editor | Part-1
In this tutorial, we will clean the data using Power Query Editor. We have taken a ZOMATO dataset from the Kaggle website. This dataset has the data for all the restaurants listed on Zomato (Bangalore).
This dataset has some abnormalities that we will address in this tutorial.
00:35 Understanding the Zomato Dataset
Data Cleaning Steps:
1:40 Clean the Headers of the dataset
2:00 Deleting redundant columns.
3:15 Renaming the columns.
4:40 Rearranging the columns
5:05 Cleaning individual columns (Using Replace Values & tweaking the 'Applied Steps')
11:30 Creating the CONDITIONAL COLUMN
13:10 Dropping duplicates (Using Sort & Buffer function)
Remove the NaN values from the dataset
In the part2 of this video, we will perform the Data Visualization on this cleaned dataset.
#analytics #powerbi #dataanalytics