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.
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
very informative video about DATA Cleaning in the whole playlist...now i just about to start learning by making some big projects videos and this enhances by level of thinking 🤯🤯 Thanks a lot CHANDOO💐💐
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?😊
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
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
Fantastic content more on EDA in Power query. In country column, we replaced the blank with US. However, there were multiple duplicate or similar countries popping like, australia, australia-germany and so on. Need to know if we need to normalize this kind of data as well.
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
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 ?
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?
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
@@chandoo_ Im studying powerBi Can I have that file to learn or a tutorial of making it By the way that looks clean and everyone making theirs like website with buttons that navigate to home overview and everything That also I dont know sir Im having hackathon on powerBi thats why urgent Thank you for you reply so far 🙏🤌
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.
Wow, thank you!
Best Data Analysis related TH-cam channel ever!❤ thanks very much for this!
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
very informative video about DATA Cleaning in the whole playlist...now i just about to start learning by making some big projects videos and this enhances by level of thinking 🤯🤯
Thanks a lot CHANDOO💐💐
Glad to hear it's helping you think bigger! 🙌
Nice video with no nonsense, comming right to the point. Appreciate your effort
Can you show more about sales data analysis with some summaries? Many thanks!
Thank you chandu.. Adding jewel to the crown with all your videos
My pleasure 😊
Hi sir, can u tell me about the thing that u have done in notepad ++ and how u did it. Hope for you reply !
Loved it! Will go through and follow along other practical examples on your channel. Thanks!
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?😊
My bad... I put the wrong link. See this please - www.kaggle.com/datasets/shivamb/netflix-shows/data
Thanks for updating 🤠
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
Your teaching is awesome sir
From Visakhapatnam
Today, i got chance to refresh my knowledge. Thanks Chandoo for your valuable video.
Thank you chandu.... BUT, I actually got stock when open the the csv data in notepad? I seriously do not get that part
Hi bro, I got some more ideas on Data cleaning, but how did you clear William Wyler? Please share the steps once again.
Nice video Chandoo! Looking forwards to watching more to come👍👍
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
Fantastic content more on EDA in Power query.
In country column, we replaced the blank with US. However, there were multiple duplicate or similar countries popping like, australia, australia-germany and so on.
Need to know if we need to normalize this kind of data as well.
thank you so much for this video...one small request brother.. please do these videos in telugu too for easy learn
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
thanks chandoo garu learned new things in PQ. Please do videos on DAX too sir
You have a Chandoo-fan in Hungary, I love your videos and your humor😘
This is a very informative video.
Like to have more video that can cover every corner of Data Analysis.
How do i correct the data in notepad++ while we are on powerbi? I'm not getting this part in mine
do you also take projects?
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 ?
sir can you do seperate videos or suggest any best free sources for learning EDA
Learnt a lot from this video. Thanks Man!
how did you open the file in notepad++ ?
Very Insightful. Thank you.
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
Hi Chandoo. I wish I can learn from you the power bi concept. I would really appreciate your response.
Sir Can you please help me with the link to the data set I am unable to find
Thanks Chandoo for sharing this useful video, will try this to make a insightful Dashboards..
Can you please give the link of video of power query of how to join tables to fill missing data
What are you doing here Bill? 🤣🤣🤣🤣🤣
Loved it!!
thanks for sharing
Can we have some examples with errors resolution...
Really nice video Chandoo thanks!
Excellent
Great structured video ❤ and it was very intersting and kbowlegable.
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?
I am unable to visualize what you want. Can you explain again with an example?
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
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.
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
Sir,can you make HR related excel formulas videos.
Come with video on DAX (wich always used in real life scenario) ...make us pro sir
How did you edit in notepad ++??
Just locate the line where that "extra" line break happened. Remove the line break so the whole thing is in one line. Save.
Can you do power bi projects for resume ?
17:43 Can we just keep blank countries as unknown?
Hi, the dataset link provided is taking me to another account. Could you please let me know.
That is right. It is a dataset I got from kaggle, so I linked to the source.
@@chandoo_ But I didn’t find the dataset of the chocolate factory being demonstrated in your video in that source file.
I think you are confused. This video is about netflix dataset.
Great and informative video
Your Director missing problem is probably due to tv shows having various directors for different episodes
Good catch :)
That's a good catch 👍
Hii Sir, i want to learn power bi from you only please help me
You are champ bro 😎
Can I know how the thumbnail is made sir
Please urgent... 😢😢
You mean how the report in the thumbnail is created? Using Power BI.
@@chandoo_ Im studying powerBi Can I have that file to learn or a tutorial of making it
By the way that looks clean and everyone making theirs like website with buttons that navigate to home overview and everything
That also I dont know sir
Im having hackathon on powerBi thats why urgent
Thank you for you reply so far 🙏🤌
Super
it is just data cleaning project. not end to end data analysis project.
If I'll see these type of missing value , I replace it with unknown 😂😂😂😂
you look alot like Jonny Liver.
Hi sir kya apse bat ho sakti hai kya bas ek bar kahi bhi Instagram ya Facebook yaa aur kahi bhi please please please🙏🙏🙏
Feel free to message on my email. I am not active on insta. But my insta id is chandoo.xlsx