Рет қаралды 31,365
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 www.kaggle.com/datasets/shiva... to download the data
👩💻 LEARN MORE:
===============
My Power BI Course: chandoo.org/wp/power-bi-course/
Power BI Intro: chandoo.org/wp/powerbi-introd...
Power Query intro: chandoo.org/wp/power-query-tu...
Power Query Essentials: chandoo.org/wp/power-query-po...
⏱ 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 - • Learn Power Pivot & DA...
Building dashboards with Power BI - • Make an Incredible Fin...
Power Query to merge data - • Power Query Tutorial -...
Power Query videos playlist: • Power Query Tutorial -...
Power BI videos playlist: • Your first 10 minutes ...
Data Analysis videos playlist: • Beginner to Pro FREE E...
~
#powerbi #dataanalytics #powerquery #eda #datacleaning
#chandoo