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 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

Пікірлер: 59

  • @skhulilebuthelezi2365
    @skhulilebuthelezi23652 ай бұрын

    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_

    @chandoo_

    2 ай бұрын

    Wow, thank you!

  • @jinwei7645
    @jinwei76452 ай бұрын

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

  • @choppinbored98
    @choppinbored98Ай бұрын

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

  • @cloud-tutorials
    @cloud-tutorials2 ай бұрын

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

  • @veraadjei2404
    @veraadjei24042 ай бұрын

    Very Insightful. Thank you.

  • @sathyamanikantabk4483
    @sathyamanikantabk44832 ай бұрын

    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
    @kingsfordsconspiracytheori90662 ай бұрын

    Learnt a lot from this video. Thanks Man!

  • @chrism9037
    @chrism90372 ай бұрын

    Really nice video Chandoo thanks!

  • @ArifKhan-qo9jw
    @ArifKhan-qo9jw2 ай бұрын

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

  • @EmiKreativ
    @EmiKreativ2 ай бұрын

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

  • @krishnakantapanda6835
    @krishnakantapanda6835Ай бұрын

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

  • @praveenkumardasu8915
    @praveenkumardasu89152 ай бұрын

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

  • @chandoo_

    @chandoo_

    2 ай бұрын

    My pleasure 😊

  • @harshitthakur8300
    @harshitthakur83002 ай бұрын

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

  • @kallapallisai9959
    @kallapallisai9959Ай бұрын

    Your teaching is awesome sir From Visakhapatnam

  • @wonder-2023
    @wonder-20232 ай бұрын

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

  • @md.nuralammiah9587
    @md.nuralammiah95872 ай бұрын

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

  • @magudeswaran.m
    @magudeswaran.mАй бұрын

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

  • @gsrsakhilakhil528
    @gsrsakhilakhil5282 ай бұрын

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

  • @lakshay8486
    @lakshay8486Ай бұрын

    Great and informative video

  • @bhaktipe
    @bhaktipe2 ай бұрын

    You are champ bro 😎

  • @sravanikonijeti51
    @sravanikonijeti512 ай бұрын

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

  • @swetaleenasatpathy6125
    @swetaleenasatpathy61252 ай бұрын

    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 ?

  • @magudeswaran.m
    @magudeswaran.mАй бұрын

    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

  • @narusrilakshmi6026
    @narusrilakshmi6026Ай бұрын

    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

  • @shyamravi6038
    @shyamravi60382 ай бұрын

    Super

  • @sindhushankar3147
    @sindhushankar31472 ай бұрын

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

  • @cloud-tutorials
    @cloud-tutorials2 ай бұрын

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

  • @harshikasingh1031
    @harshikasingh1031Ай бұрын

    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

  • @harshithharsha4066
    @harshithharsha40662 ай бұрын

    Can you do power bi projects for resume ?

  • @vijendratalari946
    @vijendratalari9462 ай бұрын

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

  • @Bhanu-uo3wo
    @Bhanu-uo3woАй бұрын

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

  • @Ruksivajaya
    @Ruksivajaya4 күн бұрын

    Hi Chandoo. I wish I can learn from you the power bi concept. I would really appreciate your response.

  • @towards_belief007
    @towards_belief007Ай бұрын

    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

  • @srinivasan.m1120
    @srinivasan.m11202 ай бұрын

    Sir,can you make HR related excel formulas videos.

  • @user-oo6fl2eg2s
    @user-oo6fl2eg2sАй бұрын

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

  • @plant.nursary
    @plant.nursary2 ай бұрын

    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_

    @chandoo_

    2 ай бұрын

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

  • @plant.nursary

    @plant.nursary

    2 ай бұрын

    Thanks for updating 🤠

  • @ts9438
    @ts94382 ай бұрын

    Can we have some examples with errors resolution...

  • @ravi__negi__4333
    @ravi__negi__4333Ай бұрын

    Come with video on DAX (wich always used in real life scenario) ...make us pro sir

  • @AnuragBansal-fu5is
    @AnuragBansal-fu5isАй бұрын

    do you also take projects?

  • @shameelibrahim7431
    @shameelibrahim743127 күн бұрын

    Hi Chandoo. Can you do a tutorial on Maps in power Bi? I tried putting the coordinates correctly including formatting the lat and long data types but the display still shows the wrong coordinate. Please help

  • @karishkhanna2744
    @karishkhanna274425 күн бұрын

    Sir Can you please help me with the link to the data set I am unable to find

  • @HelenBlack-sn7ke
    @HelenBlack-sn7ke2 ай бұрын

    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_

    @chandoo_

    2 ай бұрын

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

  • @mayvynbhana8329
    @mayvynbhana83292 ай бұрын

    Your Director missing problem is probably due to tv shows having various directors for different episodes

  • @chandoo_

    @chandoo_

    2 ай бұрын

    Good catch :)

  • @magudeswaran.m

    @magudeswaran.m

    Ай бұрын

    That's a good catch 👍

  • @sakshisavardekar5492
    @sakshisavardekar549226 күн бұрын

    what to do if u get (blank) in pivot table filters even though there arent any blanks . i am getting (blank) in the type column

  • @chandoo_

    @chandoo_

    25 күн бұрын

    Power Query only shows "preview" of the data. The actual data may have blanks. Check the full table in the "table view" in Power BI.

  • @monikabagde2674
    @monikabagde2674Ай бұрын

    How did you edit in notepad ++??

  • @chandoo_

    @chandoo_

    Ай бұрын

    Just locate the line where that "extra" line break happened. Remove the line break so the whole thing is in one line. Save.

  • @narayanaraoguntreddi
    @narayanaraoguntreddiАй бұрын

    Hii Sir, i want to learn power bi from you only please help me

  • @anonymous2150
    @anonymous21502 ай бұрын

    you look alot like Jonny Liver.

  • @irakigulamrabbani2624
    @irakigulamrabbani26242 ай бұрын

    Hi sir kya apse bat ho sakti hai kya bas ek bar kahi bhi Instagram ya Facebook yaa aur kahi bhi please please please🙏🙏🙏

  • @chandoo_

    @chandoo_

    2 ай бұрын

    Feel free to message on my email. I am not active on insta. But my insta id is chandoo.xlsx

Келесі