Thank you for your great video, but I have a question in the total bookings bar chart why did you use the sum of name instead of the sum of number of review in the row?
Great learning video. I have a question though. In the 'total bookings' bar chart, how do we justify the Null value? Since there are about 10k+ bookings under the same.
Hello, actually there are many null values in some columns due to a lack of information from the source, but we cannot delete the whole rows as we may need the other columns for the analysis
Hi, it depends on the dataset and the type of data you have, also on the case study, but for the tutorials I pick some columns and work on to extract some insights, you can choose any columns you want depending on what you are looking for :)
I don't understand how the second sheet ("Total bookings by month") is correct. You are using the "Last review" field as the "count" of how many bookings were there that month, but that doesn't make sense. The last review only tells us when the last customer left a review on a room, not how many bookings were made for that room. So shouldn't the graph be called something else, like "Last reviews by month"?
Can You please help me, on how to extract data in the same worksheet! I am not able to create an extract data, please if you can help me with this, that will be a great help, I have been trying for 4 days but i am not able to find a soln
HELLO SIR,I LIKED YOUR DASHBOARD. I NEED FINANCIAL ANALYSIS DASHBOARD WITH VIDEO EXPLANATION, SO COULD YOU PLEASE UPLOAD ANY FINANCIAL DASHBOARD,PLEASE ITS A REQUEST.
Hi, actually I created the charts depending on the columns and common questions related to Airbnb analysis, but you can have a sample of 10 questions at the beginning and create the dashboard accordingly :)
Thank you for your great video, but I have a question in the total bookings bar chart why did you use the sum of name instead of the sum of number of review in the row?
Whats a good title for this presentationv what are we analysing here with this project?
Love your videos. Really helped me with tableau. Following along you projects are better than attending a course.
Thank you Zaira! Glad to help!!
Thank you for this.. Really liked your dashboards and tried many on my own with some changes.. Keep going brother 👍
Glad to hear that! Thank you !
Great learning video. I have a question though. In the 'total bookings' bar chart, how do we justify the Null value? Since there are about 10k+ bookings under the same.
Hello, actually there are many null values in some columns due to a lack of information from the source, but we cannot delete the whole rows as we may need the other columns for the analysis
Thanks for this tutorial , learned a lot from it.
You are welcome Aniket! Can you please tell me if you have watched other tutorials in this channel?
@@DataScienceRoadMap I did and Just finished watching the" job salaries dashboard with tableau in 25 minutes"
Amazing sir i learned a lot from your vedeo..God bless you
Hello Abbas! So happy to read that and glad to help! :)
How would I go about finding the data you used for NY city but for a different city in the United States?
Hello, it depends if you can find open data for the region you are looking for, some sources can include kaggle and GitHub :)
Very helpful. Where were you able to source the data set from?
Hello, it is a public dataset, you can find it from different sources like Tableau Public :)
not able to downlaod the dataset, pls help by providing alternative method
Once you open the file on Github, you can select all, copy and paste in a file within your local working directory and save it as csv file :)
how did you clean the dataset in excel? how did you remove the null values?
Hello, you can use the filters to exclude the null values :)
How do you decide what information or relation to display in the visualization?
Hi, it depends on the dataset and the type of data you have, also on the case study, but for the tutorials I pick some columns and work on to extract some insights, you can choose any columns you want depending on what you are looking for :)
I don't understand how the second sheet ("Total bookings by month") is correct.
You are using the "Last review" field as the "count" of how many bookings were there that month, but that doesn't make sense. The last review only tells us when the last customer left a review on a room, not how many bookings were made for that room. So shouldn't the graph be called something else, like "Last reviews by month"?
Hello, yes it is possible, I used it as the only information provided in the dataset :)
how did you get the total bookings data
Hello, the chart created using the available data within the dataset :) (10:26) Create horizontal stacked bar chart
Hi, Can you please help me in downloading the Data set ?
You click on Raw data, copy all and paste it to your local working directory as a CSV file :) normally it should work
@@DataScienceRoadMap buenos días, ¿Me podría enviar el documento en excel por correo?, por favor
FINISHED WATCHING
Thanks a lot Sandipan! I am glad to help!
Please help me how to create avg review per month calculated field
Hello, if you follow the steps (16:25) Create highlight table, normally you get the right result :)
Can You please help me, on how to extract data in the same worksheet!
I am not able to create an extract data, please if you can help me with this, that will be a great help, I have been trying for 4 days but i am not able to find a soln
Hi please any update!
It will be a great help! if anyone can guide me up for making an extract for the following video, thanks please
Hi sorry for this too late reply, in the same sheet, select data, new data source and important your data
HELLO SIR,I LIKED YOUR DASHBOARD. I NEED FINANCIAL ANALYSIS DASHBOARD WITH VIDEO EXPLANATION, SO COULD YOU PLEASE UPLOAD ANY FINANCIAL DASHBOARD,PLEASE ITS A REQUEST.
Hello Prajata !! Yes absolutely! Am on it! Happy to help!
Thank you😊@@DataScienceRoadMap
Thank you 👍🏻👍🏻👍🏻
Most welcome Aimal!! Thanks a lot for your comments :)
@@DataScienceRoadMap ❤
Can you provide me the dataset
hi how to show full header name
Hello, please follow these steps and let me know if it is okay: th-cam.com/users/shortsnircOidJWBw?feature=share
this Analysis falls in which department
What questions are we answering using the dashboard???
Hi, actually I created the charts depending on the columns and common questions related to Airbnb analysis, but you can have a sample of 10 questions at the beginning and create the dashboard accordingly :)
Great but why you dont have any contact information? I wanted reach you out but there is no e mail, instagram etc ?
Thank you! Sorry, I just use TH-cam for now :)