Uploaded May 2024 | Updated November 2026, 3 hours ago
Learn how to perform data analysis using a real-life dataset of Netflix shows. We are going to run 10 kinds of analysis & EDA with Power BI.
1) Column Profiling
2) Dealing with missing values (empty / blank)
3) Encoding nulls
4) Imputing missing values
5) Working with Dates and cleaning them
6) Adding new columns of data
7) Splitting / Extracting data
8) Extracting just the first item
9) Text / Sentiment Analysis
10) Filtering unnecessary data (rows or columns)
๐ Download the sample data:
==========================
Visit kaggle.com/datasets/shivamb/netflix-shows/data to download the data
๐ฉโ๐ป LEARN MORE:
===============
My Power BI Course: chandoo.org/wp/power-bi-course
Power BI Intro: chandoo.org/wp/powerbi-introduction
Power Query intro: chandoo.org/wp/power-query-tutorial
Power Query Essentials: chandoo.org/wp/power-query-power-course
โฑ VIDEO TIMESTAMPS:
====================
0:00 - Intro. to data analysis / EDA with Power BI
1:14 - Loading data into Power BI
2:39 - Setting headers & fixing problems with our data
6:52 - Column profiling in Power Query (1)
7:34 - Handling missing values (2)
11:16 - Encoding nulls (3)
13:04 - Imputing with Mode (4)
17:37 - Cleaning up DATE values in Power BI (5)
19:07 - Advanced DATE cleanup scenario (BONUS)
20:49 - Adding calculated columns (6)
23:39 - Splitting up values (7)
26:49 - Extracting just the first value (8)
27:33 - Simple Text Sentiment Analysis (9)
31:02 - Filtering unnecessary data (10)
32:39 - Loading up data to Power BI
33:40 - Next steps for data analysis
๐บ WATCH NEXT
===============
Using DAX to analyse data - youtu.be/PQ5lALdFHCU
Building dashboards with Power BI - youtu.be/i3AR0gt9SHA
Power Query to merge data - youtu.be/PiFAa_jjaEI
Power Query videos playlist: youtube.com/watch?v=PiFAa_jjaEI&list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
Power BI videos playlist: youtube.com/watch?v=9tF1IrfLflg&list=PLmejDGrsgFyDMME3o2CamamZ8w9NxSWWo
Data Analysis videos playlist: youtube.com/watch?v=v2oNWja7M2E&list=PLmejDGrsgFyBCxF37lewZtX6c1kJXyLt3
~
#powerbi #dataanalytics #powerquery #eda #datacleaning
#chandoo
Learn how to perform data analysis using a real-life dataset of Netflix shows. We are going to run 10 kinds of analysis & EDA with Power BI.
1) Column Profiling
2) Dealing with missing values (empty / blank)
3) Encoding nulls
4) Imputing missing values
5) Working with Dates and cleaning them
6) Adding new columns of data
7) Splitting / Extracting data
8) Extracting just the first item
9) Text / Sentiment Analysis
10) Filtering unnecessary data (rows or columns)
๐ Download the sample data:
==========================
Visit kaggle.com/datasets/shivamb/netflix-shows/data to download the data
๐ฉโ๐ป LEARN MORE:
===============
My Power BI Course: chandoo.org/wp/power-bi-course
Power BI Intro: chandoo.org/wp/powerbi-introduction
Power Query intro: chandoo.org/wp/power-query-tutorial
Power Query Essentials: chandoo.org/wp/power-query-power-course
โฑ VIDEO TIMESTAMPS:
====================
0:00 - Intro. to data analysis / EDA with Power BI
1:14 - Loading data into Power BI
2:39 - Setting headers & fixing problems with our data
6:52 - Column profiling in Power Query (1)
7:34 - Handling missing values (2)
11:16 - Encoding nulls (3)
13:04 - Imputing with Mode (4)
17:37 - Cleaning up DATE values in Power BI (5)
19:07 - Advanced DATE cleanup scenario (BONUS)
20:49 - Adding calculated columns (6)
23:39 - Splitting up values (7)
26:49 - Extracting just the first value (8)
27:33 - Simple Text Sentiment Analysis (9)
31:02 - Filtering unnecessary data (10)
32:39 - Loading up data to Power BI
33:40 - Next steps for data analysis
๐บ WATCH NEXT
===============
Using DAX to analyse data - youtu.be/PQ5lALdFHCU
Building dashboards with Power BI - youtu.be/i3AR0gt9SHA
Power Query to merge data - youtu.be/PiFAa_jjaEI
Power Query videos playlist: youtube.com/watch?v=PiFAa_jjaEI&list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
Power BI videos playlist: youtube.com/watch?v=9tF1IrfLflg&list=PLmejDGrsgFyDMME3o2CamamZ8w9NxSWWo
Data Analysis videos playlist: youtube.com/watch?v=v2oNWja7M2E&list=PLmejDGrsgFyBCxF37lewZtX6c1kJXyLt3
~
#powerbi #dataanalytics #powerquery #eda #datacleaning
#chandoo










