Learn how to clean business data and perform Exploratory Data Analysis (EDA) using Power BI in this handson video. You will become a data ninja after this.

Topics covered:
POWER QUERY for data cleaning and EDA
How to deal with missing values, blanks, nulls and errors in data
Working with date values and data type conversion
Creating new columns from existing data
Filtering and removing columns from data
Analyzing column profile, distribution and quality
Lots of Power Query tips & tricks

Get the sample data:
From Kaggle: https://www.kaggle.com/datasets/ariyo...
From Github: https://github.com/chandooorg/Power...

Sample Power BI Workbook (with all data cleanup steps):

Grab the completed Power BI workbook (with a few more visuals) from my Github repo: https://github.com/chandooorg/Power...

‍ Power BI Full Course:
Stop searching and wasting time on Youtube for tutorials. Join my detailed, stepbystep Power BI course and learn everything in one go. Join here: https://chandoo.org/wp/powerbicourse/

⏱Video Chapters:
================
0:00 Introduction to Data Cleaning & EDA with Power BI
1:29 Importing data to Power BI and intro to Power Query
5:40 Working with null or missing values
6:39 Column Profiling
10:08 Imputing missing values (director & country example)
19:34 Cleaning date values
24:01 Rating column cleanup and EDA
26:14 Working with Duration and Adding columns
31:00 Column distribution
32:55 Filtering out rows or columns
34:20 Subbarao Check
36:14 Loading data into Power BI for visual analysis

~

Thanks for watching and have a beautiful day ahead :)

#PowerBI #EDA #datacleaning