End to End Data Analysis Project with Power BI - Netflix Example 📺

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 https://www.kaggle.com/dataset....s/shivamb/netflix-sh to download the data

👩‍💻 LEARN MORE:
===============

My Power BI Course: https://chandoo.org/wp/power-bi-course/
Power BI Intro: https://chandoo.org/wp/powerbi-introduction/
Power Query intro: https://chandoo.org/wp/power-query-tutorial/
Power Query Essentials: https://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 - https://youtu.be/PQ5lALdFHCU
Building dashboards with Power BI - https://youtu.be/i3AR0gt9SHA
Power Query to merge data - https://youtu.be/PiFAa_jjaEI

Power Query videos playlist: https://www.youtube.com/watch?v=PiFAa_jjaEI&list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
Power BI videos playlist: https://www.youtube.com/watch?v=9tF1IrfLflg&list=PLmejDGrsgFyDMME3o2CamamZ8w9NxSWWo
Data Analysis videos playlist: https://www.youtube.com/watch?v=v2oNWja7M2E&list=PLmejDGrsgFyBCxF37lewZtX6c1kJXyLt3

~

#powerbi #dataanalytics #powerquery #eda #datacleaning
#chandoo