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/datasets/shivamb/netflix-shows/data 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