End to End Data Analysis Project with Power BI

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

Рет қаралды 30,285

Күн бұрын

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

Пікірлер: 52

@skhulilebuthelezi2365 Ай бұрын

I haven't watched the video yet, but I've already liked it because I know that watching it will make my life easier. I've never regretted watching your videos sir. I so wish you can post at least 2 videos per week in Excel, PowerBI, SQL and Tableau.

@chandoo_ 29 күн бұрын

Wow, thank you!

@sathyamanikantabk4483 28 күн бұрын

6:47 U just have to do the same thing like wyler in Notepad++.....and blank will go off and this is a good workaround for limited blanks and errors....hope u teach us one great generalized strategy to treat these kinds of errors

@kingsfordsconspiracytheori9066 Ай бұрын

Learnt a lot from this video. Thanks Man!

@veraadjei2404 Ай бұрын

Very Insightful. Thank you.

@cloud-tutorials 23 күн бұрын

Nice video with no nonsense, comming right to the point. Appreciate your effort

@ArifKhan-qo9jw Ай бұрын

Today, i got chance to refresh my knowledge. Thanks Chandoo for your valuable video.

@choppinbored98 16 күн бұрын

Loved it! Will go through and follow along other practical examples on your channel. Thanks!

@jinwei7645 28 күн бұрын

Nice video Chandoo! Looking forwards to watching more to come👍👍

@chrism9037 Ай бұрын

Really nice video Chandoo thanks!

@wonder-2023 Ай бұрын

Can you show more about sales data analysis with some summaries? Many thanks!

@EmiKreativ Ай бұрын

You have a Chandoo-fan in Hungary, I love your videos and your humor😘

@praveenkumardasu8915 29 күн бұрын

Thank you chandu.. Adding jewel to the crown with all your videos

@chandoo_ 29 күн бұрын

My pleasure 😊

@krishnakantapanda6835 21 күн бұрын

What are you doing here Bill? 🤣🤣🤣🤣🤣 Loved it!!

@kallapallisai9959 17 күн бұрын

Your teaching is awesome sir From Visakhapatnam

@md.nuralammiah9587 Ай бұрын

This is a very informative video. Like to have more video that can cover every corner of Data Analysis.

@harshitthakur8300 27 күн бұрын

Great structured video ❤ and it was very intersting and kbowlegable.

@magudeswaranm3744 17 күн бұрын

Thanks Chandoo for sharing this useful video, will try this to make a insightful Dashboards..

@gsrsakhilakhil528 29 күн бұрын

thanks chandoo garu learned new things in PQ. Please do videos on DAX too sir

@swetaleenasatpathy6125 29 күн бұрын

Very insightful video. Could you please point me to the video where you have shown how to impute missing country value as "France" wherever the first person in cast column is Sami ?

@magudeswaranm3744 17 күн бұрын

Can you share the video regarding to deal the missing values in a dataset and how to integrate with those with another table which is having those missing values in PQE

@sravanikonijeti51 29 күн бұрын

thank you so much for this video...one small request brother.. please do these videos in telugu too for easy learn

@sindhushankar3147 26 күн бұрын

How do i correct the data in notepad++ while we are on powerbi? I'm not getting this part in mine

@cloud-tutorials 24 күн бұрын

Can you please give the link of video of power query of how to join tables to fill missing data

@bhaktipe Ай бұрын

You are champ bro 😎

@harshikasingh1031 20 күн бұрын

While I was trying to enable the column distribution and column profile for colunm country to figure out the high movie making counter "it show the distribution cannot be computed for curren5 selected column". Can u help me with this

@vijendratalari946 22 күн бұрын

Hi bro, I got some more ideas on Data cleaning, but how did you clear William Wyler? Please share the steps once again.

@lakshay8486 20 күн бұрын

Great and informative video

@plant.nursary 29 күн бұрын

Dear Chandoo, I noticed that the dataset provided in the description contains 10 columns, but the "cast" column is missing. Additionally, the dataset used in your video includes both "cast" and "release year" columns, which are not present in the version I downloaded. Could you kindly provide a link to the exact dataset used in the video?😊

@chandoo_ 29 күн бұрын

My bad... I put the wrong link. See this please - www.kaggle.com/datasets/shivamb/netflix-shows/data

@plant.nursary 29 күн бұрын

Thanks for updating 🤠

@towards_belief007 19 күн бұрын

Hey chandoo... please guide me how one can watch your video to master oneself in Excel...how to start watching your videos in your playlist will be more beneficial...plz tell me the sequence

@user-oo6fl2eg2s 13 күн бұрын

Thank you chandu.... BUT, I actually got stock when open the the csv data in notepad? I seriously do not get that part

@harshithharsha4066 Ай бұрын

Can you do power bi projects for resume ?

@narusrilakshmi6026 16 күн бұрын

Hai sir its very iseful video and do the videos about how to give the proper explanation about our project to interviewer plz do that video sir

@Bhanu-uo3wo 17 күн бұрын

sir can you do seperate videos or suggest any best free sources for learning EDA

@ts9438 24 күн бұрын

Can we have some examples with errors resolution...

@shyamravi6038 29 күн бұрын

Super

@srinivasan.m1120 28 күн бұрын

Sir,can you make HR related excel formulas videos.

@HelenBlack-sn7ke 24 күн бұрын

Off topic, but I thought if anyone knows you will. Is it possible with either pivot tables or Power BI to sort the column with values not to the right? For example, in this order, Customer Name, sales Value mth1, Sales Value mth2 etc. then Salesperson - region?

@chandoo_ 24 күн бұрын

I am unable to visualize what you want. Can you explain again with an example?