 and put default let's see hello can you hear me now can you hear me let now good night i am so sorry all this has never happened to me give me a second stream status is poor let me see okay so listen so i signed up for the um i i signed up oh awesome if you guys can hear me i signed up for um the stream and it said it was supposed to be through a webcam and then i get on here tonight and now it's saying i need to use a streaming server so i quickly uploaded or connected everything to um i connected everything to this obs or obs that allows me to um stream and it does not look like it's working well i've done previous ones where i did not do this and for whatever reason it's completely messing up does not look good at all um and it's not giving me options so like um it's not giving me options to even like you you guys aren't hearing me through my mic at all this is not good give me a second give me a second y'all let me see what's going on yeah this is this is not great um let's see let me think let me think i might let me see if i can try to maybe even start a new one um where i can use the webcam because i have like a webcam and a setup and everything um and it would be so much better if i could use the webcam but it's like not allowing me to do that um let me see i'm so sorry for this y'all this is um this is on me because for whatever reason i did not do this properly i guess although it's very possible that they changed stuff on youtube and i just didn't know about it yeah okay all right so let let me see let me see where we're at let me see where we're at can you guys at least i mean it the video quality is bad but can you hear me okay do i sound okay i'm looking for feedback in the chat because i can't obviously i can't hear you guys man what's the latency on this this is tough i'm guessing you guys haven't even heard that yet they're static yeah okay what that's telling me is is that what that's telling me is is that you guys are not hearing it from my microphone you guys are hearing it from my computer which is not great um but i don't want to i don't want to try to fix this the whole night and you guys not get your answers questions questions and answers um that you guys came for so unfortunately i'm just going to keep it how it is um although i will say this is your first time you know seeing or or joining one of my q and a is this typically is a lot better yeah whoever you you're right it this is um this isn't not great but i you know we're going to run with it okay so look it's not going well we're just going to run with it that's what we do on this channel um go ahead and start asking your questions i know i created a post um it was like gosh it was uh basically just you know saying i was going to have the q and a and some people already ask questions um so you know if you nobody if it takes a while for you guys to get it i'm just going to start asking questions um well let's see let's see let's see and i'm going to go over there just so i have it in case you guys don't start asking questions because i don't want to sit here in silence uh let me see here we go i'm opening it up real right now but i'm also checking what you guys are commenting first question i'm just going to answer it because i'm just going to jump right in it says how can we find a job in non-profit organizations or in a hospital um you know i come from a healthcare background and i think you know the biggest advice for especially when you're working at like small hospitals and stuff like that is to have like a connection um just to know somebody who work there um the next best thing is reaching out to them on like linkedin and introducing yourself and trying to get some type of um you know connection with that person and then you know hopefully they have some type of opening or or you know you're able to find a recruiter for that company um but just networking and trying to find something typically most um you know a lot of these jobs are going to have job postings and and whatnot so you know just going through the typical routes that you would get any other job um and i think that in general non-profits are a little easier to get jobs in um just because they don't have as high of um skill caps i guess you could say um for the most part next one is hi alex would you recommend i get linkedin premium for networking for a job um it doesn't hurt and it won't hurt um because you know linkedin premium is going to allow you to see who's looking at your stuff have access to things that you don't already have and i think linkedin is so important for um finding a job i genuinely believe that linkedin is one of the best sites to find a job and so you know it doesn't hurt it could be really worth it for you i have never bought it myself just because i'm super cheap um so you know that's up to you um for everyone joining by the way super sorry about the quality uh i have a webcam here i have my uh really nice microphone here and i can't use any of them the whole system is just terrible um so i apologize for that but you know let's just keep going um next question is how can i know when i should start working with portfolio projects rather than grinding udemy courses i think once you start um the udemy courses start getting really easy like you keep going through the same stuff and you're like all right this isn't that hard anymore i've definitely got it i know the basics really well i've got up to you know to where i feel comfortable like i should be trying to work maybe a little harder courses i don't necessarily jumping advise doing jumping right into the hard courses i would start doing a project because the project brings forth things and issues that you're gonna have to work through and that's how you learn that's how almost everyone learns in a way so i think that i think that that's really important um so um i created a video a while back on how i scraped data from twitter i aggregate or i didn't aggregate i cleaned up the data and then i created visualizations um that basically uh i took trump's tweets and i and i you know built some visualizations off it was really cool project and david here's asking is there any way of doing what you did with trump's tweets but in linkedin and for job keywords i almost guarantee you it is possible i have never done it um what i will say is that um you know typically with these large tech companies linkedin is a tech company um they have apis i recommend looking into their api and normally they have um they normally have some user guide or some in some information on there what what data that you can pull legally um and look in there and see if that's in there uh you know i highly recommend going to apis first i just scraped it because i thought it was really fun although i had to use their twitter's api as well just that's where i would go first that's the first place i would look um let me wait wait i actually skip this question i'll let me go back up so um gabrielle says how to deal with a convoluted it infrastructure with a lot of dependencies in a small space to automate stuff um you know i i've never been in a place like that but i could only imagine how incredibly frustrating that would be i personally would highly recommend um you know if you can work there for a year or a year and a half and probably switch jobs places like that don't typically tend to really update their infrastructure they don't really update the tools that they're using and it's just really hard to continue to learn and persist when in that kind of environment so you know that's probably not the best advice that's that's what i would do um other than that you know i really think working with management helping them understand your your dilemmas and your your frustrations with how it currently is and suggest other options is another thing that you can do um next question says what would be the way to build up a portfolio um a portfolio is something that you i would not i highly highly recommend you do not try to do it all at once um it it takes time and it's kind of that thing that you want to you want to kind of um procure as you're going through those skills because as you're going through it they're fresh you have good ideas you're working through the skills um and and so don't do it all at once is my best advice do it over time and do it while you're learning the skills so like you know i recommend you start with sequel do sequel learn sequel at the best you can and then just do a small project it doesn't have to be a big project doesn't have to be so impressive that it blows any other project out of the water just a small project that demonstrates your skills because what's going to happen is is as you move on to other skills you will probably if not very quickly realize what you could have done better you'll go back and you'll reformat it and you'll make it look nicer and you'll add new skills that you learn along the way um and so you know just building it up over time building it up um in in a as you were going through those skills is my best advice um sad game boy great name um hi alex what exactly is a recruiter and how can i find one i'm a college student so everything is new to me thank you look i didn't even i knew what a recruiter kind of was i never worked with one out of college um and i just kind of happened upon recruiters when i started looking for data analyst jobs and they found me first before i ever found them recruiters are they work for a uh normally a staffing or recruiting company they get paid by companies to hire um their employees so take um google for example let's say google hires a recruiting company they pay they say hey recruiting company if you find us a data analyst we'll pay you 10 of their salary um upfront so say that salary is $50,000 they'll pay the recruiting company $5,000 right then and there there's not it doesn't cost you anything it is a basically a free service to you to find you as a talent and the way that you can find them is a really good way is through linkedin um and you know oftentimes if you're in a tuck hub or a large city there will be um people on linkedin who will message you with jobs if it's not a job that you're interested in just message them back and say you know hey i'd love to work with you this isn't a job for me but this is what i'm looking for i also recommend um if you find a job that you really like like say you found found a job for like some banking company you go to that company you look at the people and you find the recruiters for that company you can message them and ask them questions so um that's what that's what recruiters are that's just a really quick what i would do um to get in contact with the recruiter very important or you can call a call as well i'd recommend that um that has helped that has worked for me as well um um next question says i'm a student going to do data analyst co-op interview at an it company i was wondering if you have any advice also can someone with an engineering background go in good can go into data engineering um advice for interviews is really prep for the company know the company know what kind of tools they use so that you can talk towards that like if i know a company uses a certain software i can say you know i really like this software i noticed you guys use that that's something i'm comfortable with and i've i've had experience with and you can talk towards that they really like that um and yes if you have an engineering background you can definitely do data engineering but you're gonna have to learn the skills specific to data engineering which i will say i've kind of dabbled into um especially since i've started working on the etl side of things a lot and um you know it's just a different skill set it's a different um it's a different way of looking at systems and it can be very difficult to learn but if you have that drive to do it you absolutely can do that um okay this one's interesting it says 43 year old it pro currently studying udacity's business analyst and data science for python what are possible roles i can pursue and what other courses should i take after completing both so you know you're already in it you're or you know you're you're a little further in your career so it depends on what kind of stuff you've worked on obviously but if you're working on business analyst data science type stuff you definitely can do business business analyst i think that you know depends on your technical skills i always recommend that if your technical skills are a little lower that you look at business analyst first because business analysts typically don't do as technical stuff um whereas data analysts are a little bit more technical and data scientists are quite a bit more technical and so i recommend for people who are switching and don't know as much the technical side of things to start looking you know think about the possibility of a business analyst role um as well as you know look at data analyst roles um and and just you know see see where they go um having a lot more other people come and join i am so sorry for the quality of this video i have a webcam and a thing i you know it's a whole spiel it could should be much better quality i'm super sorry guys but hopefully hopefully my my loving and winning smile and uh my answers to your questions will make up for that so let's keep going um question this comes from joseph oh i just skipped it dang let me go back because that was a good one okay joseph asks question hello alex do you think the covid-19 is affecting in any way your job or the way you do it so yes um it it's affected my job in fact that i am now home i used to be at i used to be in a very large building with all my co-workers i used to see them i used to interact with them um there are a lot of co-workers that i have not talked to in like six seven months i used to see every day um just because i don't interact with them in a business setting anymore um and i've had to reach out i've reached out to them um you know a few times just say hey how you doing but you know it hasn't been on that aspect hasn't been super great because i haven't connected with as many people job wise um i think my workflow is very different i used to do all my work during the day come home spend time with a family now i'm doing meetings during the day and all my work at night so right after i get off of this qa q and a i'm going to start doing my work um because i have three maybe four hours of work to do so i'm gonna go a little bit more into the night than i usually do um so you know uh yes i think it has affected my job but not i don't think it's affected the quality of my work i think the quality of my work is probably still the same um and so i you know i don't think personally that it's affected me more than some other people um let's see uh so michael asks recently i've seen tons of data analyst classes curious if this is because of the pandemic people have more time to train have you seen something similar um you know with everyone being home courses and classes have become a lot more popular a lot more people are making them um so yeah there are definitely more than there used to be um and i think that you know because so many more people are taking them and doing them and paying for them people are trying to capitalize on that and they're making these courses do i think all of them are great no um and so you really got to make sure the reviews look good and the reviews look genuine and it's the kind that you're learning the skills that you want to learn um because you know some of these just teach the skills that you don't really are going to use um hi uh davin asks hi alex do you recommend reaching out to nonprofits for pro bono project work to add it to my data analysis project portfolio yes i think that is fantastic i absolutely would do that in fact i actually did that when i was first starting out before i ever got a data analyst job um well i was like in i was trying to get a data analyst job there's this nonprofit that my nonprofit used to work with um they wouldn't let me do the visualizations for my company um and i reached out to my and there was this old website bad visualizations i said hey i i noticed that you did you know you have it doesn't you haven't updated in a while i would love to do that for free for you um it's just something you know i would love to kind of donate my abilities and help you out and they love to they sent me data that had no personal information i built some visualizations sent it back to them and they put it on the website and so it was really cool and i think that's a really good free way and kind of a way to get back um and also building your portfolio so definitely nice let's see greetings from brazil hello from the states um all right so kk asks how do you know if your project is accurate like you are getting the right outcomes that is a really good question i think that you know i think that goes back to the very beginning of your project right what does your data look like and what are you trying to what are you trying to solve because in a business setting you aren't just going to have data and you're not just going to create visualizations or out or or some type of output for no reason it has to have a reason so it starts at the beginning it starts in the planning stage of here's what our data looks like um you know here's what we can here's the kind of insights that we can get out of that data and so planning ahead is i think the the best thing to do in terms of accuracy um typically you do some type of qa at the end um you know you do counts and checks and all these things to make sure your scripts are correct and they're giving you what you're actually supposed to want at my work we have qa analysts who qa are work um and you know they save me a lot of time and effort but you know everybody every company is different i used to work at you know i did my i did qa for other people they did qa for me um so you just check other check each other's work um let's see rose lk says a part-time business analyst graduating with masters in business analytics in december congratulations that's super super super exciting um honestly i wish that was me i'm super excited for you um i don't see growth opportunities with my current employer what do you think of remote work or independent analyst job so i am a huge huge huge proponent or however you want to say that i i definitely think if you are not happy in your job you should look elsewhere you know why because you will be valued so much at another job i have been undervalued in my in a previous job and when i moved jobs i was i was so appreciated and valued it completely changed my home life my work life how i how i felt about just so many things and so if you're not happy with where you are start looking at other places um and and that's just you know it may not be you don't like them but growth opportunities is what you're saying specifically if you don't see a future in that company if you don't see a path in that company then you know by all means start looking elsewhere try to find somewhere that you can grow ask that in your interviews is this a place where i can be promoted and grow and grow with the company um and the second part of that was what do you think of remote work or independent analyst jobs remote work is becoming a lot more popular i think it's still it's really odd because these remote jobs are like yeah we're fully remote and we don't plan on ever coming in but you have to live where this company is just in case so like there was a job i posted a long you know a couple months ago and it was like um i think it was in near dallas texas and i posted it saying hey it's a completely remote analyst job never going to be in person then when people started applying the lady was like no you have to live here and i was like that makes no sense to me so just be aware of that there are a lot of remote jobs available they're just they're kind of weird um an independent analyst job i'm not a hundred percent sure what that is if that's consulting if it is consulting i just interviewed somebody it's going to be next week's video on how to do consulting analytics um do freelance through fiverr up work um stuff like that i'm going to be a super good inner uh interview um so that might answer your question better than i can to be honest um let's see uh me the me the guyen uh sorry if i said i didn't say that right but that's the best i could do i have a bachelor's in science but want to transition to a healthcare data analysis field do you recommend going back to school and try for a masters in statistics um i think you know it's very interesting if you're trying to transition to a certain domain because especially for healthcare if i'm hiring some type of analyst i really value the domain knowledge even even on the same level as technical skills so going back and getting your masters and statistics make up your technical skills a lot which would definitely make you more employable um i think for the healthcare data analysis if you are really specific on healthcare i would really start studying healthcare um and and things within healthcare that you can uh that would be actionable some of the things that i'll i'll give you a super quick for people who don't care about healthcare i want to give super quick um you know learn icd codes learn cpt codes um learn um loink codes learn what um phi is um and and those just super basic building blocks and you can put on your resume kind of thing would really be helpful just shows a little domain knowledge that's my biggest advice for you net doesn't necessarily have to be education wise um kevin asks how important is gpa for data analyst position would it be dependent on the company's values look i have never in my life ever asked anyone what their gpa was in college and i don't care um i really care about if they know the industry and if they're going to be um you know if they know the technical skills that being said not every company's like that and if you're right out of college there are some companies i think like google might do that there are some companies that hire based off of like class rank and gpa and what things you did in college in the in 95 percent and that's a completely random number i am absolutely making up on the spot do not care about your gpa at all so you know take it with a grain of salt i just don't think it's that important um and you can put it on your resume if you have a really good gpa and if not take it off i had like a 3.4 or something and i don't need i don't put it on my resume i don't mind my my uh degree is not really worth anything so that's just my advice oh okay this one's interesting i have an interview for an internship and i'm in the middle of my masters how should i present myself so it's really interesting um if you're in the middle of a master's program and you're trying to get employed i would absolutely um i would absolutely still be applying to places because you want to get a job and you also want to complete your master's because you need money to pay for that master's um so if you're in that place where you need both um you know i would not and you know i've told other people this i wouldn't put you know will graduate in whatever i would just say currently taking your master's and when you present yourself if they ask what you're doing you're like you know i i'm in a master's program but here's what i'm learning um if you have experience i would highlight that way above it if you have the option to not even talk about it um i would even go with that just they don't probably don't care to be honest that you're in a master's program as much as that you have the experience and um you know you have an education to be fair that's what i think um oh man i just skipped down i skipped a bunch of skipped a bunch of questions let me scroll back up okay okay i'm back to where i was what incentive does an employer have to hire me rather than an it or computer science grad depends on what your degree is in and depends on what experience you have i think that if you are trying to get a data analyst job and somewhat if you're the exact same person and you have a degree in what you know epidemi no that's not a good one i'm trying to think of something funny but i can't think of one something like really random right you have degree in uh hard floor engineering i couldn't think of anything i apologize why would they choose you is because you have the domain knowledge and you have experience if somebody only has a computer science degree or they only have an it degree but no experience they might hire you with experience now let's say you have the exact same everything but different degrees the only reason they might hire you over them is personality if you get the same if you and you both get an interview is personality your drive and probably a portfolio so you know if you have a portfolio and they don't if you have a really good personality and they don't um if you have a really big drive to be a good employee at their company they don't those are things that would bump you up in the list that's just just my two cents um let's see sgl how's it going that he's a subscriber on uh patreon super cool uh he says hi alex i'm looking for a junior data analyst position what kind of small projects should i put on my resume thanks in advance uh small projects are fantastic i you do not have to go over the top and make these huge projects and and like go super in depth all the way from the start to the finish and you don't have to do that start small smart with two small projects one that i always really like is a small data cleaning project and then a small querying project um into where you create like views the small data cleaning project you you take some data um let's say for really this really simple example is you you have some dirty data and i'll give you two examples you have a first name in one column a last name in another column um and you want to combine them into one column so you create that that's in a that's because that's how you want the format that's a little bit of cleaning you could say or formatting cleaning um a really easy one and one that i had on my kind of one sheet of skills that i knew um was formatting a phone number it's not as hard as you it looks you can look it up on stack overflow not super hard but you know it will give you a good example of data cleaning so say in a column you have phone numbers they're all different formats some have parentheses some have dashes you use regular expression to remove all of that then you use substrings to format it exactly how you want and it cleans up the data that is a really simple example of how you clean your data super super basic the simplest i can possibly give you uh well maybe not but the best i can give then on the creative views you create a view um you you uh take a subset of that data i i recommend taking two tables showing that you know how to use joins or unions or however you want to present that i'm taking a subset of that data and creating a view and you can do that in several scripts like like a stages um and i highly recommend those two small projects those are really good easy ones and you can go as advanced or as basic as you want and whatever you put on there it's better than nothing i promise you unless it's really bad i promise you it's better than nothing let's see okay so tyler asks i have a bachelor's degree in economics mba and about to finish a graduate degree in data analytics should i look for internships or entry-level jobs since i don't have real world experience i think that if you have paid for an nba you do not want to be getting an internship and not be making any money and not be able to pay back if you had to take out loans or anything you want to get a job and you know i absolutely think that you should be going for a job is what i'm trying to say because you know your educational level is higher than most people um and you know i think that that is worth something steven asks is tableau certification worth it yes i do recommend it um i have an entire alexa analyst show episode dedicated to certifications and that is one that i do recommend tableau is such a staple in data analytics in the analytics world in general and people recognize it it's not like some you know cabrera or cala calabra whatever um it's not some random like cert certificate or certification this is a brand name tableau people know it it's worth something so i do recommend it uh we've we've had a lot more people join i just want to say super sorry about the quality super bad it was not my fault i 100 blame youtube and my lack of preparation um let's see valet or belay it's a cool name uh he says is data analytics storytelling an important skill for entry-level data analyst job if it is essential which course would you recommend for it um i think that we especially when you're at the entry level you do probably work a little bit more on visualizations than once you get more into the technical side of a data analytics analytics job um especially if you're getting like a junior role they're not going to give you the hard data cleaning stuff right off the bat they'll give you the easier visualization stuff um so storytelling is important it definitely is important and i i do recommend learning that um that side of things i recommend there is a uni course it's called story uh um i'm going to get this wrong and i may have to look it up um but it may be in the description uh it's for you to me it's how to create dashboards and throughout that it talks a little bit about storytelling um how to present your data the different types of dashboards to do certain things um highly recommend that one i like that one a lot hey for all the people watching right now um in the description i have a link i want you to go click on it i hit 10 000 subscribers thanks to i'm sure almost all of you guys um and i was super ecstatic about it and i'm giving away free courses um on you to me completely out of my pocket no sponsor no nothing i'm not taking your email for a shout-out list or to spam you it's literally i'm just giving away courses and that's it so go sign up um it's just fun for me to give back to you guys who have given me so much um i enjoy this way more than you guys could ever imagine so um you know that's just a little plug for if you want to earn literally free courses um you're gonna pick two people three free courses per person enough about that let's get back to the questions that's what matters um next question from hrush akesh hey alex can you please tell us best suited resume format for data analyst job profile um i have a whole video on creating a data analyst resume i'm not a hundred percent best suited resume format um i'm not a hundred percent with sure that means but hey i have a whole video on data analyst resumes i've reviewed a bunch of resumes on the channel i recommend just checking those out and following that tutorial as well as the ones i review so you can get some ideas of what i like uh where i think is good versus not good enox says hi alex does being good does being good at programming enough for a data analyst role or do i need other skills to back up my programming if yes what skills would you recommend if you mean programming is in python you can't just know python there are very very few jobs where they only use python you definitely are going to need sequel you're probably going to need um maybe you know it depends maybe some cloud platforming um aws azure um you definitely need a no excel you can do visualizations with python but sometimes they want you to use tablo or they want you to use power bi or or click viewers or just any other thing so you it's good to diversify your um it's good to diversify your skillset so that you will open up to a broader audience in in a job um let's see ej villa says hey alex i'm currently a business process analyst in a company but i feel like i have stagnated and growing or learning more should i leave now or not now for the time being due to the pandemic that's super up to you um you know i don't know your situation your family your your you know goals and aspirations um right now i'm staying put i personally am not i'm not changing careers right now one because i have everything kind of set up how i need it um and it really fits my lifestyle and work about work-life balance right now because my company's giving me a ton of flexibility to go to meetings during the day and work at night um and i may not have that at another company and i need that right now so i would just look at what you want the most you know do are you really open to um getting another job and you know transitioning and and working hard at the beginning because that's typically you know you're you're learning a ton or do you need to be in a more stable place even if you're a little bit stagnant completely up to you um j t says hi alex i graduated with a degree in finance back in 2016 but didn't use my degree as i needed to take care of the family business okay would it be hard to become a data analyst with no experience it is definitely harder it's definitely harder to become a data analyst if you can't prove that you know how to use the things that data analysts use i mean that's that's kind of the crux of everybody starting out as a data analyst you need experience to get a job but you can't get a job because you have no experience it is it is i've heard it a thousand times and i've been there um you know i i think that you just really got to put a lot of time and effort in building your skills your portfolio if you want to get a certification or two um updating your resume and really selling yourself um to recruiters and in interviews um in order to get a job definitely possible though especially with a degree in finance uh you know going to banking or something like that all right let me see so dark knight says hey alex even though you are from the data science field what are your opinion on getting aws cloud practitioner certification for a fresher along with data analyst knowledge so uh i am a data analyst i work on a data science team so i do work with data scientists um but i'm not a data scientist myself if that's i'm not sure if that's what you said um aws cloud practitioner i think it's great i i think that aws and being certified in again it's a name brand um another one i recommend is getting the azure certification they have a data analyst azure certification these are named it's microsoft it's name brand it means a little bit more than you know alex the analyst certification um which i highly recommend you do not get it's not that not worth anything um and so those name those those one-off courses where they teach you a lot but they they don't really mean a lot um you know aren't as worth it as um as like the aws azure tableau those certifications um okay so enureg enterog cool name i just don't know how to pronounce it to be honest i have a bachelor's in electrical and electronics engineering that's awesome uh and i was at home after graduating in july 2017 so that's about three years ago now i'm learning sequel can i make it as a data analyst as a fresher uh and then that kind of trails off the question yeah it's definitely possible and everything that i've talked about up till then i think it's absolutely possible you know work on your portfolio your resume you're building the skills you know that that's absolutely important oh gosh i did that thing where i skip it again it just keeps doing that i'm not doing that on purpose i didn't do that on purpose i'm gonna try to get back to where i was because i skipped a few questions um i i'm not exactly where i was but um somebody asked how can i be a freelancer i just recorded an interview today with somebody who used to do freelance work um and now it owns their own analytics consulting business um and it's gonna be great i'm just gonna tell you to watch that in um watch that you know in next week's episode um that'll give you a lot more information i don't know anything about freelancing it's not my thing so wish i could be more helpful on that um do you think it is good for putting certifications on your linkedin or resume sure if the certification is good and you think it's worth putting on there absolutely certifications will help um but i wouldn't expect it to like get you a job it's just a piece of the puzzle that is getting a data analyst job um karan said can you please review my resume i do um i do review resumes but i only review resumes right now through patreon um you know if you become one of my monthly subscribers or you want to do a one-off um session i do those i'm you know it's just i get a lot of requests just to review someone's resume i used it like when i first started i was only getting like like one couple of months now i'm getting like five to ten a day and i've stopped accepting those and i'm i it's just because i don't have the time i'm super sorry i really wish i did um but if you want to email me and ask if you want to set up a time to do like a one-off session we can make that happen i'm sure we can um michael asked another question he said um have you looked into linkedin learning yet no in the guy i interviewed today creates linkedin learning courses and so i felt really bad that i had to use the platform oh actually that's not true i've used the platform i like it i just i didn't learn on there exclusively um i didn't learn a ton on there i liked you to me and corsair a lot a lot when i was first starting out and so um i need to look look into linkedin learning i really do and i haven't done that i'm just being honest uh it's actually good he's answering them since you really never miss any questions hey i'm here for the i'm here to answer the questions ujbola i'm not missing any questions i'm doing my best here michael says also the hit on the radishes look you can say what you want radishes are disgusting and i will i refuse to eat them if so if it's in a dish i just want to eat it i'll stay away from it there's there's better things to eat out there okay this is another question ps says hi alex i have been searching for data analyst job after learning sequel tablo python for data analysis and excel but i can't seem to get an interview what can i do to increase my chances it sounds like you know all the skills now you really have to learn how to market yourself work with recruiters um and you need to uh display yourself as someone who they want to bring in for an interview and that can be very tough um you know i have lots of videos on that stuff so hopefully that that might be helpful but the resume is probably you know something you really need to look at does it display you as a person as an analyst well um does it make you look good um and and does it would that be someone you would want to hire um and so really want to really focus on that resume um and portfolio if you haven't done that already all right kurt says what's the next job you can move up to after being a business analyst i'm currently an entry-level business analyst you can be a business analyst seeing your business analyst the next level business analyst the lead business analyst you continue being a business analyst you don't have to transition out of that business analyst is a very good job and i nothing against i think it's very important um you can also do data data analysis highly recommend that um and again you know it's preference you want to go to the more technical route you want to say the business route you could also go um you know do something more domain specific you can go financial analyst um you could go health care analyst just depends on what you want to do there's so many possibilities you could also go into consulting you could also open up your own business i mean who know the possibilities are endless to be honest um hi i'm trying to study genomic analysis using python or r language is it a good intro is there a good intro level online course in bioinformatics uh genomics that's how you pronounce that uh i do not know i'm sorry i wish i knew that i don't know um but i'm sure if you searched around you could find someone who's more knowledgeable in that area i just don't um iven nola's that's my guy uh says just watched to watch just wanted to watch the live keyway hope you're doing well i hope you're doing well i love chatting with you on patreon he's one of my my patreon supporters super awesome guy um let's see it's 945 it when i'm saying this it's 945 we'll see how long the delay is it's 945 where i am um i'm gonna keep doing this for maybe 15 more minutes and i'm gonna wrap it up um so that's that's uh i just want to give that um disclaimer dark knight says hi hey alex how did you how did covet uh lockdown affect you as a person both in work and family life i kind of answered this earlier but really it just changed my work schedule um i used to work 9 to 5 or actually i was working 8 to 4 30 or 8 8 to 5 um now i do my meetings during the day and at night i do all my work so right after i get off this call that's why i have to end a 10 because i have a lot of work to do so i have to go work after this um and so you know i gotta do what i gotta do i'm gonna make it happen um but again i love my family i love being home with my family um not i had a baby during the coven right the peak of fear around coven so that was kind of scary but besides that i've been doing really good and i appreciate you asking um let's see so let me try to summarize this really quick so mark says he's from the philippines degree in psychology working as a data analyst i wanted to take a master's degree but it's expensive um and his salary is super low um where where he loves he's thinking about taking data camp um and then enroll in a masters what do i think about data camp look i i use data camp the free version of data camp but i actually i liked it um but i didn't think the free version went as you know it wasn't as in depth and that's because you probably have to take the paid version if i take the paid version i probably would have loved it um but i've never taken the paid version and so data camp people um if you have any advice let mark know because i i can't speak super intuitively to that or not intuitively it's not the word but i can't speak like knowledgeably on that eric's i just haven't taken it the paid version of it um but um brendan all the projects i've done at work for sequel use proprietary info i can't share my portfolio is speaking to those worth it or should i focus on a project portfolio i was in the same boat i couldn't use proprietary information what i did was i i the scripts that i was using at work i went home and got a data set and applied those same types of scripts not the exact script i wasn't stealing i just applied those same logic the same um you know uh types of things that i was using in those scripts to the new data set and then that's how i built in i do recommend you building your own portfolio although you should be able to talk to it always the more you know the better you can talk about it the better it's going to be okay joshua asks hi alex what type of jobs would i be qualified for with a business is degree i'm guessing that's information systems degree along with azure dp100 designing implementing a data science solution and az az 104 azure administration you probably are looking at maybe like a dba job um dba or database developer um if you with all everything you mentioned you can always try to go the data analyst route you might just need to learn um you know some maybe you do no sequel but you know you need no sequel to blow python excel all the basics um but just based off everything you said it sounds like a dba job to me uh l wong 27 says hi alex i'm currently an accountant in the financial services field but super interested in data analytics what kind of opportunities are there within accounting finance and data analytics so many jobs i mean there are there are millions of no that's exaggeration there are thousands and thousands and tens of thousands of financial analysts business analysts data analysts all working within the financial field i have a friend um who is just talking to today who um you know is working at at usa it's a banking company they they work with finances and they have you have to hire hundreds of analysts to work with with the type of data that they have and every company it does that so there's so many jobs available um and i wouldn't be worried if there's jobs available there are there are jobs um dark knight says oh it did that thing again gotta be kidding me so i got to scroll oh wow i'm realizing there's a lot of questions that i'm not going to be able to get to i'm gonna go super fast i'm gonna speed this up already top three book suggestions they may be in the description if they're not um check one of my older videos i have two books that i liked on one on python one on sequel um but i can't think of them off the top of my head it's like it's python and sequel um but um sequel are python tablo which tool among them data analysts use frequently definitely sequel and tablo some use python some don't some use r some don't um i think a lot more certainly use python r is a little bit more advanced for data analysis some use it some don't do data analysts happen to implement machine learning algorithms into their work not that i know of i've never done it i don't know any i've never talked to any data analysts that do it that's mostly data scientists um or machine learning engineers that do that um hi alex i watched all your videos and noticed you asked your wife everything all your decisions you need to man up boy look you may not be married you may be married let me give you some really really really solid marriage advice and this is completely unsolicited but it sounds like you need to hear this uh when you are married in a committed relationship what they say and what they think and they feel about certain topics really matters so i highly recommend if you have not already uh talking with your significant other about the decisions and the big decisions you're going to make because that means a lot to them and it will help strengthen your relationship so it's a little marriage advice for all the married people out there or single people if you're going to get into relationship talk about these things you gotta do it you gotta do it uh pre-rex says can you write down your email yeah type it in type it in the chat right now feel free to email me i'm always i'm always available i don't do anything i'm always available just shoot me a message um let's see how do you build a sequel resume i don't think there is such thing as a sequel resume i think there's a resume and you can try to you can put sequel on it i have sequel in three different spots on my resume in my intro highlighting that i use uh uh uh sequel server management studio in my skills section where i highlight t-sequel sequel my sequel post-grade sequel um microsoft sequel and um then in my actual job description where i talked about sequel so i i highlight it a lot let's see let's see let's see what kind of marketing skills are useful for data analytics roles um i don't know if you're if you're out of analytics company domain knowledge um i don't i don't know if marketing skills are are super needed it's good to be able to market yourself and sell yourself and things like that but in terms of the actual job once you get a data analyst job i don't know i'd have to think about that to be honest what do you think are you dashing nano degrees i think that they probably are really good i think they're probably expensive for what you're getting or with all the free courses or the cheaper courses that you can get i definitely think there are are cheaper options i just don't know i've never i've never taken it myself but i know people have taken it and they liked it and they learned things but the cost is pretty high i i personally wouldn't be taking it what's the best way to practice sequel at home i have uh you know here's my honest opinion and i'm not just trying to self-promote it's you you need to download your own sequel server on your computer like you need to download my sequel post-grade sequel microsoft sequel server i have on my computer right now microsoft sequel server and i have uh then that's sequel server management studio to give me the uh to give me the display and everything i need right i highly recommend doing that and i have a video the basics course the very first video shows you how to download everything set everything up get data in there everything so if you're curious on it on and i just the best way to do that because you can then say you have experience or you've used sequel server management studio and that's way better than just putting sequel on your resume or or just you know just using online things to practice queries you want your own data you want a place where you can toy around with it and mess around with it that's what i recommend uh all right i got five more minutes i'm just i'm knocking these out uh next one hope you are well what do you know about marketing data analytics not much if you know anything about the job skills i'm guessing sequel yeah sorry i don't know anything about marketing analytics i'm sure it has a lot of similar skills it's just a regular data analyst job but i can't speak specifically to marketing analysts i wish i could um neil says just landed my first role as a business analyst congratulations that is awesome we'll be working with teplo a lot in these oracle sequel nervous hey don't be nervous look you're not going to be expected to know everything to learn as much as you possibly can as quick as you can become invaluable you know become someone who's who's you know bringing worth to the team and you will do amazing i guarantee it um do you think it's worth it to go to a boot camp if you want to do a career switch in a data analytics if so do you recommend any good boot camps i've heard of general assembly and think well here's my and i did a whole video on boot camps degrees all these things here's my overall thought boot camps to me are so expensive for what you're getting and unless it has a job placement rate and a job guarantee you will not pay a cent until you get a job it is not going to be worth it plays like think well thankful and general assembly have probably really good courses um and really good teachers and you know they may be really good but they do not have a job guarantee do not do it that's my two cents um try to make a video on skill path followed by data analysts that will be next week that will be my next week's video is supposed to be this week had an issue it's going to be next week where do you recommend hosting a data analyst analytics portfolio you can make your own website like on wix and squarespace like you said you can do that i have mine on github.io that's the one that i recommend to everybody i love github.io it just hooks up to my github account love it um cfa exam for data analysis course i don't know what cfa is i don't know what that is sorry i'm skipping your question ash super sorry about that i just don't have an answer um is john david arianson that you interviewed for data consulting yes it is super nice guy um he's my first interviewer but i have others planned so i'm gonna start i'm just bringing on some guests because i guarantee you guys are getting bored with me already i you don't have to say it outright i know it's happening though you don't have to say it so i need to bring on some new talent some new some someone probably people just more um entertaining than myself to be honest um i'm in it support trying to switch to data analytics any advice uh if you've been listening i have so much advice on this stuff but i highly recommend um you know learning sequel tableau python building a good resume building a good portfolio um and then just marking yourself really well our sequel next yash asks is sequel excel in tableau enough to get an entry-level job yes it is just learn it well and know know know what you need to know and know what you don't know and keep learning from there get that entry-level job and just learn as much as you possibly can any good resources to learn about specific domains i want to learn about bio pharmaceutical domain for a business handle swirl you know i work in that industry um and honestly i don't know there are some things that in the healthcare realm but for pharmaceutical specifically i don't know um did anil spend all eight hours of work in front of a pc yeah pretty much leila sorry sorry to tell you that it is basically in front of a pc all the time um except when i used to go into business meetings um and i used to talk with my boss and stuff like that then i wouldn't be on my computer but now i'm always on my computer so yes i spend too much time um how realistic i may go over a little bit because i just got there's someone this you guys have such good questions i don't want to i don't want to you know i don't want to miss any uh surge asks how realistic is a track from public accountant financial audit to financial data analyst data analyst data scientist thanks you know it's hard to answer but i really think that if you have the skills and you have that domain knowledge which sounds like you have that domain knowledge domain knowledge is so important if you can sell that and you can quantify and say these are the skills i know and this is going to be good for a data analyst role you can make a transition um all right key i i i'm trying i'm going guys i'm going um oh i skipped a few hope i didn't oh i don't skip any important ones um but um all right guys i'm going to do like two more questions i see more at the bottom and i feel bad for missing them um but you know i'm doing what i can um how do you recommend to share your portfolio with prospective employers never ask that really good question so what i did when i was first starting out is when i worked with a recruiter i sent a one sheet with scripts that i had written showing off my skills i don't recommend that you can do that i don't necessarily recommend that i would send them a link put it on your resume put on your linked in um a link to your portfolio which should be online like a github.io or another platform so a link on on there and then if you want to even go in further you know put it off like i did work for me i guess um okay joe sorry if i skipped your question i didn't mean to do that man i'm a recent graduate in physics and psychology but want to get into data analytics what should be my next moves take a bunch of courses i'm not in i'm not i have a bunch of videos on courses and i'm not just saying this for you to go and watch those videos take a bunch of courses make sure that this is a field for you that you can learn the skills that you can learn sequel uh you know i recommend learning tablo after that excel python you don't have to learn python but it'd be good if you did highly recommend taking courses on that making sure you can learn the skills start building up your resume build up your portfolio just like any other anybody else who who's kind of been asking you know i recommend trying to use your degree if you can if you have some domain knowledge in order to get a job um okay there's a bunch of questions left um all right maybe i'll run a little bit over maybe i'll do a little bit over sorry about that or maybe that's a good thing um and i'm just going to go super quick i've been going like not stop talking for like an hour but i'm just going to keep powering through for you guys because i care about you want to answer your questions um ibrahim says i'm currently doing data analysis python and r i want to get into google data science what should i learn in order to get a job after i graduate from bachelors um that's a really hard question um email me or message me or comment that's why i have some time to think about that one how often should a data analyst spend learning on his own time i'm always learning um even now i still take courses a little bit less than i used to because i had less time but you should always be trying to learn new skills if something interests you check it out do personal projects you build that portfolio even when you have a job and you're safe um from you know that always be building always be learning i just i would continue to do that in your free time if you have if you have that opportunity is it easy to switch the career and the data analysis how welcoming companies while hiring such people if you don't have a background in data analytics and you're just trying to switch if you're if you usually a teacher and you're trying to switch it's difficult because there are a ton of people trying to get into the field right now and it's over saturated because a lot of places have stopped hiring um some places have increased their hiring some places have decreased their hiring so hiring overall has stopped um in some in some places so it's going to be more difficult just in general dear alex can you send us your cover letter before we see the resume can you send us your cover letter before you see the resume i'm going to make a video on that where i show my updated cover letter my updated resume um and stuff like that i just you know not at a place where i'm going to do that yet but i definitely will be doing that do your core live sessions as your followers can watch later yes i will absolutely be doing that it is going to be the worst quality one available out of all of them because the other ones have better setups super so i'm going to have to do another one of these in like a couple weeks next month i you know what i'm going to say is right now i am doing another one next month and i'm going to make sure that i have my setup correct and that you guys get the best quality you can possibly get because this uh is frankly uh it's not the best it's not the best quality um how much deep learning should we know none you don't need to know deep learning maybe the terminology but you don't need to know deep learning definitely not um hi alex can you tell something related to supply chain analytics i don't know anything about supply chain analytics i'm so sorry wish i did um hi alex i'm a data analyst and a sales team and fortune 500 company i build many many bus tricks working on data architecture data modeling i'm wondering most data analysts do these things most analysts do not work um in data architectural some a lot do in data modeling um you know i work a lot of data modeling i think many do data architecture now data architecture is is a skill set mostly for data architects and data engineers sometimes database developers but not typically for data analysts um let me see oh gosh i did that thing where i skipped again oh i'm i'm getting close i'm almost caught up stop asking questions no more questions in the chat um because otherwise then i'll just never catch up um oh i went back too far can you analyze stark stock market as a data analyst absolutely and there are so many videos um about how to analyze the stock market and you can download data sets in tons of places you can definitely do that um let's see can we solve myself access can we install microsoft sorry i was reading before i can we install microsoft access file as a software in pc you definitely should be able to do that um microsoft access is kind of like a simpler version of sequel kind of it's sort of a database really interesting how it works i've you i've used it quite extensively in a previous job um but i like it i think it's a good a good job to get oh i'm almost caught up yes hello learning dax is Diego says is learning dax irrelevant for a data analyst um entry level job definitely definitely doesn't you do not have to know that to get an entry level job just straight up you don't have to know it but you can know it it's a good skill some some people really like that that's that you have that how about the data camp courses um again i talked about data camp earlier i have a tiny bit of experience but not enough to give a recommendation i'm sure they're good a lot of people like them i don't have that last one very last one nobody else has questions please please i'm already five minutes over tableau versus power bi which one do i recommend there's one better than the other i both i think they both have their place i think for beginners they should learn tableau tableau has a better user interface uh i think a little bit user better user interface as well as um it's easier to create an online dashboard whereas with um you know with power bi it's a little bit more difficult um and microsoft intentionally made it that way so you buy the product and tableau is a little bit better i think in that way um but i've used both i like both for everyone joining i'm about to actually um get off soon so i'm super sorry about that and the quality is bad you guys don't want to watch this i i promise you i don't want to watch this i'm just kidding you guys should stick around it's pretty good it's pretty good stuff um i'm well versed the kid they keep coming so i'm gonna keep going i'm well versed in tableau and sequel should i do i need to know about aws redshift microsoft azure to stay relevant in the market yes unfortunately i highly recommend learning some type of cloud platform i use azure i've taken azure courses i highly recommend learning one of the major platforms aws google cloud or azure um what is the process of analytics stocks in forex pairs how much do you know i don't know what that means no i don't know what that means at all um i'm late hi alex miguel from south dakota is that what that means sd south dakota what's up what's going on i'm sorry you i'm sorry you came late if you didn't already my mic isn't working my webcam isn't working i'm using my built-in webcam and my built-in it's just it's a mess over here that's what's happening dj beats it's an absolute mess over here um all right guys i caught up to all the questions i answered i i may have missed one or two in that i'm super sorry if i missed your question specifically um but email me i'll try to answer it um in my email i did put that in the chat so if you see that feel free to email me thank you guys so much for watching um san diego not south dakota that makes so much more sense now yeah san diego nobody nobody who's a data analyst lives in south dakota it's not possible they don't have any data analysts for there um thank you guys so much for watching it was super fun i enjoyed answering your questions i wish it would have been a little better uh visually and audibly but i'm glad that i got to um that i gotta see you guys and talk to you and like i said if you didn't catch it i am going to do another one of these uh next month guaranteed 100 because the quality of this one is just so bad and i'm super sorry for it that is my fault i am sure of it and 99 fault of youtube so with that being said thank you guys so much i'm hope you enjoyed it hope you learned something from it it was fun for me i enjoy these things uh all right bye y'all take it easy have a good one and good night well good night here goodbye wherever you are bye