To Select Multiple Row Values for Aircraft filter: 1. Click on the first row value you want to select. 2. Hold down the Shift key. 3. Click on the last row value you want to select. This action will select all row values between the first and last row values you clicked.
Thank you so much for this. It took me 4 hours to do it but it was well worth it. Learned more from this and your Seattle video than I could have ever imagined. Your sir are a Legend.
This is perfect timing. I'm working on data digesting at my work and there's a job opening for data analysis I'm trying to get after training 😭 making projects with current data soon so hopefully that's enough with my certificates.
Thank you for the project! I've learned and practiced a lot from your video. Will definitely recommend it to my friends who are also interested in data analysis!
I like the super relaxed vibe of this video! It makes you really relaxed while learning a lot at the same time. 🤓 Something does not add up though. The average rating is 4.2, but for all the other metrics, the highest average is only 3.3. How is that possible? A few minutes later... Looking into the downloaded excel files, it looks like overall rating is 1-10 but the individual items are 1-5 (seat_comfort, etc). This is so strange. No wonder the individual ratings are lower. Why they designed this survey this way is a mystery. 🤔And diving deeper into the excel sheet, it looks like there are a lot of -1 ratings in the items (seat_comfort, etc.). Very messy data... Thank you for giving us this opportunity to clean the data though. Looks like a real-world example. This would be a good end-to-end project from excel data cleaning to Tableau dashboard. Thanks again! 🚀
This was exactly what I wanted to do. Thank you for making this so easy to follow along, while teaching a lot of basic functionalities regarding tableau. Excellent work my guy!
Thanks for the project Mo! I recently started a Masters Degree in Business Intelligence and this project really helped me out! Thanks again, great content!
noooooo not floating containers... great video Mo! I'd love an opportunity to demist layout containers if you're up for it. Yes theyre super annoying but once you master them you wont get issues once you publish up to Server , cloud and you can boost performance too.
Hey Tim 👋 I absolutely agree that the tiled containers are more efficient and the 'right' way to do things. I'm sure you already have a great video on why we should use tiled containers 😁
Thanks a lot! Very easy to understand for a beginner like me. I hope you can make a video about tableau's pivot data after this. I want to learn more about tableau.
Thank you so much Mo Chen I have successfully done all the projects as a way to practice and get better on my skills, but when are you dropping a SQL project it will really be helpful
10:38 when I right click the seat type to show the filter why doesn’t it give me the option to show filter? I’ve followed your steps to a T. But am confused about the different outcome. Can anyone help?
Great Project! I have one question. Although the dashboard is very responsive locally, when hosted on public server dashboard tends to have a latency. May I know what might be the reason?
Hey Mo, Loved your content dude! I couldn't stop myself from watching till the very end. Subscribed! Also, I was just wondering if I could please get the "original source" of the data because I have to show it in my project and it's very important.
Nice job mo Chei, your videos have really helped me to improve on my data analytical skills. Just a quick one, how did you select all the records before grouping them i meant the aircraft category
Good morning sir, I am 1st year Data Science student. And I really appreciate your video. I would like to highlight one thing if you can explain like how adding filters and parameters works then it will really good for me. I mean if you can 🙏🏻
Thank you very much for this. If I wish to replicate this and add to my portfolio, how do I talk about the source for the data? I realized that sometimes employers ask where you got the data from, so I can't just say I got it from a TH-camr's repository right? How should I write about where I got the data from? Do you have a specific online address where you got the data here for this project?
Hi Mo, I just started using Tableau and am experiencing issues with data aggregation or null values on the `Metric Selected` field after placing it on `Color`. Could you please guide me on how to resolve this?
Look in the video description: Link to the data and the Tableau workbook The link points to the GitHub repository, you will find the data there and you can download it
My calculated field is showing null values in Data source page , I am unable to get the color for overall rating and entertainment when selecting the parameter in the view . Please Help , Thanks :)
I was not able to group/select aircraft into group that have reviews below 50 , so it could be done using calculated fields as well. Create a calculated field named "Aircraft group" and enter this calculation IF {FIXED [Aircraft] : COUNT([ba_reviews.csv])} < 50 THEN 'Various' ELSE [Aircraft] END and instead of aircraft put "aircraft group" field in the rows
May i ask, where could we get those datasets like this?. I have already known Kaggle, but i want to know more sources for a specific industry. Thank you!
guys if your maps or charts don't look like his make sure you've selected cabin staff service. I was stressing that my line chart didn't look the same until I went back and noticed that he still had cabin staff services selected.
I'm having issues with PICK A METRIC filter. Well everything is fine but when i select the seat comfort, everything is going colorless, and map is not showing the average data either. Please help
I figured it out, I forgot to include seat comfort in the Case statement "when 'Ground Service' THEN [Ground Service] when 'Seat Comfort' THEN [Seat Comfort]..."
I have the same problem. It's not showing up for me either. Edit: I figured it out. I found out the map wasn't showing either, so I clicked through the filters we created. Once the map showed up, I went back to Sheet 2 and found the Aircraft rows showing.
Thanks to your videos I got my first job as a Data Analyst.
Mo, you are the best English speaking Data Analyst youtuber! I love and highly appreciate your content. You make me feel familiar with Tableau!
To Select Multiple Row Values for Aircraft filter:
1. Click on the first row value you want to select.
2. Hold down the Shift key.
3. Click on the last row value you want to select. This action will select all row values between the first and last row values you clicked.
Thank u soo much, this was driving me crazy
Thank you so much i was about to give up
I was stuck here for 30mins thank you so much mate
You are the Top G
Thank you SO much !!
Thank you so much for this. It took me 4 hours to do it but it was well worth it. Learned more from this and your Seattle video than I could have ever imagined. Your sir are a Legend.
This is perfect timing. I'm working on data digesting at my work and there's a job opening for data analysis I'm trying to get after training 😭 making projects with current data soon so hopefully that's enough with my certificates.
Thanks a lot Mo! I was able to follow the whole video and make my first dashboard! You deserve more attention.
how u get data?
Great project! Love the dashboard design and having flexibility between which values you are viewing is a very valuable feature
Thank you for the project! I've learned and practiced a lot from your video. Will definitely recommend it to my friends who are also interested in data analysis!
Appreciate your effort Mo, it was great going at the same pace you are to understand if I remembered all the basics.
I always searched for such videos but no one explained the way you did. Thanks Mo love your Content.
Thank you @Mo Chen, the dash board easy to understand and follow with.
Thank you so much, you took me from 0 to 100% knowledge on tableau.
Glad to hear that!
I like the super relaxed vibe of this video! It makes you really relaxed while learning a lot at the same time. 🤓 Something does not add up though. The average rating is 4.2, but for all the other metrics, the highest average is only 3.3. How is that possible?
A few minutes later...
Looking into the downloaded excel files, it looks like overall rating is 1-10 but the individual items are 1-5 (seat_comfort, etc). This is so strange. No wonder the individual ratings are lower. Why they designed this survey this way is a mystery. 🤔And diving deeper into the excel sheet, it looks like there are a lot of -1 ratings in the items (seat_comfort, etc.). Very messy data...
Thank you for giving us this opportunity to clean the data though. Looks like a real-world example. This would be a good end-to-end project from excel data cleaning to Tableau dashboard. Thanks again! 🚀
Was wondering the same thing. Interesting that they use 2 different scales.
This was exactly what I wanted to do. Thank you for making this so easy to follow along, while teaching a lot of basic functionalities regarding tableau. Excellent work my guy!
Thanks for the project Mo! I recently started a Masters Degree in Business Intelligence and this project really helped me out! Thanks again, great content!
Great rundown! Would love more content of this type!
I’ve got a whole playlist like this. Just search Mo Chen portfolio project playlist.
I learnt so much ... just wanna thank you for generalizing the process and making it replicatable for other projects.
Thank you so much Mo for such an informative and amazing project! I love your content!
Good afternoon.
How do I select multiple rows like how he did at 11:50 in the video.
I've searched the web and haven't seen an answer.
Hi Mo...thank you so much for this tutorial. This was helpful 🙂
Glad it was helpful!
Thank you Mo! I built this dashboard, you made it very easy to learn and follow. This dashboard is 🔥
Thank you for the great project and walk-through, I understand Tableau so much better now! Will check out your other project guides soon.
noooooo not floating containers... great video Mo! I'd love an opportunity to demist layout containers if you're up for it. Yes theyre super annoying but once you master them you wont get issues once you publish up to Server , cloud and you can boost performance too.
Hey Tim 👋 I absolutely agree that the tiled containers are more efficient and the 'right' way to do things. I'm sure you already have a great video on why we should use tiled containers 😁
Thanks a lot! Very easy to understand for a beginner like me. I hope you can make a video about tableau's pivot data after this. I want to learn more about tableau.
Great video idea and please check out my other tableau portfolio projects as well. Just search Mo Chen portfolio project playlist!
Thank you so much Mo Chen I have successfully done all the projects as a way to practice and get better on my skills, but when are you dropping a SQL project it will really be helpful
I'm very excited about this one!
Amazing project! The first one that I did that is actually fun to do for me and doesn't report any mistakes. Hope to see more on your channel :)
Thanks, there are lots more! Just check out my portfolio project playlist.
heyy man, thanks for such wonderful content learned a lot from it keep posting such content have a great day !!!
Thanks for watching, will do for sure!
Thanks a Ton Mo 😄
Hi, my color range for average is saying null how can I fix it. I'm at 8:14 timestamp
exactly, did y solve it ?
10:38 when I right click the seat type to show the filter why doesn’t it give me the option to show filter? I’ve followed your steps to a T. But am confused about the different outcome. Can anyone help?
Thank you, Mo! Very helpful.
I'm glad you liked it!
Great project with helpful tips. Thank you for taking the time to make the video.
Glad it was helpful!
Learned a lot. Keep posting. Thank you :)
Great Project! I have one question. Although the dashboard is very responsive locally, when hosted on public server dashboard tends to have a latency. May I know what might be the reason?
This was amazing. Thankyou so much.
Glad you enjoyed it!
very great work Mo.. impressive!
Thanks very much, Mo! Very clearly explained! 👍
Hey Mo, Loved your content dude! I couldn't stop myself from watching till the very end. Subscribed!
Also, I was just wondering if I could please get the "original source" of the data because I have to show it in my project and it's very important.
It's a British Airways datasource from Kaggle.
nice dashboard. you added all key values needed.
Hey Mo, Thanks for demo. Yes, it's cool
Sir,can you tell us how to mention this project in a resume? Please. Thank you.
Check out my professional resumes and my ultimate portfolio for which the links are in the description. That should help 😃
hi @menghao4576, Can you share what you mentioned in resume?
This is perfect Mo, Im fucking appreciate what you are doing now. love your contents
Thanks, great content!
For Overall Rating and Entertainment when I hold the cursor over the region values are not showing, could you please help me on this
Same issue
Nice job mo Chei, your videos have really helped me to improve on my data analytical skills.
Just a quick one, how did you select all the records before grouping them i meant the aircraft category
Just use the shift key and drag cursor to select bulk records. Hope that helps!
How did you select all rows min 11:45? Please expalin stuff because too often I see youtubers assume that newcomers know everything.
Press CTRL and select the starting row, then scroll down and select the final row you wish to include.
Click Shift when scrolling down to the bottom
helpful, thanks
@@karthickbalajesasirekhaesw1596can you help me with the metrics . My values are null
Super helpful, thank you!
Good morning sir,
I am 1st year Data Science student. And I really appreciate your video. I would like to highlight one thing if you can explain like how adding filters and parameters works then it will really good for me. I mean if you can 🙏🏻
Thank you very much for this. If I wish to replicate this and add to my portfolio, how do I talk about the source for the data? I realized that sometimes employers ask where you got the data from, so I can't just say I got it from a TH-camr's repository right? How should I write about where I got the data from? Do you have a specific online address where you got the data here for this project?
Hi Mo, I just started using Tableau and am experiencing issues with data aggregation or null values on the `Metric Selected` field after placing it on `Color`. Could you please guide me on how to resolve this?
Quite impressive
hello MO, the project looks very interesting .could you please provide the datasets for this project ?
Look in the video description: Link to the data and the Tableau workbook
The link points to the GitHub repository, you will find the data there and you can download it
My calculated field is showing null values in Data source page , I am unable to get the color for overall rating and entertainment when selecting the parameter in the view . Please Help , Thanks :)
Same i am not getting values on 'value'
Me too 😟
same did you find a fix?
No @@abeln1167
did you fix it ?
I was not able to group/select aircraft into group that have reviews below 50 , so it could be done using calculated fields as well. Create a calculated field named "Aircraft group" and enter this calculation
IF {FIXED [Aircraft] : COUNT([ba_reviews.csv])} < 50 THEN 'Various' ELSE [Aircraft] END
and instead of aircraft put "aircraft group" field in the rows
Hi Mo, Thanks for your video. How much time does potential employer expect you will do this dashboard?
May i ask, where could we get those datasets like this?. I have already known Kaggle, but i want to know more sources for a specific industry. Thank you!
Could anyone explain the data modeling done in this project?? Sorry but I'm still in the learning phase...
8:54 I'm getting null values here Why?
solved
guys if your maps or charts don't look like his make sure you've selected cabin staff service. I was stressing that my line chart didn't look the same until I went back and noticed that he still had cabin staff services selected.
Can you help me please my metric selected values are null . And I m stuck in sheet 4 . I rewatched the alphabets its the same
@Mo Chen could please clarify our problem in Calculated field it shows 1 dependency all the time
I did the same thing as you did but still it shows 1 dependency
For seat type, Its's showing null also. Is that means we have to clean our data first??
mine shows 87 null values, what could be the mistake i have made?
Any source where I can get explanation for this process what we followed?
Thanks a lot !
Hey Great Content, is anyone else AVG Metric selected showing NULL? because mines is so im not getting the. numbers for it in my tool tip.
Hey @ChesskaRobinson, change data type to string in the parameter
Some of my metrics aren't showing anything
Can someone help?
Sir how to upload it live . I mean if I have mentioned my project in resume then report should be open immediately instead of github link.
THANK U 😻😻
I'm having issues with PICK A METRIC filter. Well everything is fine but when i select the seat comfort, everything is going colorless, and map is not showing the average data either. Please help
Same here! Did you figure it out?
I figured it out, I forgot to include seat comfort in the Case statement "when 'Ground Service' THEN [Ground Service]
when 'Seat Comfort' THEN [Seat Comfort]..."
@@joselinemagana6973 and i had spelling mistake
@@joselinemagana6973it’s not working out for me I need help please
My Parameters is not showing cabin staff service and Entertainment on map
This happens when we change the color to hex 013220
link to the data set please @mo Chen
anyone getting a null for metric selected at 7:54 ?
yeah bro did you solve it ?
@@-kvamshiKrishnaA I need help as well
Me too
thank you!!
@Mo I have one query I am unable to see all the data while dragging Aircraft into sheet . How did you select and drag data from aircraft
I have the same problem. It's not showing up for me either.
Edit: I figured it out. I found out the map wasn't showing either, so I clicked through the filters we created. Once the map showed up, I went back to Sheet 2 and found the Aircraft rows showing.
Andy Kriebel did same thing
Sir, how can i download the dataset to practice along.
Its in the description box
Where is the resume template?
It's no longer available as a single product. Check out my website for more info mochen.info
Whats the source of this data?
8:58
17:25
17:25
Whole world's creator Godfather Shivbaba bless you all always and you all remember him always.🎉🎉
You were too fast sometimes