Been a data analyst for about 10 years now and i crossed over to the civilian side about 3 years ago. The skills i lacked were the new technologies and bigger proficiency in SQL. This video is 100% correct.
Thank GOD here is someone that tells it like it is. These certs are okay but projects are one of the best ways to get a job. Like Lukas said, "This is not a sprint, but a marathon."
Nope, projects are useless, employers don't have time to see them when they have to review 500+ CVs. At most, projects would help you to stand out on LinkedIn. Industry certifications or a degree in stats, data science, computer science, etc. it's what actually matters
agreed! I feel certificates are really good for learning the material and learning how different companies do Data Analytics but certifications are at the top of the list when trying to get a job...you can get a job with a certificate and a portfolio...it just becomes easier with certifications.
Just passed the microsoft power bi data analyst cert this week. I learned a lot while studying for it. I'm in my last semester of an Information technology degree. With a decent portfolio I should be good to go
The true purpose of online programs is to assess whether you have a true interest in the material or not. If you can finish a course, complete a project, write up your results, and post it on a forum, then you may have the right aptitude for the profession. To get a job, you're going to have to network with people.
Thanks for this. A lot of Tech UA-camrs just sugarcoat a lot of the harsh reality of the getting into the Tech industry. As someone who's planning to get into a tech job in a couple of years, this gave me some good forsight into what can actually help me 👍🏾.
I've been in the tech industry on embedded software side... this includes everything from IT, cybersecurity, homologation, Operating Systems like RTOS, Unix, ChibiOS, or superloops... It got me bummed out that a lot of the work....is fixing outsourced trash.
This is a great video imo. I realized working on my “bootcamp” that it was not going to be enough to land a decent job. I will meed to continue to prove myself through independent or guided projects. Having only a certificate for data analytics is like knowing only the alphabet for a spelling bee. You can guess but will definitely make huge mistakes
I'LL AGREE WITH YOU. I ONLY HAVE GOOGLE DATA ANALYTICS CERT AND I REALLY WANT A DATA ANALYST JOB BUT I FEEL LIKE I'M NOT READY SO I APPLIED FOR ANOTHER JOB WHILE I'LL STUDY SQL, POWER BI AND PYTHON. ONCE I'M GOOD WITH THESE I'LL TRANSITION TO DATA ANALYTICS.
I've finally made up my mind to start my journey from the scratch. For the sole purpose of bettering my life and learning data analytics, I've bought new laptop since the old one was very faulty and slow and I'm planning to genuinely start from zero. Yes, motivation goes away sometimes especially if you're alone or doing this at home so it will be really great if someone also wants to join me on this journey....if there's someone just starting out and also want someone to be constantly reminded of the progress...i think by sharing progress and telling each other what it needs to be done, we will progress faster than average. So let me know when anyone is interested.... It would be faster to learn together, maybe in a group and sharing useful information
hello i am also starting from scratch, where exactly did you begin your journey? Im currently doing my further education in college with my a levels and non of them align with Data science as i have onlly recently discovered my passion for it
@@renmohammed7785 less than 2 weeks ago, I started learning it from "Alex" channel. He provided "Free bootcamp" for people who want to learn to be an DA through his channel. It consists of 70 videos (at the moment) and he said this would cover most of the basics (it's free so of course not so in depth)...so I'm currently going through his bootcamp since I'm totally new to this field but I must say that it's really cool so check it out when you have time)
Hi .. I am also switching careers from different domain to Data Analytics... currently doing Google Data Analytics course.. wondering if we have group sonwhee to share knowledge & help each other out
I have the Microsoft power BI certification, and 9 years of SQL experience. Couldn't even get an initial interview as a data analyst so far. Been applying since last month.
It’s taking people upwards of 5 months to land jobs now and it could be that you need to review your resume/CV and cover letter as well as how you’re tailoring them to the terms/phrases used in the job ad More and more companies are using automated systems to only glad applications that have high match rates with their job ads and regardless the experience, if yours is a low match then you won’t be considered
I just found this video randomly and it helped me a LOT. I thank you a lot for giving this recommendations that cleared my mind on what to do to success in this industry.
Thank you for the info! Beginners courses in Sql and python were able to give me a bit of confidence that I can do it(comming from different background) and helped me to get accepted into Master's in Big Data Analytics!
@@AmineBourasAB6HDHi there! Sorry, that I did not see in time. Well, I was enrolled in Master's on the basis of my work experience (6 years as insurance underwriter + i did there some data analysis in excell) . As well, I think that I got python and sql basics certificates helped as well. The only recommendation that I can give are courses the the university suggested to take before starting the program. I can give names of those courses.
I felt defeated when I read the vid title lol but after watching, i was definitely valuable info that makes me feel my roadmap to becoming a data analyst can be even stronger
@@ShawnFX depends on the company. Some organizations use tableau and others power bi. Both essentially do the same thing . personally think power bi is a better.
@shaunFX Yes. Remember you have Power Pivot, Power Query , Power Automate (as an add in) and soon Python built in Excel. This is basically Power BI in Excel. Learning this will stop you being a data monkey and actually doing finance
I don't want to become a data analyst but am just trying to break into the tech field and want to at least have a good understanding of databases. I'm primarily learning web development, cloud computing with sights on eventually working in DevOps probably, but I'm planning on taking a 20 hour SQL course on Udemy this summer because it just seems like a great additional field of knowledge to have
There are SQL certs but they are hard. Oracle has an Oracle SQL Developer and MySQL Administrator/ Developer. The other one is Azure Database Administrator certification.
I have attempted the power BI data analyst Specialist exam 3 times already, since February 2023 I don't know if it's really hard or I'm just unlucky. The first time I was really sick, the second time I encountered technical difficulties with the online examination program (PearsonVUE) and lost a huge section of the exam, the third time I encountered the hardest questions of both times. Then, I realized I had to get a better understanding of Power BI and will do my fourth attempt next month.
Thanks so much for this video I'm starting my journey to analytics, as disabled early 20s student I'll be doing it all own pace at home but I do need that little push in form of earning certificates and taking exams. I really appreciate that you teach us the difference of certificates and certifications and which are typically more important for jobs, While still acknowledging that certificates can be valuable to yourself. And great tips/examples of what paths you can take.
Thanks for the content bro. But I would say even certs are not useful now, at least in Canada. With 2 Canadian internship experience, a master’s degree in data science, and all certs you can imagine for an entry level data analyst role, I got 1 interview out of around 200 applications so far. For one role that I had working knowledge in the tools, domain knowledge and all certs they listed in the job posting, and even with an internal referral, I got a rejection email 4 hours after application. It seems the market here is even tougher than in the States. Having that said, I will keep going until I land the first DA job.💪🏻
@@learnwithlukas did you see a better interest from companies while following this certified pathway? I just started off in the Google analytics certificate and believed it was just that but didn’t realize getting certified for the certificate was better.
I'm from academia. My internship is in the private sector. The fact that I'm a good problem solver, am an experienced statistician and programmer, and am a PHD student is what keeps me competitive with other people in industry. Certs won't give you those skills. Stats and modeling isn't something you learn overnight, it takes years of experience (not even just in industry, if you're an econometrician, you'll do fine). Either way, being a data analyst or scientist isn't "just" code, it takes lots of substantive knowledge. That's partly why we make the money we do.
This. The most valuable trait of a data analyst is the ability to accurately interpret complex data structures mathematically, condensing it into easy to understand figures and coming up with a proper and suitable conclusion to the data. All these courses and certifications only lay down the most basic foundations for you, the most they can get you is an entry data job at some boomersoft company imo. Big data and big tech will still look to academia first (graduates and PhDs) before they get some rando who have no experience or education in the field to work at their company.
Gosh, that's bad news for me tbh. Honestly thought the certificate could help me get a job (on top of my somewhat relevant degree). I would need to leave Canada if I couldn't get a data analytics job by mid next year due to the crazy cost of living. At least it is good to find out early than later. Still might wanna try to find a job in the field if possible. I just hope I can prove I actually learn the stuff by making better than average projects.
I am new to the data field, just got the data engineering foundation cert from IBM on Coursera and 1 more capstone project to finish the IBM data science cert on Coursera. I think one big difference between IBM cert and Google cert is that IBM has peer assignments, and you have to actually learn it :). I'm going to take one more data analyst cert from IBM. I am also planning to follow the study path on Datacamp for Power BI and be ready for the exam in the future. Your recommendation is really similar to what I plan to do next and I thank you so much because it strengthens my belief to pursue my plan.
Certificates are just an useless piece of paper for employers. If you want something substantial go for certifications. And there are almost no entry-level jobs for data engineering, that's a top role, any sane company wouldn't hire someone who just learned some skills in 6 months. Start with an entry level role like Data Analysis or software engineering, build solid SQL skills and start climbing for better positions
@@sng8240 That's what you say, not what the employer says. I am an electrical engineer, used to do recruitment work for my boss. At least these certificates show what you have studied, not the projects that you copy others. In the interview, they can know whether you have studied for real or fake, and whether the project is done by you or not. I want to make a career switch because I want to gain more experience and knowledge for my master's studies. You don't have to say things that everyone already knows.
You should honestly focus on 1 of the roles up there. A Data Engineer, Data Scientist, and Analyst have different tools and expertise. There might be some overlap but not enough. There are even many differences between a Data Analyst and BI Analyst. Data Engineering is in a totally different category of its own.
I am doing the advanced Data Analytics course on coursera, there almost majority of the answers on forum are laterally dots or copy past of the question.
Thank you for this. I am switching focuses of my career and I am doing the IBM data analysis cert on coursera. I’m actually using it to get a better understanding of concepts I know a little about. My plan was actually to get a (2nd) masters but with a concentration in informatics but this could help me at least get my feet wet. For clarity I’m coming from healthcare patient facing and I want to work to get to healthcare informatics essentially
Just my opinion but if you already have a masters, a second one will not make you look any better. Focus on actually learning skills, doing projects, and get a couple certs
I was a healthcare data analyst and PM for 13 years. There is no fundamental difference that getting another advanced degree would bridge. Stats are stats and healthcare is still a business. This means that all financial KPIs, dashboards are roughly the same as any other company. When I'm in the hiring process, I am asking what can you do for our project? I don't care about the accolades if it doesn't improve our processes. If you're talking patient health/population health data, we hire MDs with MBA/MHAs. You aren't competing with that unless you brought a real toolkit with you. You'll get out-papered by clinical staff that pivoted. We would rather have a nurse that knew python than your resume. Otherwise, you're going to be in business ops... guaranteed.
I also don't say this to criticize; I genuinely wish you the best. When I've had staff with this same thought process, I feel like it's really just pursuing more titles because you are scared to be unworthy in the workfield. Stop doubting yourself and just take a Jr analyst position in the field of data you prefer. Maybe ask yourself: why do I feel drawn to healthcare specifically? Is there a deeper passion at play? Should that be the thing I actually pursue? It sounds like insecurity and knowing yourself might help you stop feeling like you need more degrees to bolster your worth. You really don't. You already kicked ass in school. I feel like more school would be simply avoiding being in the field. And it won't help as much as simply rolling your sleeves up and getting into the thick of it all. How do you know you'll even be happy with that pivot? I was the only non-clinical background on our analyst team. Every other analyst was a nurse who realized they didn't actually like the work a nurse does. But they do like math and programming languages! You didn't even have to force it; they learned it of their own volition and they were so much happier when finally honest with themselves. Best of luck.
Oh my God!!! I haven't heard something this depressing in a long time. Though it's understandable, as long as there is high demand and low supply, good salaries can be negotiated. Especially if potential candidates are discouraged from this field from the very beginning. I don't agree that it's hard to find a job as a beginner. The demand in this profession is currently so high that it's considered a shortage occupation everywhere, and if someone has an aptitude for it, they can get a job even during their studies. That's how I got mine, too. I was only halfway through my studies and had multiple offers, even though I didn't do anything for it. The last time I watched Lucas's video was when I decided to change careers a bit more than a year ago. Even then, he took away even my will to 'get out of bed'. Thanks to others, I was stuck to my decision. Now I have to watch videos of puppies and kittens all day to restore my mood 🤕🤒🤮
This is from my personal experience. A little bit of background. I had no prior experience to power BI or any knowledge of BI tools in general. I read through the entirety of the Microsoft Power BI self-paced content, bought a set of practice questions off udemy and passed the examination. It's been about 4 months now and I'm still struggling to find a job. I'd say the job market for data analytics is really bloated right now and is difficult finding a job. I'd like to think the Power BI certification helps, and I definitely think better than nothing, but it seems like getting into data analytics right now is hard in general
Have you created portfolio showing your skills learned? If not, focus on doing projects and put the link for them in your LinkedIn account to show what you can do.
Thank you for the information..I didn't know there was a difference between certificates and certifications. Makes sense when I think of it like the IT field. 😮 I appreciate it.
Says who? You can have a degree and not have the skills and you won’t get a job it’s a skill based world if you have the skills you’ll find a job for sure
@@Albidon I absolutely agree with the first part because the same applies to professions that require a degree in that field. What I’m saying is that with the growing interest in people gaining the skills they need and filling out the entry-level, we’re getting closer to a time where being in tech will share that barrier to entry that law, medicine, etc has with needing some kind of degree AND the required skills to break in without connections
@@PaladinLeeroy42069 Lol I disagree Google has clearly established what college degrees mean in the real world without the coding skills no skills = no job no matter who you are medical and law is different
i was wondering where i should even start and how i could even get into Undergraduate degrees with relevant experience instead of my A levels as they are not as relevant to the mathematical aspect of Data science as i take social sciences. I do not have a part time job and i am still looking, with a lack of support from the family im finding it really hard to get certified solid qualification for Data Science. Would love some help! im doing this all on my own thanks
Thank you for making this video. Are you able to share your opinion on the Comptia Data+ Certification? How would you compare it to PowerBI and Tableau Data Analyst Certifications?
At the moment im in a point in my life that i want to go back to the tech field. I used to be a contractor for meta 2 years ago until the tech market crashed and i was let go. I have not been able to find another company who is willing to give me an opportunity to learn. The only thing under my belt is my associates and then my past a technician for a semiconductor company. Currently i am working as TA for a school and its a great job but i really miss the tech field. As a beginner and having to start over...would Microsoft Power BI Data Analyst Certificate would be good to start or do you recommend something else as a fresh beginner?
Great insight sir! However, what would you say about folks who will push back and defend specifically the Google certificate in Coursera that also provides support for job hunting? I believe they have hundreds of comp's listed in their page that's accessible to those who complete the course.
@@ignacioa3698 They are useful in the sense it shows initiative for someone wanting to get into the career. With that said, you are going up against hundreds of people using the same platform, applying to the same job within the same company. It will be difficult to be recognized by them. A certificate of completion is different than being a certified specialist as stated in this video. So keep that in mind because people are frustrated at the fact that they are not able to get hired by these companies because they don't stand out or someone is more experienced in what they are marketing about their skills both technical and professional.
Hello, I also completed the Google Data certificate. It's true you have access to other jobs once you complete the certificate. However, that's that. You are not even guaranteed an interview with those job opportunities. So, you need to grind a lot either acquiring more knowledge, learning other skills or building a portfolio. This video was truly an eye-opener for me. It resonated with me a lot.
@Thawne because competition eliminates chances for monopolies to happen. Mid to smaller companies that are able to get a piece of the pie provides more for others in different industries. Instead of going for the white collar silicon valley bs that everyone tries to do, talent can be spent at other companies much more profitable such as the heavy industry. Programmers are wasting their time creating and maintaining apps or any other type of software like for Google. Helping to build a safer car for everyone to use is much more satisfying than some app on your phone. Innovation baby, and capitalism is not perfect but it's better than jobs being like Amazons warehouses. Low skilled job for minimal pay and high risk of injury. Or taking a quiz so you can see what they will pay you but get denied the job.
Great tips Lukas. You're absolutely right that without experience or a very strong portfolio, the chance of someone landing a gig is near zero especially in this competitive industry from my personal experience. From your perspective, does having a certification make a small difference or a big difference to a person with no pervious experience in the field?
Its not about what you know its about who you know , even if you watch a couple of data analysis tutorials on youtube and somewhat decent understanding if the concept if you know the right people theyll help you get the job
The problem with these types of certification is that the barrier to entry is extremely low. You just need time and a couple of hundred dollars. You are going to find yourself competing with people in low income economies who will undercut you all the time. Certifications on multi-million dollar platforms like Workday or Salesforce are far more valuable because you need a platform to practise on and you can't just buy one. It's a bit chicken and egg, but that's why you earn more money on these.
I would not recommend beginners to persue certifications on these platforms instead of these fundamental certifications, but I do see the point you're making.
Man . I have finished the Google data analytics certificate specialization. I haven't landed an internship in data analytics or data science yet . This video is facts no one says . All the other guys are just sponsored by coursera to recommend overpriced courses that don't have any value in the real market
@@deronlester3072 ya I got an internship after I passed the AWS SAA certification. No one gives 2 shits about these Coursera certificates . They are overpriced and have no value .
Wow this video is a godsend. Iv no clue where to begin buy i did stumble on yhe google analytics course which i planned on doing and hope that gives me some creds. But you just destroyed that hope. Im thankful though cause now ill look into those two you mentioned. Money is a big issue for me so i cant just drop alot of hundreds of dollars on learning.
Lucas the content is amazing . One question that would be highly appreciated if you respond. I have studied SQL but i cant proceed with a project , i dont know how/where to start Can u assist me? Thanks in advance
I appreciate the insight. I’m looking into taking that Google course, and my idea was to get a good looking portfolio afterwards, good thing that was a good line of thought. My next question becomes, what is being a data analyst like hours wise? I am going to school right now for music and I want to pivot into data analytics so I have a good job to support my career choice of music. Would I be expected to work set hours every week or is it like the food business of “you get off when the job is done” ? I would essentially want to have free time outside of work so that way I could hone my skills and not just live at work
Data Analyst Beginner Roadmap:
learnwithlukas.com/da/
What about DAX? How important isit to learn DAX?
link website not found
fixed! Thank you@@jesusrodriguez915
@@learnwithlukas is AWS data engineer certification good for data analyst
My 2 cents, learn excel, then SQL and then Power BI. Those are key for data analysts, then is just adding more skills to your career.
Been a data analyst for about 10 years now and i crossed over to the civilian side about 3 years ago. The skills i lacked were the new technologies and bigger proficiency in SQL. This video is 100% correct.
Were u a MMA in the Air Force ?
@@mkane212 yessir
@@brandondiaz-lopez3945 I am too but I’ll be out in 2 years. If you don’t mind, how’s the job prospects for us in the outside as an analyst
@@mkane212what's MMA?
obviously the infamous mixed mathematical analyst @@JediWebSurf
Thank GOD here is someone that tells it like it is. These certs are okay but projects are one of the best ways to get a job. Like Lukas said, "This is not a sprint, but a marathon."
projects?
@@ChristinaAjiboye Yep, projects those DIY analysis where you use datasets from Kaggle to create data vizes.
@Thawne Yep, which ever university you attend that have this.
Nope, projects are useless, employers don't have time to see them when they have to review 500+ CVs. At most, projects would help you to stand out on LinkedIn. Industry certifications or a degree in stats, data science, computer science, etc. it's what actually matters
@@sng8240 This guy gets it, optimize your linkedin, have both certifications and THEN you can showcase your projects.
agreed! I feel certificates are really good for learning the material and learning how different companies do Data Analytics but certifications are at the top of the list when trying to get a job...you can get a job with a certificate and a portfolio...it just becomes easier with certifications.
Just passed the microsoft power bi data analyst cert this week. I learned a lot while studying for it. I'm in my last semester of an Information technology degree. With a decent portfolio I should be good to go
Good job!
Did you use a course in order to pass? Would love to hear your story!
@ellong820 I did the PL-300 course by Phillip Burton on Udemy and the skillcertpro practice tests.
The true purpose of online programs is to assess whether you have a true interest in the material or not. If you can finish a course, complete a project, write up your results, and post it on a forum, then you may have the right aptitude for the profession. To get a job, you're going to have to network with people.
Thanks for this. A lot of Tech UA-camrs just sugarcoat a lot of the harsh reality of the getting into the Tech industry. As someone who's planning to get into a tech job in a couple of years, this gave me some good forsight into what can actually help me 👍🏾.
I've been in the tech industry on embedded software side... this includes everything from IT, cybersecurity, homologation, Operating Systems like RTOS, Unix, ChibiOS, or superloops...
It got me bummed out that a lot of the work....is fixing outsourced trash.
This is a great video imo. I realized working on my “bootcamp” that it was not going to be enough to land a decent job. I will meed to continue to prove myself through independent or guided projects. Having only a certificate for data analytics is like knowing only the alphabet for a spelling bee. You can guess but will definitely make huge mistakes
Great video... clearly states the difference between certificate & getting certified. Helped me understand why I am not getting the interviews.
Thank you, and good luck!
All the best, hope soon all recruiters would be all over you.
@Ayan Bhattacharjee Thank you! I'm definitely getting there slowly but surely.
I'LL AGREE WITH YOU. I ONLY HAVE GOOGLE DATA ANALYTICS CERT AND I REALLY WANT A DATA ANALYST JOB BUT I FEEL LIKE I'M NOT READY SO I APPLIED FOR ANOTHER JOB WHILE I'LL STUDY SQL, POWER BI AND PYTHON. ONCE I'M GOOD WITH THESE I'LL TRANSITION TO DATA ANALYTICS.
2:40 tableau certificatiom ecam fee 250usd
3:00 microsoft power BI Data analyst 165 usd
Thank you for this video. I’m about to finish the Google cert but I’m glad I now know I’m not done yet.
I've finally made up my mind to start my journey from the scratch. For the sole purpose of bettering my life and learning data analytics, I've bought new laptop since the old one was very faulty and slow and I'm planning to genuinely start from zero. Yes, motivation goes away sometimes especially if you're alone or doing this at home so it will be really great if someone also wants to join me on this journey....if there's someone just starting out and also want someone to be constantly reminded of the progress...i think by sharing progress and telling each other what it needs to be done, we will progress faster than average. So let me know when anyone is interested.... It would be faster to learn together, maybe in a group and sharing useful information
Hello, how is it going for you so far? I'm Interested in learning Data Analysis too, I'm yet to begin, can we link up ?
@@osamedeosadolor6116 of course, we can. I'm still learning SQL and I would say I'm currently at intermediate level
hello i am also starting from scratch, where exactly did you begin your journey? Im currently doing my further education in college with my a levels and non of them align with Data science as i have onlly recently discovered my passion for it
@@renmohammed7785 less than 2 weeks ago, I started learning it from "Alex" channel. He provided "Free bootcamp" for people who want to learn to be an DA through his channel. It consists of 70 videos (at the moment) and he said this would cover most of the basics (it's free so of course not so in depth)...so I'm currently going through his bootcamp since I'm totally new to this field but I must say that it's really cool so check it out when you have time)
Hi .. I am also switching careers from different domain to Data Analytics... currently doing Google Data Analytics course.. wondering if we have group sonwhee to share knowledge & help each other out
I have the Microsoft power BI certification, and 9 years of SQL experience. Couldn't even get an initial interview as a data analyst so far. Been applying since last month.
It’s taking people upwards of 5 months to land jobs now and it could be that you need to review your resume/CV and cover letter as well as how you’re tailoring them to the terms/phrases used in the job ad
More and more companies are using automated systems to only glad applications that have high match rates with their job ads and regardless the experience, if yours is a low match then you won’t be considered
Thank you so much for this. I am 41 and learning the basics still, looking forward to be ready in around 2 yrs.
You got this!
Yet another brilliant content! Agreed with all of it so far while working on it. Continue to chart the path for us to follow.
Thank you!
How's that going for you?
I just found this video randomly and it helped me a LOT. I thank you a lot for giving this recommendations that cleared my mind on what to do to success in this industry.
Thank you for the info!
Beginners courses in Sql and python were able to give me a bit of confidence that I can do it(comming from different background) and helped me to get accepted into Master's in Big Data Analytics!
Best of luck!
@@AmineBourasAB6HDHi there!
Sorry, that I did not see in time.
Well, I was enrolled in Master's on the basis of my work experience (6 years as insurance underwriter + i did there some data analysis in excell) . As well, I think that I got python and sql basics certificates helped as well.
The only recommendation that I can give are courses the the university suggested to take before starting the program.
I can give names of those courses.
@@AmineBourasAB6HD Its been 2 months, have you started?
I felt defeated when I read the vid title lol but after watching, i was definitely valuable info that makes me feel my roadmap to becoming a data analyst can be even stronger
I really like your videos specially about data analysis, straight honest and up to the point
Thank you!
I didn't know the difference up until now, Thanks sir
Power bi is key, the integration within the Microsoft stack is key. Sql basics are important.
For a job like financial analyst, would learning Tableau or Power BI be better?
@@ShawnFX depends on the company. Some organizations use tableau and others power bi. Both essentially do the same thing . personally think power bi is a better.
@shaunFX Yes. Remember you have Power Pivot, Power Query , Power Automate (as an add in) and soon Python built in Excel. This is basically Power BI in Excel. Learning this will stop you being a data monkey and actually doing finance
I don't want to become a data analyst but am just trying to break into the tech field and want to at least have a good understanding of databases. I'm primarily learning web development, cloud computing with sights on eventually working in DevOps probably, but I'm planning on taking a 20 hour SQL course on Udemy this summer because it just seems like a great additional field of knowledge to have
SQL really isn't that hard to learn, honestly. You'll breeze through it.
There are SQL certs but they are hard. Oracle has an Oracle SQL Developer and MySQL Administrator/ Developer. The other one is Azure Database Administrator certification.
I'm not very familiar with SQL certs but might be worth looking into! Thanks
I would add to practice sql and Python on hacker rank or leetcode and get ranked will be great as well
Thanks for the video. What do you think should change in job hunting after AGIs like gpts came out? It disrupts a lot of industries doesnt it?
Thank you! Video coming on this soon. I'll try to go over scenarios and things you can do.
I have attempted the power BI data analyst Specialist exam 3 times already, since February 2023 I don't know if it's really hard or I'm just unlucky. The first time I was really sick, the second time I encountered technical difficulties with the online examination program (PearsonVUE) and lost a huge section of the exam, the third time I encountered the hardest questions of both times. Then, I realized I had to get a better understanding of Power BI and will do my fourth attempt next month.
Very valuable and not just for Data Analysis. I absolutely forgot about the Microsoft-Certifications. Thanks for the reminder!
Glad it was helpful!
Yeah are you working by the way? As an analyst
Thanks so much for this video
I'm starting my journey to analytics, as disabled early 20s student I'll be doing it all own pace at home but I do need that little push in form of earning certificates and taking exams.
I really appreciate that you teach us the difference of certificates and certifications and which are typically more important for jobs, While still acknowledging that certificates can be valuable to yourself.
And great tips/examples of what paths you can take.
Once completing Google certificates, there are over 150 COs connected with them ready to hire.
Thanks for the content bro. But I would say even certs are not useful now, at least in Canada. With 2 Canadian internship experience, a master’s degree in data science, and all certs you can imagine for an entry level data analyst role, I got 1 interview out of around 200 applications so far. For one role that I had working knowledge in the tools, domain knowledge and all certs they listed in the job posting, and even with an internal referral, I got a rejection email 4 hours after application. It seems the market here is even tougher than in the States. Having that said, I will keep going until I land the first DA job.💪🏻
Truly, SQL is the most important tool for the data analyst job. However, what if the first data analyst job has no any SQL experience?
Can you rephrase the question please
@@learnwithlukas Oh sorry, I mean if there has no chance to use SQL at first data job as experience. How to improve this point for the next job?
God bless your directness. I am trying to distill this massive pool of Certs and applications into the handful which are most valued
Thank you!! Good luck
@@learnwithlukas By the way, Lukas. I see Tableau everywhere but you prefer BI?
Why is that? If it doesnt take up too much of your time
@@stonwall9065 Personal preference. Both are good. Might make a video comparing them thought!
Thank you. Setting others up for success. Good man.
Thank you!
@@learnwithlukas did you see a better interest from companies while following this certified pathway? I just started off in the Google analytics certificate and believed it was just that but didn’t realize getting certified for the certificate was better.
I'm from academia. My internship is in the private sector. The fact that I'm a good problem solver, am an experienced statistician and programmer, and am a PHD student is what keeps me competitive with other people in industry. Certs won't give you those skills. Stats and modeling isn't something you learn overnight, it takes years of experience (not even just in industry, if you're an econometrician, you'll do fine). Either way, being a data analyst or scientist isn't "just" code, it takes lots of substantive knowledge. That's partly why we make the money we do.
This. The most valuable trait of a data analyst is the ability to accurately interpret complex data structures mathematically, condensing it into easy to understand figures and coming up with a proper and suitable conclusion to the data.
All these courses and certifications only lay down the most basic foundations for you, the most they can get you is an entry data job at some boomersoft company imo.
Big data and big tech will still look to academia first (graduates and PhDs) before they get some rando who have no experience or education in the field to work at their company.
Thank you for this video... this means a lot to me.
Gosh, that's bad news for me tbh. Honestly thought the certificate could help me get a job (on top of my somewhat relevant degree). I would need to leave Canada if I couldn't get a data analytics job by mid next year due to the crazy cost of living.
At least it is good to find out early than later. Still might wanna try to find a job in the field if possible. I just hope I can prove I actually learn the stuff by making better than average projects.
I am new to the data field, just got the data engineering foundation cert from IBM on Coursera and 1 more capstone project to finish the IBM data science cert on Coursera. I think one big difference between IBM cert and Google cert is that IBM has peer assignments, and you have to actually learn it :). I'm going to take one more data analyst cert from IBM. I am also planning to follow the study path on Datacamp for Power BI and be ready for the exam in the future. Your recommendation is really similar to what I plan to do next and I thank you so much because it strengthens my belief to pursue my plan.
Certificates are just an useless piece of paper for employers. If you want something substantial go for certifications. And there are almost no entry-level jobs for data engineering, that's a top role, any sane company wouldn't hire someone who just learned some skills in 6 months. Start with an entry level role like Data Analysis or software engineering, build solid SQL skills and start climbing for better positions
@@sng8240 That's what you say, not what the employer says. I am an electrical engineer, used to do recruitment work for my boss. At least these certificates show what you have studied, not the projects that you copy others. In the interview, they can know whether you have studied for real or fake, and whether the project is done by you or not. I want to make a career switch because I want to gain more experience and knowledge for my master's studies. You don't have to say things that everyone already knows.
@@sng8240 is business data analytics worth it bachelors
You should honestly focus on 1 of the roles up there. A Data Engineer, Data Scientist, and Analyst have different tools and expertise. There might be some overlap but not enough. There are even many differences between a Data Analyst and BI Analyst. Data Engineering is in a totally different category of its own.
I am doing the advanced Data Analytics course on coursera, there almost majority of the answers on forum are laterally dots or copy past of the question.
Man great outline thank you!
Glad it was helpful!
title i think is hyperbolic for the clicks
Thank you for this. I am switching focuses of my career and I am doing the IBM data analysis cert on coursera. I’m actually using it to get a better understanding of concepts I know a little about. My plan was actually to get a (2nd) masters but with a concentration in informatics but this could help me at least get my feet wet. For clarity I’m coming from healthcare patient facing and I want to work to get to healthcare informatics essentially
Just my opinion but if you already have a masters, a second one will not make you look any better. Focus on actually learning skills, doing projects, and get a couple certs
I was a healthcare data analyst and PM for 13 years. There is no fundamental difference that getting another advanced degree would bridge. Stats are stats and healthcare is still a business. This means that all financial KPIs, dashboards are roughly the same as any other company. When I'm in the hiring process, I am asking what can you do for our project? I don't care about the accolades if it doesn't improve our processes. If you're talking patient health/population health data, we hire MDs with MBA/MHAs. You aren't competing with that unless you brought a real toolkit with you. You'll get out-papered by clinical staff that pivoted. We would rather have a nurse that knew python than your resume. Otherwise, you're going to be in business ops... guaranteed.
I also don't say this to criticize; I genuinely wish you the best. When I've had staff with this same thought process, I feel like it's really just pursuing more titles because you are scared to be unworthy in the workfield. Stop doubting yourself and just take a Jr analyst position in the field of data you prefer. Maybe ask yourself: why do I feel drawn to healthcare specifically? Is there a deeper passion at play? Should that be the thing I actually pursue?
It sounds like insecurity and knowing yourself might help you stop feeling like you need more degrees to bolster your worth. You really don't. You already kicked ass in school. I feel like more school would be simply avoiding being in the field. And it won't help as much as simply rolling your sleeves up and getting into the thick of it all. How do you know you'll even be happy with that pivot? I was the only non-clinical background on our analyst team. Every other analyst was a nurse who realized they didn't actually like the work a nurse does. But they do like math and programming languages! You didn't even have to force it; they learned it of their own volition and they were so much happier when finally honest with themselves. Best of luck.
Thank you so much for this roadmap. I feel I can trust this information.
You are so welcome
I have been Certified in Power BI Data Analyst Certification. But no job for last 6 months
I took the Microsoft power bi data analyst cert and made no difference at all. HR probably don't even know what they are or what's the difference
Where do you live?
@@Albidon europe
@@gabrychina4435 I see why, I’m located on East coast usa best of luck tho anything possible in todays world
Oh my God!!! I haven't heard something this depressing in a long time.
Though it's understandable, as long as there is high demand and low supply, good salaries can be negotiated.
Especially if potential candidates are discouraged from this field from the very beginning.
I don't agree that it's hard to find a job as a beginner. The demand in this profession is currently so high that it's considered a shortage occupation everywhere, and if someone has an aptitude for it, they can get a job even during their studies.
That's how I got mine, too. I was only halfway through my studies and had multiple offers, even though I didn't do anything for it. The last time I watched Lucas's video was when I decided to change careers a bit more than a year ago. Even then, he took away even my will to 'get out of bed'.
Thanks to others, I was stuck to my decision.
Now I have to watch videos of puppies and kittens all day to restore my mood 🤕🤒🤮
like the quote "IT'S NOT A SPRINT, IT'S A MARATHON"
Data camp now hade certified exams too. Proving that you can do either python and SQL or r and SQL.
Thank you for sharing this infomation.
Glad it was helpful!
This is exactly the information I was looking for. Thank youl.
Glad it was helpful!
Good tips friend. Keep them coming.
Thanks, will do!
I almost skipped this video because most of these are horrible advice. This was spot on.
Thinking about getting analyst certs but aren't learning python? Family... skip the paperwork and focus on actual skills.
any strong SQL certification?
This is from my personal experience.
A little bit of background. I had no prior experience to power BI or any knowledge of BI tools in general. I read through the entirety of the Microsoft Power BI self-paced content, bought a set of practice questions off udemy and passed the examination. It's been about 4 months now and I'm still struggling to find a job. I'd say the job market for data analytics is really bloated right now and is difficult finding a job. I'd like to think the Power BI certification helps, and I definitely think better than nothing, but it seems like getting into data analytics right now is hard in general
Yep, it's tough for beginners
are you not even getting interviews though? do you list SQL as one of your skills?
I got 1. I do list SQL as a skill@@Zuranthus
Do you get any interview? I also have the feeling that’s it’s super saturated now.
Have you created portfolio showing your skills learned? If not, focus on doing projects and put the link for them in your LinkedIn account to show what you can do.
Why is Tableau more important than Power BI ?
What is the cheapest and best way to become proficient in PowerBI and AWS to land a job
Thanks so much for this brother
I have this I am certified but I couldn’t download the certification and I don’t know how I am going to get a job
Thank you for the information..I didn't know there was a difference between certificates and certifications. Makes sense when I think of it like the IT field.
😮
I appreciate it.
Glad it was helpful!
The days of getting a job without a degree are also dying. You gotta have it all in 2023 and onwards.
Says who? You can have a degree and not have the skills and you won’t get a job it’s a skill based world if you have the skills you’ll find a job for sure
@@Albidon I absolutely agree with the first part because the same applies to professions that require a degree in that field. What I’m saying is that with the growing interest in people gaining the skills they need and filling out the entry-level, we’re getting closer to a time where being in tech will share that barrier to entry that law, medicine, etc has with needing some kind of degree AND the required skills to break in without connections
@@PaladinLeeroy42069 Lol I disagree Google has clearly established what college degrees mean in the real world without the coding skills no skills = no job no matter who you are medical and law is different
I’m not saying college degrees aren’t worth it they are they are an advantage but you can definitely get employed if you process the proper skills
Networking is key
I'm not seeing where the Tableau Data Analyst cert is $250; I see it listed for $1000.
That's strange. What country are you based in?
@@learnwithlukas USA
Maybe that price is for a course and the exam?
i was wondering where i should even start and how i could even get into Undergraduate degrees with relevant experience instead of my A levels as they are not as relevant to the mathematical aspect of Data science as i take social sciences. I do not have a part time job and i am still looking, with a lack of support from the family im finding it really hard to get certified solid qualification for Data Science. Would love some help! im doing this all on my own thanks
Great info!
Glad it was helpful!
Let's say you get these Coursera certificate through a sponsorship like IBM, does that not make you certified?
The best video I've come across - Thank you
Wow, thanks!
Hi, thanks for the video! Great content!
Question/Request: please suggest ways to build a portfolio
Great suggestion! The resume & portfolio package is intented to accomplish that, but I will try to create some free videos as well.
Thank you for making this video. Are you able to share your opinion on the Comptia Data+ Certification? How would you compare it to PowerBI and Tableau Data Analyst Certifications?
Not very familiar with this one but I'll check it out and get back to you, thanks!
In the Comptia site, they tell that these certifications are on the same level. I rlly hope so lol
I have the microsoft power bi cert and i got the AWS cloud practitioner cert yet no interviews. is it bec im 16?
Thank you for this video
Thank you! Good luck with everything!
How do I know If this Data Analytics is good career for me?
At the moment im in a point in my life that i want to go back to the tech field. I used to be a contractor for meta 2 years ago until the tech market crashed and i was let go. I have not been able to find another company who is willing to give me an opportunity to learn. The only thing under my belt is my associates and then my past a technician for a semiconductor company. Currently i am working as TA for a school and its a great job but i really miss the tech field.
As a beginner and having to start over...would Microsoft Power BI Data Analyst Certificate would be good to start or do you recommend something else as a fresh beginner?
How about people learn towards aquiring the actual skills not the certificates??
how can you start a portfolio without the certifications? since you need to understand the material in order to make the projects in your portfolio.
Start with courses!
How good is IBM's data analyst certification?
Needed this
Great insight sir!
However, what would you say about folks who will push back and defend specifically the Google certificate in Coursera that also provides support for job hunting?
I believe they have hundreds of comp's listed in their page that's accessible to those who complete the course.
Coursera certs like the Google one are still very useful. Nothing against them, I actively encourage people to take them!
@@learnwithlukas gotcha!!!! Thank you!!!
@@ignacioa3698 They are useful in the sense it shows initiative for someone wanting to get into the career. With that said, you are going up against hundreds of people using the same platform, applying to the same job within the same company. It will be difficult to be recognized by them. A certificate of completion is different than being a certified specialist as stated in this video. So keep that in mind because people are frustrated at the fact that they are not able to get hired by these companies because they don't stand out or someone is more experienced in what they are marketing about their skills both technical and professional.
Hello, I also completed the Google Data certificate. It's true you have access to other jobs once you complete the certificate. However, that's that. You are not even guaranteed an interview with those job opportunities. So, you need to grind a lot either acquiring more knowledge, learning other skills or building a portfolio. This video was truly an eye-opener for me. It resonated with me a lot.
@Thawne because competition eliminates chances for monopolies to happen. Mid to smaller companies that are able to get a piece of the pie provides more for others in different industries. Instead of going for the white collar silicon valley bs that everyone tries to do, talent can be spent at other companies much more profitable such as the heavy industry. Programmers are wasting their time creating and maintaining apps or any other type of software like for Google. Helping to build a safer car for everyone to use is much more satisfying than some app on your phone. Innovation baby, and capitalism is not perfect but it's better than jobs being like Amazons warehouses. Low skilled job for minimal pay and high risk of injury. Or taking a quiz so you can see what they will pay you but get denied the job.
Hi, Thank for tips! Where can I find some project datasets like the ones you show in the video?
Kaggle is a good site. You can also find lots of free/open source datasets, just search and you'll find something for you :)
Datacamp offering the opportunity to gain a certification by doing 3 tests using real life sinario i don't know if it good enough
Do you recommend I should complete this certificate and the Google Data Analyst Certificate at the same time?
Can you transit from back office 10 yrs operations experience to data analyst through certifications?
Great tips Lukas. You're absolutely right that without experience or a very strong portfolio, the chance of someone landing a gig is near zero especially in this competitive industry from my personal experience. From your perspective, does having a certification make a small difference or a big difference to a person with no pervious experience in the field?
It can make a difference, depending on your current qualifications and the certification
thanks for the infornation
Its not about what you know its about who you know , even if you watch a couple of data analysis tutorials on youtube and somewhat decent understanding if the concept if you know the right people theyll help you get the job
The problem with these types of certification is that the barrier to entry is extremely low. You just need time and a couple of hundred dollars. You are going to find yourself competing with people in low income economies who will undercut you all the time. Certifications on multi-million dollar platforms like Workday or Salesforce are far more valuable because you need a platform to practise on and you can't just buy one. It's a bit chicken and egg, but that's why you earn more money on these.
I would not recommend beginners to persue certifications on these platforms instead of these fundamental certifications, but I do see the point you're making.
Man . I have finished the Google data analytics certificate specialization. I haven't landed an internship in data analytics or data science yet . This video is facts no one says . All the other guys are just sponsored by coursera to recommend overpriced courses that don't have any value in the real market
Any luck yet?
@@deronlester3072 ya I got an internship after I passed the AWS SAA certification. No one gives 2 shits about these Coursera certificates . They are overpriced and have no value .
@@anipacify1163how did you study? Links?
Wow this video is a godsend. Iv no clue where to begin buy i did stumble on yhe google analytics course which i planned on doing and hope that gives me some creds. But you just destroyed that hope. Im thankful though cause now ill look into those two you mentioned. Money is a big issue for me so i cant just drop alot of hundreds of dollars on learning.
Thank you. But don't avoid online courses completely, they have their purpose too!
How about the certification from datacamp? (associate and professional) Are they the same as certificates from IBM and google from coursera? thks
What about Amazon AWS data analytics and quick site
Good too. I'd still go with the ones mentioned
Lucas the content is amazing . One question that would be highly appreciated if you respond. I have studied SQL but i cant proceed with a project , i dont know how/where to start
Can u assist me? Thanks in advance
Thank you! I will see if I can make something or add more resources to the roadmap for SQL projects soon. learnwithlukas.com/roadmap
Is there any certification for R?
So, what's your recommendations for newbie in that particular field?
what's your opinion on comptia data+ wouldn't that be easier since it's somewhat a combo of the certs you displayed?
Video coming on certifications soon!
Some recruiters like certs. Some don’t. Do what you want.
What about Comptia Data+?
I'm planning to book an exam to earn my MATLAB associate certificate
Good luck!
And people said you don’t need a degree for IT
This was soo helpful
Can you please make similar video for data science...like skillset and certifications!!
I'll try!
I appreciate the insight. I’m looking into taking that Google course, and my idea was to get a good looking portfolio afterwards, good thing that was a good line of thought. My next question becomes, what is being a data analyst like hours wise? I am going to school right now for music and I want to pivot into data analytics so I have a good job to support my career choice of music. Would I be expected to work set hours every week or is it like the food business of “you get off when the job is done” ? I would essentially want to have free time outside of work so that way I could hone my skills and not just live at work
You can work set hours, it's not as bad