The TABLEAU PORTFOLIO PROJECT to make you STAND OUT from the crowd

Рет қаралды 47,366

Күн бұрын

Exclusive Data Analysis Content ➡ mochen.info/ ⬅ Join My Mailing List
/ mo_chen ⬅ Support me on Patreon
/ discord ⬅ Join our Discord Data Community
/ mo-chen1 ⬅ Daily tips & advice on how to enhance your data analysis skills
/ mo_chen1 ⬅ My IG is personal -- only follow if you're interested in non-data stuff as well
/ mo_chen_1 ⬅ Figuring out what I want to do in this space...
• Data Analysis Portfoli... ⬅ Portfolio Projects Playlist: End-to-end, FREE guided portfolio projects covering Excel, SQL, Tableau, Power BI and Python
┋Professional Certificates┋
DataCamp Certifications ➡ datacamp.pxf.io/c/4216860/205...
Google Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Google Advanced Data Analytics Professional Certificate ➡ www.coursera.org/google-certi...
Tableau Business Intelligence Professional Certificate ➡ imp.i384100.net/TableauBIAnalyst
Microsoft Power BI Data Analyst Professional Certificate ➡ www.coursera.org/professional...
IBM Data Science Professional Certificate ➡ imp.i384100.net/IBMdataScience
Google Project Management Professional Certificate ➡ imp.i384100.net/GoogleProject...
┋Timestamps┋
00:00 Project Overview
01:13 Data & Dashboard Overview
04:29 Average Custom Metric By Country (Map, Custom Parameter, Calculated Field, Advanced Filters)
14:56 Average Custom Metric By Month (Line Chart)
19:10 Average Custom Metric By Aircraft (Dual Bar Chart)
22:40 Building & Formatting the Dashboard (Putting Everything Together)
┋The project┋
Link to the data and the Tableau workbook ➡ github.com/mochen862/tableau-...
Link to the Tableau dashboard ➡ public.tableau.com/app/profil...
Thanks so much for taking a little time out of your day to watch this!

Пікірлер: 89

@tanyabajetha1168 22 күн бұрын

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.

@nandinibhusanurmath3613 8 күн бұрын

Thank u soo much, this was driving me crazy

@cindywu3265 5 ай бұрын

Thanks a lot Mo! I was able to follow the whole video and make my first dashboard! You deserve more attention.

@Nicole_TC13 5 ай бұрын

Great project! Love the dashboard design and having flexibility between which values you are viewing is a very valuable feature

@R0k47 4 ай бұрын

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.

@drowninglessonsxvx 5 ай бұрын

Hi Mo, I've been watching your videos for a while now and they really helped me, I've just landed my first Data Analyst job! Thanks for making great content

@Rodserg 4 ай бұрын

Mo, you are the best English speaking Data Analyst youtuber! I love and highly appreciate your content. You make me feel familiar with Tableau!

@beemoore6578 5 ай бұрын

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.

@nadarioferguson6276 2 ай бұрын

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!

@divadpoblano 5 ай бұрын

Thanks to your videos I got my first job as a Data Analyst.

@toptierbeauty 2 ай бұрын

Thank you Mo! I built this dashboard, you made it very easy to learn and follow. This dashboard is 🔥

@user-iz2zd4of2x 5 ай бұрын

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!

@mint-ef2up 3 ай бұрын

Thank you for the great project and walk-through, I understand Tableau so much better now! Will check out your other project guides soon.

@pavelgill 5 ай бұрын

I always searched for such videos but no one explained the way you did. Thanks Mo love your Content.

@irish.1398 4 ай бұрын

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!

@ianobaje5532 2 ай бұрын

I learnt so much ... just wanna thank you for generalizing the process and making it replicatable for other projects.

@StMarkAdebayo 5 ай бұрын

I'm very excited about this one!

@WDSAnalytics-es2zb 2 ай бұрын

very great work Mo.. impressive!

@DarzRojas 5 ай бұрын

Super helpful, thank you!

@fabiolacroes2322 2 ай бұрын

Thanks very much, Mo! Very clearly explained! 👍

@DataWithDas 4 ай бұрын

Thanks, great content!

@jackychan4640 5 ай бұрын

Hey Mo, Thanks for demo. Yes, it's cool

@tutumena2720 5 ай бұрын

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

@mohanchandra4885 2 ай бұрын

nice dashboard. you added all key values needed.

@CS2Shorty 3 ай бұрын

Learned a lot. Keep posting. Thank you :)

@nolanfontaine7973 Ай бұрын

Great rundown! Would love more content of this type!

@mo-chen Ай бұрын

I’ve got a whole playlist like this. Just search Mo Chen portfolio project playlist.

@thegodfather916 15 күн бұрын

heyy man, thanks for such wonderful content learned a lot from it keep posting such content have a great day !!!

@mo-chen 14 күн бұрын

Thanks for watching, will do for sure!

@vineetkaur1667 4 күн бұрын

Thanks a lot !

@sandydsa 5 ай бұрын

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

@_lifewithlexi_ Ай бұрын

Was wondering the same thing. Interesting that they use 2 different scales.

@Lana_Nora 2 ай бұрын

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

@mo-chen 2 ай бұрын

Thanks, there are lots more! Just check out my portfolio project playlist.

@shrutikapse1710 Ай бұрын

This was amazing. Thankyou so much.

@mo-chen Ай бұрын

Glad you enjoyed it!

@membisjovita1037 29 күн бұрын

Thank you so much, you took me from 0 to 100% knowledge on tableau.

@mo-chen 29 күн бұрын

Glad to hear that!

@DG-tm9mg 5 ай бұрын

Great project with helpful tips. Thank you for taking the time to make the video.

@mo-chen 5 ай бұрын

Glad it was helpful!

@nurinirdina212 Ай бұрын

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.

@mo-chen Ай бұрын

Great video idea and please check out my other tableau portfolio projects as well. Just search Mo Chen portfolio project playlist!

@thanhninh2863 4 ай бұрын

This is perfect Mo, Im fucking appreciate what you are doing now. love your contents

@danieloyeleye3257 16 күн бұрын

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.

@_lifewithlexi_ 2 ай бұрын

thank you!!

@manojgowdavenkatachalamurt3421 5 ай бұрын

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?

@TableauTim 4 ай бұрын

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.

@mo-chen 4 ай бұрын

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 😁

@minhkhueta 2 ай бұрын

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!

@Robin1997311 4 ай бұрын

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 KZfaqr'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?

@sanchitsharma2899 4 ай бұрын

For seat type, Its's showing null also. Is that means we have to clean our data first??

@shardulmane3445 2 ай бұрын

@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

@Catlearner2023 4 ай бұрын

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.

@lakshmilalitha2709 4 ай бұрын

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

@urvivaidya5920 4 ай бұрын

Same i am not getting values on 'value'

@kyobusingye 4 ай бұрын

Me too 😟

@abeln1167 4 ай бұрын

same did you find a fix?

@lakshmilalitha2709 4 ай бұрын

No @@abeln1167

@shreypanzz 4 ай бұрын

did you fix it ?

@ChibuzorOrji-bn6sy 4 ай бұрын

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

@khushimehta9829 4 ай бұрын

Just use the shift key and drag cursor to select bulk records. Hope that helps!

@doc2407 4 ай бұрын

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

@sanchitsharma2899 4 ай бұрын

Any source where I can get explanation for this process what we followed?

@ChesskaRobinson 2 ай бұрын

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.

@ibrahimovaramziyya5703 Ай бұрын

Hey @ChesskaRobinson, change data type to string in the parameter

@user-jc7dx1qh3n 4 ай бұрын

link to the data set please @mo Chen

@menghao4576 5 ай бұрын

Sir,can you tell us how to mention this project in a resume? Please. Thank you.

@mo-chen 5 ай бұрын

Check out my professional resumes and my ultimate portfolio for which the links are in the description. That should help 😃

@sanchitsharma2899 4 ай бұрын

hi @menghao4576, Can you share what you mentioned in resume?

@Baidaba.la.strada 3 ай бұрын

How did you select all rows min 11:45? Please expalin stuff because too often I see youtubers assume that newcomers know everything.

@karthickbalajesasirekhaesw1596 3 ай бұрын

Press CTRL and select the starting row, then scroll down and select the final row you wish to include.

@HunchoRK 3 ай бұрын

Click Shift when scrolling down to the bottom

@antoniomartinez3429 2 ай бұрын

helpful, thanks

@Okemanwu_Patrick 4 ай бұрын

Sir, how can i download the dataset to practice along.

@saniyasayyed634 4 ай бұрын

Its in the description box

@sathvikdakappagari9122 Ай бұрын

anyone getting a null for metric selected at 7:54 ?

@-kvamshiKrishnaA Ай бұрын

yeah bro did you solve it ?

@arneshguru4263 Ай бұрын

Where is the resume template?

@mo-chen Ай бұрын

It's no longer available as a single product. Check out my website for more info mochen.info

@sanchitsharma2899 4 ай бұрын

Whats the source of this data?

@TrixisFROZEN 3 ай бұрын

8:58

@TrixisFROZEN 3 ай бұрын

17:25

@TrixisFROZEN 3 ай бұрын

17:25

@saniyasayyed634 4 ай бұрын

You were too fast sometimes

@user-God-s-child-0101 2 ай бұрын

Whole world's creator Godfather Shivbaba bless you all always and you all remember him always.🎉🎉

@rohanayush 2 ай бұрын

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