How to Become a Data Analyst (Updated for 2022)
HTML-код
- Опубликовано: 8 июн 2024
- PRACTICE SQL, AND PYTHON HERE: stratascratch.com/?via=shashank
Download the Roadmap HERE: shashankkalanithi.gumroad.com...
Learn how to become a Data Analyst in 2022 here with FREE Roadmap in PDF, PNG, draw.io format. Let's work hard and achieve our dreams together.
Patreon: / shashankkalanithi
MX Master 3 amzn.to/3sTroBW
LG 35in Curved Monitor: amzn.to/39pPzR3
USB-C Hub: amzn.to/31Ip8Sl
MacBook Pro Retina 16 Inch: amzn.to/2PSwZde
Twitter: / kalamari95
LinkedIn: / shashankkalanithi
00:00 - Introduction
00:42 - DataCamp Callout
02:00 - How to Download Roadmap for FREE
03:00 - Roadmap Caveats
04:18 - Starting Points to Become a Data Analyst
11:28 - What Type of Job do You Want
23:00 - Skills Roadmap to Become a Data Analyst
23:47 - Stage 0: Education, Internships, and Bootcamps
27:40 - Stage 1: Basic Data Skills, BI Tools, and Excel
33:45 - Stage 1.5: Applying to Jobs
38:11 - Stage 2: Your first Hardcore Skill, SQL
41:01 - Stage 3: Outperform other Analysts, Python/R, Statistics, and Leetcode
47:16 - Stage 4: Experienced Analysts: Machine Learning, Project Management, GIT
This video was sponsored by DataCamp
There is a famous quote - "Listening to an Intelligent person is worth reading thousand of books." Mentor like Shashank sir is one of them. This content is a gold. Thank you Shashank sir for all this sincere efforts.
WHO do you think writes books? 🤣🤣🤣
@@davidjukebox but he didnt say its not the intelligent people who write books, he just said listening to them is also as worth as reading thousands of books.🙃
Conufused Computer Science graduate here. I have to appreciate the time and effort you must have put in to make this video. This is absolutely, hands-down an invaluable source for people like me who want to get an idea of the path that one may have to take. I am a recent subscriber and am looking forward to take in your advice and guidance to pursue my ambition to enter this industry.
I'm so happy that you found this helpful! You got this! Just study the relevant skills, practice a little every day and you'll be joining us here in no time! I do a livestream every Thursday at 8 AM pacific time, feel free to drop in then!
Thank you Shashank, the gift that keeps on giving!
you are literaly the reason why im choosing the data analysis career path as a cs student im so lost but your videos are a major help. thank you so much for you effort dude!
Think about what you like doing and go for it. If you like analyzing in order to X (discover truth, etc.), then be a data analyst as we're all doing. If you like designing and creating, stick to the engineering side of CS. If you like research, stick with R&D. Hope that helps.
@@Osteomorphis thanks Matt
@@Osteomorphis could you please elaborate "analyzing in order to X"
@@abcdabcd8605 I am referring to each of our overall purpose in analyzing. We could analyze data to discover the truth, help others extract information to help their jobs, analyze data to make the world better or fairer for others, or extract data to help others make a decision.
@@Osteomorphis i have confuse between R & Python should i learn 1st can you help me....?
This is amazing, thank you for providing such a thorough resource to aspiring data scientists and analysts!
I have bachelor in industrial engineering and landed a Tableau internship on my last year of studies. I didn't have any prior knowledge on working with data and kinda just needed the internship to graduate. The company was also new with Tableau and I had to learn almost everything by myself. Your videos have taught me enormous amount of important stuff and you've given me the spark to actually chase this career. Keep up the good work!
had a similar experience here at Brazil. Graduating in industrial engineering, got an internship on marketing which used a lot of PowerBI.
Now, graduated, I'm doing quite a lot of interviews. Seems like this is hot stuff for business
@@vitorpereira5461 hey guys! how would you rate your industrial engineering career? i am about to start my first year!
This is well thought out Shashank, perfectly put together, keep doing what you do for the community 👌🏻
This is one of the most helpful videos in the Data space that I have found so far. Big W
Thank you so much for sharing these wonderful insights on the paths to follow.
Shashank, you are the best mentor I found! Thank you so much for creating these awesome and comprehensive videos! Please keep doing what you love! Thank you so so much!
Great resource!!! with detailed overview of Data analysis road map. Thanks for all the work you put in to make this great video.
Thank you so much for sharing this. This is longest & the BEST video I've seen on how to become a data analyst. I appreciate how much time and effort you put into making this video. Such a gold mine of information. Thanks again!
This is so increadibly helpful! Thank you so so much❤
This is great. I can't speak to trying to break into the field without a degree, but my degree was also somewhat unrelated and I was able to break into the data science field after getting some overlapping *good* relevant experience in a previous role. Totally agree with working on the technical skills in Stages 2-3 (and maybe 4, depends on your company and how they operate). These will set you apart and allow you to gain access to more interesting projects, but maybe more importantly, will *save you time* and allow you to work more efficiently. Lastly, I think it helps to find a reliable and trustworthy resource during the interviewing stage to get constructive feedback from. Sometimes if you aren't hearing anything from companies, it's just a streak of bad luck - don't let that get you down. But if something is inherently wrong with the way you are communicating your skills to potential employers, you *need* to fix that or you are severely handicapping yourself in your job search.
Outstanding job SK! Thank you!!
Oh man, this is so well-thought out. Thanks Shashank!
Thank you. This makes the journey less blurry.
Big respect for putting this all together
Awesome content. Very useful and thanks for having the time to contribute!
No BS invaluable informative video! Thanks for all you do
I'm a chemistry major as well and want to get into the data analytics field. Thank you for making the video and making this journey make sense.
You are doing an amazing Job mannn, looking forward for more learning videos on your channel
Yeaaaa you're the GOAT of actionable Career Plans. Outstanding Video.
Applied Mathematics major here. Just wanna say you are a god send man! I'm so fortunate to live in a time where you,Alex,Luke and other data people can bestow this valuable information to us. Thank you for the upload!
Update on your DA skills?
can you reply to this with their YT channels too? I'd like to follow them too
Youre the goat dude. Your videos are so helpful.
Awesome job done Shashank!
Awesome Video! Keep it up Shashank
This is great, had been working as sales for 4 year but seems i stuck in this field and I need a new challege and now I start to learn data analyst on datacamp, hopefully will find the better job soon, 谢谢你
I went out of my way to log-in to comment. Thank you so much for creating this video. I love how detailed you got, I appreciate you sharing your own journey and I love that you created multiple starting points for this road. As an active Data Analyst job seeker myself, I found this video VERY insightful.
mannnnnn! It was worth watching. well I never felt more interested than this 50mins video which unfolds the route which no other youtubers had said n a short and crispy way. Thankkk u and I'm a chemist who desperately lookin forward to work n tech. keep spreading ur knowledge :)
you just earned another subscriber sir! you're a legend, thank you so much.
Thank you so much for creating this amazing video. This has helped me by a million times faster to understand how to go about this stream.
This is the best video on this subject I have seen. So much so that it made me subscribe to your channel. Thank you for putting in so much work and I look forward to future videos.
thanks a lot bro...wont let your hard work get wasted
Just finished as a Computer Science graduate, thank you for the video! Now looking for a job and somehow stumbled into your video. I just want to add that i think doing some online bootcamps or courses is also good because atleast you can get some understanding about the concept. After that you can go practice, practice, practice, and apply. once again, thanks for many content that you provide to us!
Thank you so much for the video. I just finished an intro to stats college course and am interested in data with the company I already am employed with. You are amazing, you have answered a lot of questions I probably had no idea I would eventually have
Hey Shashank, watching this video I totally admire your dedication. This is really awesome guidance.
Thanks for the video, well done! I've been exploring the idea of switching out of my engineering job to a data analytics job for the last few months. What I appreciate about this video is the detailed and logical step-by-step approach to learning. I have friends in the space that have suggested learning SQL, Python, Tableau, R, etc but with no real logical path and now I feel like I have a good priority to follow and work through!
I don't see a datacamp referral link though. Would love to give you a referral before i sign up!
Unlock new career opportunities and become data fluent today! Use my link bit.ly/ShashankKalanithi2DCFeb22 and check out the first chapter of any DataCamp course for FREE!
You go the right to work incorrect. Right-to-work means you can work for a unionized employer without joining the union. The other category is at-will employment. In both categories an employer can fire you for any reason at anytime or you can break the employment agreement at anytime.
Gm very nice
Dude thank you for this. I'm currently in sales and I freakin haaaate it, like I haven't been working for months because every sales job posting description makes me absolutely cringe. I spoke with a data scientist at a bar and was like "hmm.....sounds muuuuch better". And now I'm at this video. Cheers!
Yay. First!! Awesome content man. Appreciate your work!
thank you so much for this! i currently work at state farm as a claims adjuster and they have data analytic positions open all the time! ill deff try to look internally at my job!
Thank you so much for doing this, I hope that someday even I can share knowledge like you do now.
appreciate this video. very helpful roadmap!
Just to clarify that R is NOT a general purpose language. You can't write a Game or Software in R but you can in Python.R is considered a domain-specific language (DSL), meaning its functions and use are designed for a specific area of use or domain
Hi Shashank. 5ish months ago this video helped me to 'take the jump' to move into a career within data analytics. Since then, your video and resources have helped me tremendously, where now I can thankfully share, I've landed my first job as a data analyst. Thank you very much, please keep doing what you are doing!
That's awesome! Super proud of you! Can I ask what drove you to a career in data and how much your new job is compensating you?? Congratulations!
@@eddiemunoz9018 thank you very much. I'm in Australia and compensation is around 100k.
@@AK-oc4eb hi did u had any previous experience related to data science or this was your first data analyst job ?
Omg i cant belive i just foud you today. Ive looking information (like real information) about how to become a data analyst and all your content is just perfect. Thank you so much for sharing !
Here is a big thanks from Brazil! you are amazing!
Thank you! You are amazing man
I just want to thank you brother I appreciate the work you do to teach others God bless you 👍
It’s so cool that he gives you just everything in one shot. I already checked 3 times if it was on x1.5 or so 😂 thank you man!!
im using data camp and its definitley worth it. ive been using it for 2 months, especially when youre out and have to wait you can do the sections in the mobile app
bro! you are a god for this. Thank you
I have been wanting to make a career change into data analyst from financial advisory for a while now. Your videos helped me to take my first step to learn and now I'm ready to commit to some self-learning with Datacamp and other learning tools (primarily your channel). I will (hopefully) comment on my success in one of your future videos. Wish me luck and thank you again, Shashank.
Hey nice mate. Hows the learning going
@@haydenwilsonx Very well, thanks! Still ways to go, but glad I've started. I'm hoping to find a job in the field within the year!
Hello Shashank, i am here to thank you man. Always i feel lost in the path for data analysit i just have to re-watch this video or look at Roadmap. Thank you a lot.
hello from Malaysia. thanks for making this video!
Poli Sci undergrad and Master's in Homeland Security. Domain knowledge and understanding led me to learning SQL and Tableau last year. Never thought I would be doing analytics but data is an incredible currency that needs brokers that can work it.
Thank you so much for this ☺️
thanks so much found it really helpful
Gracias Shashank saludos desde Uruguay
Thank you so much for a very detailed instruction
You are so welcome! Thank you so much for watching ngan
Thank you thank you THANK YOU, a lot of what has been said about the grind of looking for a job, I'm living in that hell now, got a long selection process, got refused after a Tableau viz, logical mathematical test even arrived to the final interview and... nothing... That really from one side "killed me" from the other side I kind of woke up and started to learn and study more, trying to get rid of those skill gaps, and knowing that I'm not the only one going through this grind even with a statistics degree is a breath of fresh air!
Also AGAIN THANK YOU for the DataCamp info and theire app, just finished a small course released by UDEMY about SQL so that will keep the skills learnt sharp! 🙏🏻🙏🏻
you are a fantastic presenter, will be watching more!
Thanks so much Alex!
Thanks man! You literally have thousand $ worth of information here.
Thank u for making these video! It was ultra helpful!!! I have an interview next week wish me luck! I will be binging on your bootcamps all week lol! 🤓😅. You're doing great work and really giving helpful info. Blessing to u Shashank🙏🏾
wow I have been searching and searching now I am in right place.
I’m in my third year on computer science. I have a year and half more to completed. I actually working on assistant project manager for roadway signs. Now I will like to become a data analytics. Thank you for do this videos.
Great work bro
Hey Shashank, great video, keep up the good work man. I was not sure where to start and how to implement what I learned but you really showed and explained with great details. Just wondering how much can someone earn (estimated) from a project such as the one you worked on in this video?
this is great ty im 13 and have been thinking about this ik i still have time but i really thought about this today and it was between coding and data analyst have a good day
I am looking to switch into this career from clinical healthcare and I have been looking for more information on what I need to do to actually be equipped for this job. I’m already in the google certificate course and I need this video. Finally someone with actual in depth information and resources on what I need to do. THANK YOU!!!
Hey, just wanted to get an update on whether you were able to break into the data analysis field or not.
I just started google data analyst certification and have no idea where to go after that but you give me a lot of hope and courage.
Thanks alot
Of course! I’m glad this video was useful for you!
Economics and finance student here, somehow ended up in the data analysis section of an investment company during my intership, Its quite daunting lol
Just about to finish a master's in chemistry (in Canada) and this was great to see. Was worried about swapping field but I feel less worried now haha
This is great!!!
dude i have bachelor degree in chemical engineering and starting learn data analyst things like python, sql etc. i glad found your channel 👍👍
i'm a business student i hope this year can become data analyst. Thanks for this roadmap
You are definitely not a youtuber. You are real bro. Look how you are holding that mic. It reminds me of serious stuff. The content is comprehensive, unique and very helpful. It's not something like you need to do more research because you were tricked to feeling that you got comprehensive stuff. Well done bro. Well done...
Thank you!
Iam from non it background but I want to do data analytics, this video really helps me,thank you sir for this video.❤
In the US, its difficult to get a full time offer. Most companies prefer to hire on contract and then maybe after couple of years convert to full time if they have a position available and the budget or if you come across as a indispensable asset. The only other ways for secure full time is through personal contacts or your own business.
tableau & power Bi | allows to punch way above your weight | note for later.
if you can, try & transition within your current company.
microsoft excel | learn mid level | generally not used for large amount of data | ad hoc analysis
Great video I'm thinking of how I can utilize this for Real Estate
Funny, I'm a BI and I had the basics in Excel /VBA but learnt Python before SQL (which made it super easy to pick up!)
I'm lucky to have found your channel as it's helping me a lot through my transition from Product Manager to Data Analyst, a career I found way more pleasant and satisfactory to follow.
Great content, objective and straightforward; keep up the good work!
I am considering the same transition! I found myself liking the data analysis aspect of being a PM more than the other work
Man i wish i saw u 2 years a go when starting this journey i’v been learning programming (swift, python, sql) in that order in the last 2 years i would say 1 year swift 7 months python and 5 months sql just started google data analytics certificate feeling hopeful after watching ur video
Wasn't even looking but found your channel. Awesome content! I am making more in general tech career videos. I can link people to your Data related vids if that's cool.
100% appreciate the help!
Hey Shashank, great video man! One question, the Gumroad link says it is unavailable in my area. I live in Africa, any way you could recommend by-passing this issue?
Notes
9:53 Make the case that u where always analytic person, like if u work a job u can make Exel sheet to estimate time and resource. And always you look at all the variables and data before taking decition like u always examine even in your believes.
Will you update this roadmap to include data engineer route? Congratulations on your new role.
This is great
I’m one of the people that have NOT obtained a degree. I’m going back to college at the age of 40. My major is Physics with a minor in computer science. I want to become a data Analyst no only to change careers but because the skills I’ll learn are applicable to what Physicist are doing with Data. I’m currently living paycheck to paycheck so a change in careers is badly needed.
I have Master's degree in Political science... how can i use it as my Advantage during interviews and also in projects ???
What about excel’s power pivot and power query? I perform aggregations, joins, grouping, merging disjointed data from multiple sources, and other data cleansing, etc using power query and powerful pivots, visualizations, and dashboards using power pivot. I never took the time to learn python and pandas because it seems to accomplish the same things at a high level. However, I notice most companies ask for experience in pandas, python, power bi, etc. Is it worth it to learn just for this or is there an advantage that I am missing? Thanks for the video. Very informative!!
Hi Shashank, I am a graduate with a bio degree. Is it still possible for me to try to pursuit a career as a data analyst?
You don't know anyone without a college degree. Wow. What a world you've created for yourself. My mind is blown.
Watching this video on 0.0001x for my understanding
Thanks a trillion Shashank I want to start learning to become data analyst cause I’m belong to category four and I’m starting from zero to prove myself I do it. Although I have a degree and management degree, they have been pretty noncontributory to my life...
same tbh. been looking for an analyst job with a management degree. I was a a fundraising course short from having a BIT degree.
Is this roadmap applicable to Computer Science graduates outside the Unites States, especially India?
Hey Shashank, considering a career in data analytics but would like to work remotely since I come from a country outside the US. Wondering how I should go about this.