The ONLY Data Analytics Portfolio Project You Need - Walkthrough

[@shrirangjage999]

What an amazing tutorial! Lore, I want you to know that we appreciate what you are doing and please bring more such project making video tutorials so that we get a hands-on experience, bcoz no other KZbinr is doing such a detailed step-by-step project explanation. Keep up the good work amigo ! God bless you !

[@loresowhat]

Thank you so much for your words🙏 this means a lot and I will certainly do more and more videos like this one 😉

[@albrightaz]

@@loresowhat You are amazing

[@ltk7309]

I think you spelled amigo wrong, but good comment nonetheless. GOD BLESS INDEED

[@noohinaaz8448]

PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE PLEASE do more of these m begging please. M trying everything what a data analyst is suppose to know or do and you are my diamond. You are more than fresher but I do not know where you stand as an experienced one so for me you are the perfect match please just keep it up.

[@loresowhat]

Absolutely!!! Thanks for the comment 🙂

[@noohinaaz183]

​@@loresowhat😊

[@cristianhurtadocabezas208]

thank you, i'm changing career now, learning sql and Power BI, trying tableu will be a good idea. I still can't get a job, but i hope i can get job as a data analyst soon.

[@loresowhat]

Best of luck with that 💪

[@rmikel14789]

I’m in the same boat, I’m changing my career. I’m just starting out on my Google certificate. Need to learn SQL and Tableau in-depth. You can do it, and you should. I’m working towards the same goal. Wish you the best success in life.

[@eng_hasanalyami495]

a great project to start mastering tableau software

[@loresowhat]

thanks for your comment 🙂

[@allahjoseph]

Agreed. He made it as simple as makin pasta

[@internetmanifesto]

Thanks for sharing this Tableau tutorial - I just completed the whole thing. It would have been nice if you were to show the whole process from start to finish, including making the dashboard more presentable. Another thing would be, some of the cuts and edits you made in the video skip a few of the minor details. All and all, I learned a good amount from such a short video thanks.

[@loresowhat]

thank you so much for the feedback and will keep that in mind for the next videos👍 also, make sure to check out pt2 of this video here kzbin.info/www/bejne/eZ_dk4Z7h8ZqhK8

[@yongweisu]

I like how you manage the filter

[@loresowhat]

Thanks 😊

[@CheshireArt_]

I was literally searching for this!! Thank you so much.

[@loresowhat]

Glad I could help😀

[@brandonvillanueva7575]

Used a relative route with a following of this project to get my data associate position. Thank you for this man

[@loresowhat]

Omg well done 💪💪💪 could you please text me on Instagram at loresowhat?

[@ltk7309]

How about getting a data scientist position? Why only associate? Zzz

[@PritiHanda-v4w]

Very good tutorial Lore. Can you guide me about different sources of getting the data, especially for Banking Domain and how to clean the data.

[@loresowhat]

Yes, sure! how can I help? do you want me to review any of your work?

[@TerraAventurineStudios]

Tableau is super easy and intuitive. I really like it for myself.

[@loresowhat]

Totally agree!

[@teddyoundo9763]

This was a well taught tutorial . I appreciate and please bring more of the same .

[@loresowhat]

thanks for the kind words!

[@shahjeelani2691]

I think this is the video whichll help u to boost and headstart in yt Because this came in recommendations

[@loresowhat]

Hope that will be the case ahah

[@AnalystNoninja]

This was amazing @Lore! Thank you so much. Could you please PLEASE also consider doing a project on fraud. Pretty please.

[@loresowhat]

hey thanks for your comment, what do you mean by project on fraud, can you tell me more?

[@vishnu_jv]

Thanks a lot for the walkthrough brother. I'm just starting out with tableau projects and it was useful to see how its done

[@loresowhat]

Glad it was helpful Vishnu 🙂

[@diakitem8318]

YOU ARE LITERALLY THE BEST DUDE! Thank you so much for sharing all this great content 🙏.

[@loresowhat]

Wow thank you so much for your comment, this means a lot 🙂

[@cheyiokoaye2007]

This video is a whole lot better than you think. Excellent really.

[@loresowhat]

Really appreciate your words, thanks a lot 😊

[@aestheticascendancy]

Great video but I wish you showed how you edited the final dashboard for aesthetic just to show the entire creating process. Think it would be helpful so that we can see and then add our own style to our dashboard. Overall though amazing and thanks for the project!

[@loresowhat]

Hey 👋 a few other people ask me that, and that is why I actually made a part two video that you can find on my channel. let me know if that helps😉

[@shivam220]

Awesome video. Helped a lot. I will say it was fast paced, be nice to explain a bit of the steps, and even how you formatted the last dashboard. 18 Min video I had to slow down to .50 speed

[@loresowhat]

Glad it helps and thanks for the feedback, will keep in mind for next videos 👍also make sure to check part 2 on my channel where I cover the formatting and other bits

[@profssorXx]

Really good video. Very easy to follow. Only one thing.. at the end you didn't show how you made each section bigger so it's more readable and presentable. That would've been really helpful!

[@loresowhat]

Thanks a lot for the feedback 😉 make sure to check part 2 of this video (link in description) where I go into more detail on the formatting side of the dashboard 👍

[@EdwinNyika]

Great & easy to follow tutorial Lore.

[@loresowhat]

Thanks a lot 🙂

[@prathyushamora5792]

very easy explanation,helped me a lot, as i was struggling how to approach in doing a project from sratch.

[@ltk7309]

Please help, I changed the alignment of text (for fully vaccinated people) to center but the value isn't going to the center of the blue bar like yours. How do I make the values display at the center of blue bar??

[@SharuSeker]

Amazing video Lore. Making it look effortless. This saves us so much time on the learning curve.

[@loresowhat]

Thank you so much 😊

[@albrightaz]

Thank You So much, I am creating a portfolio, I will definitely add this concept to my portfolio. Thanks so much

[@loresowhat]

Glad it was helpful!

[@ankursingh5297]

Great Tutorial!!! But also make a video of how you fine tuned your dashboard in the end. That would be very helpful for people like me who are learning grom scratch.

[@loresowhat]

hey mate I just uploaded pt2 covering exactly that 😀 have a look here kzbin.info/www/bejne/eZ_dk4Z7h8ZqhK8

[@yujiitadori225]

just amazing ! Want tableau tutorial from basic to intermediate level !

[@loresowhat]

Thanks for the tip, I’ve added that to my video list 😉

[@dosbournedo]

Literally the best!!! We need more educators like you!! Keep going!,

[@loresowhat]

Wow, thank you!😀

[@shaikhkashif9973]

Hat's of you bro , great explanation

[@loresowhat]

Thank you so much 🙂

[@hryshi]

'Succinct' is probably the apt expression for the video..Please keep bringing more such videos.. Thanks :)

[@loresowhat]

Thank you so much for your kind words! It means a lot 🙂

[@hryshi]

@@loresowhat You are welcome. I just had 1 question. Does the file type make any difference after connecting the data? I mean I am using the same file as yours but as excel, then the max values come as 'Null', but if I save the same excel file as .csv then things work fine. Any reason behind this happening?

[@emilialopezreviriego3896]

I missed the formatting part, it is very important for every dashboard especially for beginners.

[@loresowhat]

hey emilia thanks for the comment, have you checked part 2 of this video? I made it precisely to cover the formatting part of it 🙂

[@themanunitedview]

Best tutorial on KZbin! great help! One question I want to put the data source on the dashboard, where is the data from?

[@loresowhat]

really appreciate your comment 🙂 I put the data source link in the video description since a lot of you asked for it 👍

[@tiktokfinds6143]

this is really helpful thank you!

[@loresowhat]

Glad it was helpful!

[@solaawodiya7360]

My first ever Tableau project. Thanks a lot Lore 👏❤

[@loresowhat]

Well done 💪

[@-o-6100]

Hi Lore, this video is really helpful and I was able to create my very first Tableau dashboard project thanks to you. That being said, could you do a Tableau video on storytelling as well? Data Analyst recruiters in where I'm from also like to emphasize this skill and I feel it would be great if you did a video on this too

[@loresowhat]

Thank you so much for your content and absolutely, I can do something around storytelling. Can you expand a bit more what would you like me to cover about that?

[@-o-6100]

@@loresowhat I'd be happy with anything that covers the use of storytelling in Tableau, like maybe continuing on the dashboard you made in this video to include Tableau storytelling. But if you think that there may be other topics more suitable to showcase Tableau storytelling, I'm okay with that too (like using sales or marketing data for example)

[@Ladyhadassah]

Thanks lore for this amazing video,keep it up.

[@loresowhat]

Thanks a lot for your comment 😊

[@ironpurush0978]

Nice one but can you please make a video on creating the perfect data analyst resume?

[@loresowhat]

That’s a great idea and already added to my list so you will definitely see that 👍

[@fairvz]

9:59 idk but as a UI/UX designer who randomly watching this video... this part is so satisfying lol 😆...

[@loresowhat]

ahah I didn't know I could even impress a UI/UX designer with that 😂

[@larbimohmaedberrehilelkatt972]

amazing you really helped me a lot with this tuturial thank you lorenzo

[@loresowhat]

Glad it helped and thanks for your comment 😊

[@ltk7309]

Please help, I changed the alignment of text (for fully vaccinated people) to center but the value isn't going to the center of the blue bar like yours. How do I make the values display at the center of blue bar??

[@fruitfulliving1067]

Thank you so much, Lore!

[@loresowhat]

you are very welcome!!

[@ashleyrp2007]

Great walkthrough, very easy to follow

[@loresowhat]

Thanks for your comment 😊

[@hossamzarad677]

that's a great tutorial short and on point thank you brother for that and please do more God bless

[@loresowhat]

Thanks 🙏

[@aboobackersidhique7364]

Thanks for the superb walk-through. While preparing the 4th sheet, the value labels are missing for some countries. Bar is showing but the label is not displaying.

[@loresowhat]

Glad it was helpful! can you text me on instagram at loresowhat and send a screenshot so that I can better help?

[@wwpharmacist]

Coming from linked recommendation to find fantastic channel 😃 Keep the good stuff Likes button ✅ is greater than the subscribers 👍

[@loresowhat]

Welcome aboard and thanks for the support!

[@cryptonews188]

Lore This is Amazing thanks for this man

[@loresowhat]

Glad you enjoyed it!

[@phinsup49]

Can a good portfolio make up for no degree? I don't want to finish my degree and go more into debt when I have all the knowledge to do the job already.

[@loresowhat]

absolutely, relevant experience is more valuable that a degree from what I see

[@22bears]

Every time i see a programmer video on youtube, I notice the exact same thing: tired eyes, huge eye bags... it doesn't seem so healthy to me, I'm an IT student and I try to keep it chill. I won't stress or tire myself out just to get money or a good laptop money and stuff in quick ways. I prefer to learn slower and work lesser than having a look of being 10yo older than I really am

[@loresowhat]

Agree with you, it’s important to enjoy the journey instead of stressing out to reach your goal fast 👍

[@annienguyen4756]

exactly what I need to learn tableau. Please keep it up with the good work. Already subscribed!

[@loresowhat]

Thank you for the amazing words and feel free to let me know what you would like to see next 😉

[@annienguyen4756]

@@loresowhat Can you do a video about web scraping? job search website for example. That would be so amazing

[@loresowhat]

@@annienguyen4756 I think you’re reading my mind 😂 web scraping video out next week 😉

[@annienguyen4756]

@@loresowhat so cool, I'm really looking forward to it. How about divide it into 2 videos? 1 from website and 1 using API like twitter/linkedin🤔

[@loresowhat]

@@annienguyen4756 keen to get your feedback when is out next week 😉

[@busy_b22]

Thanks for the superb walk through. Took time out to follow along and I feel great about the skills I have learned. Had some trouble with the calculated field for the "Selected Start & End" dates. Not sure if my version called for different syntax, but I kept getting errors. I did try a few other ways to solve the problem but I was unsuccessful. In any case, I was able to create the parameters needed and the final result was great. I would love to see how you styled the dashboard. Definitely a new subscriber. Keep up the great work!!!

[@loresowhat]

Thank you so much for taking the time to leave a comment here 😊 I will definitely consider doing a video on how to format the dashboard, since a few other people asked the same 👍

[@alyssatuazon5023]

waiting for this also!

[@mtamamhariri2067]

I am from Indonesia. Thanks for your video.

[@loresowhat]

love your country!! I've been to Bali twice this year

[@tunamuda]

Thanks for the explanation!

[@loresowhat]

Glad it was helpful!

[@eileen9024]

thank you for the step by step guide! excited to start on it soon! thank you so much! looking forward to your future videos - your new subscriber!

[@loresowhat]

This means a lot 😊 let me know what you would like to see next 👍

[@srajalbagri]

great content clearly explained

[@loresowhat]

Glad you liked it 🙂

[@Tiaggus]

Thanks. Your tutorial es great and easy to follow. Btw, by chance do you have this dataset updated? O maybe you could share the source to update it.

[@loresowhat]

really appreciate your comment 🙂 I put the data source link in the video description since a lot of you asked for it 👍

[@fortunemichael5097]

You are heaven sent, thank you so much !!

[@loresowhat]

Ahaha thanks 🤩

[@shagunagrawal2003]

Great explanation and video

[@loresowhat]

Glad you liked it!

[@syedmalikahmed1423]

Really informative and helpful video. Thanks Lore!!

[@loresowhat]

thanks for the comment! appreciate it 😀

[@arthurvidal1180]

super neat work man !

[@loresowhat]

Thanks for your comment 👍

[@martinsoppa]

Amazing channel! and very helpful! please make much much more of such videos! well done :D

[@loresowhat]

Appreciate your comment and will certainly do 😉

[@mmadubugwujoseph6208]

SO HELPFUL

[@loresowhat]

Thanks a lot 🙏

[@AurelianoBuendia111]

Well done part with dataviz, but why use trend line and not cluster? Cluster seems better here, cause we don't need trends, we need to understand is there any correlation (and without regression models the only viz in tableu is cluster i guess to see this). And do u planning on some comparison videos in dataviz? Like tableu vs. others or even tableu vs. python ;) This would be great to see )

[@loresowhat]

Yep agree that clustering could be a good option here 👍 and I will definitely have a think about a video with a viz tools comparison, thanks for the tip 😊

[@zabashhd459]

can you share more projects like this including from SQ,Excel etc i need to build my portfolio at least 5 projects

[@loresowhat]

Hey sure check my other videos, I have a sql project and a few more tableau projects 👍

[@seththedatanerd1743]

Love the video man, keep it up!

[@loresowhat]

Thanks bro! And love your channel about section 😂

[@laurenson8898]

Love your content! Thank you for making this easy to follow dashboard. Please can you show more examples using date filters. What does one do if there is a string of dates e.g June - August is open season? How can you filter or choose something based on the season?

[@loresowhat]

thanks for your comment and can give more details if you dm me on instagram in case at loresowhat

[@KrisBruus]

Great tutorial, short and to the point! One question: A couple of countries (Like Gibraltar and Tokelau) have a vaccination rate above 100%. You reckon it would be best to simply not include those countries, or do you have any data-cleaning recommendation for this?

[@loresowhat]

well spotted Kris, that is definitely a data quality issue so because we are not owning the dataset that is powering this dashboard, I would just remove those countries. In an ideal world you would reach out to the data owner and ask to fix those issues...

[@KrisBruus]

@@loresowhat Cheers!

[@giaC--DuongThuongGia]

Thank you so much. It is vert helpful.

[@loresowhat]

Glad to hear that 😉

[@Jogindersinghofficial]

One of the best data visualization on youtube. Actually I just want to know the source of dataset. I mean if I want search for other datasets as well, it may help. So please tell me what's the source.

[@loresowhat]

thanks for your words and please find in the video description the link to the folder where I stored dashboard file and data source👍

[@ahmedkhalil1318]

thanks alot.. keep going ❤❤❤

[@loresowhat]

glad it helps!

[@fohowgroupngn12]

This is very inspiring.

[@loresowhat]

thanks, this means a lot!!

[@rekhaverma8294]

Hi, great video. I made a fantastic dashboard by following this video, which is available on my tableau public account. I wanted to give credit to you but tableau is not accepting your video link. I don't know what to do. but many thanks for the amazing video.

[@loresowhat]

Thanks a lot for your comment and glad it helps😊

[@NyakweaGitonga]

Great content...new subscriber for sure

[@loresowhat]

Thank you and welcome aboard 😉

[@snowball293]

Hi Lore, The video is so learnable. But I have a small question about why you use Max in all metrics. Thanks.

[@loresowhat]

hey sure, this is because the dataset is cumulative (row 2 includes data of row 1 and so on). let me know if this makes sense

[@snowball293]

@@loresowhat Thank you, Lore!

[@tomliao6667]

it's very useful video, thx!

[@loresowhat]

You're welcome!

[@taherkachwala8944]

Hello Lore. I just completed watching your amazing video and you made it look effortless. Kudos. Is there any way you can also share which site you got this dataset from? Thank you

[@loresowhat]

really appreciate your comment - I got the data from here ourworldindata.org/covid-vaccinations

[@ShawnF0912]

I wanted to know as to why we used a logarithmic trend line and not the others? Also when do we use the other options and when are the other times we use logarithmic? Any response would be much appreciated.

[@loresowhat]

I chose that as it seems more appropriate given the correlation chart but as long as you have a story behind you can use other trend lines too👍

[@akhilpadarthi4743]

Thanks bro

[@loresowhat]

Cheers👍

[@Ehem_Ai]

Thank you

[@loresowhat]

You’re welcome👍

[@SC-mu2fi]

Can you do an ETL project next?

[@loresowhat]

good idea!!!

[@saifshaikh3191]

Hey!! First of all thanks for your tutorial which was super fast and to the point without wasting any time. I have a question to ask, in your chart 4 (Vacc vs Fully Vaccinated per Location), the field, Share of People Partially Vaccinated should be less than Share of People Fully Vaccinated. If we take example of Cuba which has 61% are fully vaccinated and 86% partially vaccinated. It shouldn't be 86% for partially vaccinated, it should be 86 - 61 which is 25% for partially vaccinated. Can we fix that?

[@loresowhat]

Hey, thank you so much for your comment😀 I got your point but I think the calculations are actually correct as the Share of People Partially Vaccinated should be always higher than Share of People Fully Vaccinated (the latter is a subset of the former). The reason is that there are people who will get only one dose of vaccine (partially vaccinated) without getting the second one (fully vaccinated). Let's do an example with 10 people (total population) and let's say that 5 people had one dose and, among those 5, only 2 had the second dose too. In this case, we would have 50% partially vaccinated and 20% fully vaccinated. Let me know if this makes sense.

[@saifshaikh3191]

@@loresowhat Ah I see, Now I understand. Thanks a lot, man! I wasn't expecting you would reply so fast. You are the best. 😁

[@saifshaikh3191]

​@@loresowhat Hey Lore, I know you must be busy, so it would be great if you could answer my question whenever you are free. I can't seem to find 'True' value for my field 'Filter Selected Date' at 14:06 I can only see 'False' value available. I used the same calculation as you showed in your video.

[@loresowhat]

@@saifshaikh3191 hey can you send me a pic on instagram @loresowhat so I can better understand the issue?

[@Latte-rf7vg]

Thank you so much.

[@loresowhat]

thanks for the support 🙂

[@Kforwork]

Correct me if I'm mistaken but isn't KPI 1 wrong right off the bat? According to the data source, but the measure people vaccinated = total number of people who received at least one vaccine dose. Therefore, people partially vaccinated = people fully vaccinated - people vaccinated

[@loresowhat]

I define people partially vaccinated the ones with one dose only, so still vaccinated if that makes sense

[@yeonkyungseo1279]

Thanks for inspiring advice! And (I don't know why my comment disappeared, I'll just try writing once again) I would like to ask where you usually showcase your projects! Not asking exact link or address. Just wanted to know, because I am also building projects myself and I often wonder, if recruiters would actually visit the portfolio project websites of mine. 🤔

[@loresowhat]

thanks for the comment and good question! you might want to check out this video where I use one of the best tools to host and share your portfolio kzbin.info/www/bejne/ppLJq6KDqqyKjNU

[@yeonkyungseo1279]

@@loresowhat just checked it out and the platform you recommend seems awesome! Thank you again!

[@loresowhat]

@@yeonkyungseo1279 glad it was helpful 😉

[@dollysingh7478]

Amazing video...👍

[@loresowhat]

Thank you 👍

[@efrainlirio3165]

How did you the sum in column People Vaccinated Per hundred? Because this column for me is a string. Thank you this video. Amazing job.

[@loresowhat]

you can cast it as a float right?

[@wojtwojtas5631]

Great job!!!

[@loresowhat]

Thanks for watching😊

[@rongliao4494]

Thank you very much for the walkthrough tutorial, Lore! What should we do about the null values? When I excluded them at dashboard page, the statistics changed dramatically.

[@loresowhat]

you can keep them and add in the project description your rationale and assumptions so it's clear that you made considerations for those isntead of ignoring them

[@watchesandglocks527]

This is nice. I think even a newbie can do this. But can i practice this using tableau public? Thanks

[@loresowhat]

absolutely, you should be able to do most of it in Tableau Public

[@scottarden55]

Love the video, quick question I'm having trouble changing the format into a percentage at the 5:38 mark. I was wondering if I need to hit a hotkey or if I am doing something incorrectly. Would appreciate any help. Thank you!

[@MFM1993]

I also had trouble with this, I changed Numbers listed under the 'Default' heading rather than under 'Totals' (Should be just above 'Totals' in the Side Pane)

[@loresowhat]

thanks for helping out here 😉

[@mohit4902]

With the rise of thoughspot and similar self-reporting tools, is there still any point in learning Tableau or older dashboarding tools? Also work life balance for data analysts isn't that great since they constantly have 3 month deadlines for projects and are allocated to multiple projects (similar to a consulting environment)

[@loresowhat]

These are great questions!! For the first one, it depends where you work as big companies will always use tools like Tableau that are great at scale and reliable. Self-reporting tools still need to prove themselves in such workplaces. And regarding work-life balance, this is more about the company culture rather than the data analyst role. Many people choose to be a data analyst for the great flexibility it can give you but this only applies if the company will allow that flexibility 😉

[@sebastianquirarte6705]

Thanks for sharing, great tutorial! Just out of curiosity, where is the data originally from?

[@loresowhat]

hey Sebastian, it's from this website (highly recommended for other datasets too ) ourworldindata.org/covid-vaccinations

[@sebastianquirarte6705]

@@loresowhat thanks!

[@Smudgeyy]

Hey Lore, great video. I'm just wondering where do you get your datasets from? and do you clean them? thank you

[@loresowhat]

hey I mainly get them from Kaggle (by the way you might want to check out my instagram or tiktok @loresowhat cause I talk about datasets sources there too). I usually take the raw format from there and do a bit of cleaning if needed yes 👍

[@Smudgeyy]

@@loresowhat awesome, I would follow you on those socials but unfortunately I don't partake in them. If you were to do a video on cleaning the data etc that would be fantastic! Keep up the good work friend

[@chromama]

Dear Lore, thanks for the amazing tutorial. You must have put a lot of work in to that, but it's really helpful. One question though, regarding the data sample - is it accurate or just some test data set. I ask because you get for Gibraltar 120% vaccinated peeps, when actually 100% should be the limit (9:09 min)?

[@loresowhat]

thanks a lot for your comment and good question! the dataset has some data quality issue and this is why Gibraltar is off cause as you said 100% should be the limit

[@LOLGameeLOL]

@@loresowhat I just checked the original dataset, I think it happens because the num of 'people vaccinated' and 'population' are changed with the day, you can't simply use the max(people vaccinated)/max(population) cause the max value may not at the same day. Maybe the most important thing for Data Analytics should be to figure out the right definition of the indicator and display the correct number. Anyway, thanks a lot for your video, it's really helpful to me 😁

[@akankshasharma1178]

Woow,, that's really 🤩 amazing... 🔥

[@loresowhat]

Thanks a lot 😊

[@linahmarakalala7855]

this video was awesome...highly motivating as well...on that note do you still do the 30min free career mentoring with your subies? kindly let me know as I'd like to schedule for mentorship

[@TheDira93]

Hi Lore! Do you know where I can get an updated version of this data set? I completed my dashboard but I want the data to be until 2023. Thank you

[@loresowhat]

Mmm unfortunately I found the dataset online so I’m not able to update it

[@kimtsang9682]

Loved the video! Learned a lot. I have a question however, for the calculated field of percentage of unvaccinated people starting from 4:58, you did 1- (the percentage of people with one shot). Shouldn't it be 1- ((the percentage of people with one shot) + (the percentage of people who are fully vaccinated))? Thank you for your time!!!!!

[@loresowhat]

Hey good question 👍 with that calculation that you proposed you are double-counting people because the ones fully vaccinated will also be within the ones with one shot only (the first is a subset of the second). Let me know if this makes sense 👍

[@kimtsang9682]

@@loresowhat Thanks! That’s clear!

[@bikrammajhi3020]

Thank you. Very useful video.

[@loresowhat]

Thanks for your comment 🙏

[@mohammedfirdousmehdi]

Nice visuals there. As a fresher or an expert which tool to use Tableau or Power BI?

[@loresowhat]

thanks a lot! I would definitely suggest Tableau, easy to learn but at the same time will give you the chance to do very advanced visuals (which companies love)...

[@loresowhat]

@cristopherdelacruz7863 thanks for this comment, can you expand on the reasons you say PowerBI is better? Just curious on that 😊

[@tradersadda7297]

in sheet 4 @9:14 when you changed the format to percentage how the first location Gibraltor got lost in your sheet

[@tradersadda7297]

also the yellow bar is not coming for every location like yours

[@loresowhat]

Good point, I had to exclude Gibraltar from the dashboard since I had a % of vaccinated >100% (which is obviously an error and I presume it is a data quality issue of the dataset - I didn’t have time to check that). The way to exclude it is simply by adding “location” to filters and select all but “Gibraltar”. Hope this helps and well spotted 😉

[@tradersadda7297]

and it is showing 8 nulls at the bottom right corner what to do about it

[@loresowhat]

@@tradersadda7297there might be some locations with missing information for vaccinated people and I wouldn’t worry about that. Often datasets are not 100% clean and in a work environment you would note those to your client and see what they would suggest👍

[@tradersadda7297]

@@loresowhat yeah I did the same

[@hiltonchen8913]

Hey, Lore, absolutely loved the video, but I got a quick question. By any chance did you use tableau creater licence to create this project?

[@loresowhat]

thanks for your words and yes I'm using Tableau Desktop with licence

[@dpanjobs8210]

thank you for sharing this video ... i have doubt in people vacinated measure. why we using maximum instead of sum ? sum is total number of vacinate people right ?

[@loresowhat]

thanks for your comment - good question and the reason for that is that the dataset is cumulative and so row 2 includes data of row 1 and so on. if you have time to double-check, if you use the sum you will see a massive number.

[@vinil248]

Hi Lora, can you make a video how you got the job in uk through agency or LinkedIn or any other site ,I'm also based in uk and would like to know in detail

[@loresowhat]

thanks for reaching out! I've added that to my video list so you will definitely see that in the coming weeks 👍