Entry vs Mid vs Senior Level Data Analyst | Alex The Analyst Show | Episode 15
ฝัง
- เผยแพร่เมื่อ 23 ก.ค. 2024
- Today we look at the differences between the different levels of being a data analyst.
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
Google Data Analyst Certification: coursera.pxf.io/5bBd62
Data Analysis with Python - coursera.pxf.io/BXY3Wy
IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
Tableau Data Visualization - coursera.pxf.io/MXYqaN
Udemy Courses:
Python for Data Analysis and Visualization- bit.ly/3hhX4LX
Statistics for Data Science - bit.ly/37jqDbq
SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
SUPPORT MY CHANNEL - PATREON
Patreon Page - / alextheanalyst
Every dollar donated is put back into my channel to make my videos even better. Thank you all so much for your support!
____________________________________________
Websites:
GitHub: github.com/AlexTheAnalyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for
![[TH] 2024 PMWC x EWC Group Stage Day 3 | PUBG MOBILE WORLD CUP x ESPORTS WORLD CUP](http://i.ytimg.com/vi/VnOqutfqWqU/mqdefault.jpg)
What great timing. I'm sure most people like myself are in their annual review period wherever they work. This helps me know what I should be looking to add as my goals for 2021. Learning celery and python are my top priority.
:D do it!
This is very helpful as I’m planning what skills I need to improve on and gain in order to move up. Thanks for another great vid!
That’s great! Always good to plan ahead! So glad to hear it’s helpful 😁
The one thumbs down is someone that couldn't hack it as a data analyst and got demoted to data entry. Great vid Alex! You da man!
....or they hate celery.
Hahaha must be! :D
Really - what was the problem ? was that a colleague. I suppose at least they didn’t get rid
Man, I love your channel. Great advice, and very easy to listen to.
Thank you, this was really helpful! Sadly all of the entry level data analyst jobs I’ve been seeing having high expectations and require a strong technical background
I hate seeing that - there are definitely some good ones out there, but apparently are not as common as the ones with unrealistic expectations.
As someone with a PhD in Political Science + 3 postdocs and making the leap from academia to data analysis, I sincerely thank you for your invaluable advice!
You're most welcome! Thanks for watching! :D
Hey, Milos I know I’m a year late, but I’m also making the switch from academia (PhD in neuroscience) to data analytics. How has your journey been?
@@fernandocastillo4158 Hey, I successfully transitioned to the Data Analyst role at a big company and after 1.5 years I'm moving to a product owner role
@@milos-makes-maps that's great! Congratulations on your transition and success. It's inspiring to see transitions I can relate to.
Hi Alex! It's been a while since I found your TH-cam channel and it has helped me with defining what I really would like to do. I am at the doorstep of the switch to becoming data analyst, and I really believe that on top of the technical skills, it really is the mindset and willingness to learn what it takes to progress in this field. Thank you for the informative videos, and for making me laugh in the middle of the night, listening to your complaints about celery. Try to juice it, filter, and have a shot in the morning. It does you good. ;) Cheers, Katalin
Hey there, enjoying the content so keep it up! Biggest thing I would add is you have only focused on the technical skills here and not the other aspects that come into data analytics. From a technical standpoint I personally do not think there is much of a difference between Mid level and Senior level, slight improvements yes but the biggest technical difference is between junior and mid level.
However from a problem solving there is a big difference. e.g. junior analyst you produce the data which is ask of you, mid level you think more about what they are asking and find ways to add additional value or highlight opportunities you have notices. Senior level you are comfortable going back to a CEO or head of department level figure and asking is this really what you want because half the time they are not asking the question they really want solved.
Final thing I would add is you skill of communicating the data, you may be able to produce the most accurate model but if you cannot communicate the findings it will likely be forgotten.
That's some good additions for sure! Thanks for adding you thoughts!
Just randomly found this on my home page. Thanks for the advice. I'm a Junior DA with a masters in engineering and was wondering about what steps I need to take to make sure I'm ready for a mid-level role
A bit afraid since I jumped from Jr. to Sr. in a job switch, but they understand needing to ramp up the skillsets and they have faith in me. Granted this is going from a 300 person company to an 80 person one, so perhaps role inflation was inevitable. Great AMA!
Hello there Alex ! Thanks for the great content, I personally enjoy your podcasts with a cup of tea before going to bed. :)
I’am on my senior year for my master degree in finance and I’ve been learning to code for a couple of months now. I’ve decided to join a bootcamp next summer so I will really appreciate if you could make an episode about them ( boot camps in Europe) take a look through the syllabus give you opinion and give maybe advice on what would you recommend us to study by our own to complement this formations. Some bootcamps I’m considering here in Europe are: code works, iron hack, le wagon.
Thanks a lot for taking the time to read me.
Greedings from Your fan no.1 in France ! 😊
Haha that's awesome! Super glad to be part of your day :D and that's awesome! I hope that it's extremely beneficial! I will have to look into that - thanks for the suggestion.
You just topped it with the most useful video yet!
looking forward to hear more from you as you get to senior level
Same! Hopefully coming soon :)
Dude, Alex. Celery is awesome.. it adds a depth to the stock that you’re putting it in.
In better news, thank you for this! It helped me evaluate what my skill level sits at and it’s helping me locate jobs that I’ve got a great shot at getting!
I have my doubts, but my wife says the same thing haha and you're very welcome! Thanks for watching!
Hey Alex. Just found your channel a few days ago. Thanks for explaining data analysis and videos pertaining to beginners. Ill keep surfing your videos. No idea why celery is a key word though.
I transitioned to a data analytics role in my company. I'm 9 months into a 1 year rotation through 4 departments.
A few things come to mind:
1. Somewhere in that middle to senior level one probably needs to think about getting some statistics skills, maybe even could be the right masters program for this field.
2. I am concerned that a lot of the analytics roles that are so plentiful will be eliminated by the development of machine learning and the more advanced technological development of the programs such as BI and Tableau. The field may end up over the next few years becoming a hybrid of data analytics, data science, data engineering.
4. I think a lot of folks also should consider advancing in a particular domain after they reach mid level analytics/data analysis. Leaders in marketing, sales, risk ecetra all will be folks with these base data skills in the future.
Hi Alex! can you include your episodes in a podcast format as well as videos? Thanks! Love your channel!
Great video Alex :) one day I'll be as good as you are at this!
Hi my name is Jason oluwaseyifunmi from Nigeria
Your channel has opened my eyes to some skills...
I am in my year 3 in the university studying computer science..
I started learning software From year 1,
I can boldly say I am a webs designer, python Lover..(which I Start learning from year one)
Now I have started a career in data analyst.
Which I'm really enjoying...
Thanks slot for This great channel
I believe before I graduate from University I will be very good
At using python,sql,tableu and Excel...
Celery! Let's go!!! Thanks Alex!
This is really helpful!
I really want to know more about the job of
entry level data analyst and awesome video
At 30k subscribers you'll have to eat a whole bag of celery. You can't escape this fate, Alex.
I will delete my channel before I do that....
@@AlexTheAnalyst 😂🤣😂
Lol
I wouldn't recommend that unless you already eat a lot of celery. It can cause a numbing sensation in your mouth because of the eugenol.
OMG! many thanks for everything you did and doing for us. I never think that my last name is so hard and i enjoyed how you pronounce it, i repeated many times, but i think it pronounce like "bushusha". I hope you got increased in your celery.
Hahaha now I know for future questions featured on the show :D Thanks for watching and being a great addition to the channel!
My daughter loves Celery! How are you doing man ! Thanks for helping me!!
Lol I just paused what I was doing to check why my phone went silent.. I will get used to you pausing.. new to the channel loving your content.. currently in an IT industry with an engineering diploma. Just enrolled in a Business Analyst course hoping to make a career switch..
Great content!
As someone who has a Masters degree in Analytics and 4 years of work experience as a Data Analyst in total (including 2 years at the current company), I have now received an offer from another team in my current organization for an opportunity to handle supply chain optimization. The title being offered is Supply Chain Engineer.
Should I consider this ? Will this be a good opportunity for my career?
As mentioned earlier I have completed 2 years at the company and I also think I should start asking for a promotion to my current team for a Senior Data Analyst. Your thoughts on that ?
Hi Alex, now that you’ve gone over the Google Certificate, have you changed your views on certificates? Especially for people who do not have experience and/or a Bachelor’s Degree.
Alex, you're great! Very informative content. I'm currently an entry level Bus Ops Analyst for a fortune 500 and am dealing with big data and automating reports using Tableau Prep. I've come to like this a lot and am thinking of either making a career change to Data Analyst or trying to grow quicker within my role by learning skills like Python. What are your thoughts?
I think that's a great idea! Python is a great way to open yourself up to higher paying opportunities.
I have a masters degree in physics with 5+ years relevant work experience. I know python and various ml libraries. Recently started with sql and are learning subqueries right now. Just started working as a data analyst at a large company. Should I rather look for data scientist roles or is it beneficial getting some experience of working as a data analyst first?
Can you start posting videos of how Phyton is used on a practical day to day basis as a data anaylst? I've started learning it (to try and achieve Mid Level status) but apart from the basics, its hard to narrow down where to start for a data anaylst
Pandas package is practical for data cleaning, analysis and matplotlip for creating visuals.
for the next 3 years you'll become the inspiration for data enthusiast around the world
Thanks Alex!!! You´ll by a Senior celery fan soon :)
😂
It seams so weird, cuz here in Russia they require you already to have Bachelors or to be in the process of obtaining one.
Also you should already know one of the languages Python or R and obligatory SQL ( in advanced queries and most probably some window functions, yet window functionality are not required solid) and other then that they also check in on your statistics knowledge!
And it is all for Junior positions, I also had a case study on one round of the interview
Just saw this video Alex 😅 I have to disagree about celery. Try it baked until it gets a little bit brown. Add spices and Humus. You will love it ;)
Thank you Alex, good info. Have a question about the senior level Data analyst position. Just curious, if we can get into senior Data analyst position, with just 20 yrs of IT experience and bachelors degree 🙂
Thanks you so much. Its really helpful, am stil inl learning process. How I wish I can have you as my mentor
Celery can be a very good weapon, my ex used it alot, but I prefer to eat it raw. Thanks for sharing, Alex.
😆
ugh celery ants on a log 😧 don’t understand the appeal!
Thanks for this Alex! So helpful to understand analytics beyond the entry level roles
I need that validation about the ants on a log. Thank you haha and you're very welcome! Thanks for watching!
Do I need a Bachelors or Master's Degree to get an entry level Junior Analyst potition? Or is a Google Professional Certificate in Data Analytics enough?
Hey, Alex. Have been binging on some of your content for a while now. And largely, it has been quite informative - even the 'A Day in the Life Of' video. For this one, you asserted that an entry-level Data Analyst role might not require R or Python. I have been looking at job-descriptions in Canada for Data Analyst roles for a while now and I have to say - I have not seen any profiles that do not explicitly need Python and R, along with SQL, Tableau/Power BI, and MS Excel.
Can you throw some more light on this? One caveat is that most of the roles I have seen are related to finance. Is the inconsistency because of the domain?
That's a great question. There are certain domains that do require different skills more often. I would say that finance is one that is heavily math based and so I'm not surprised that you're seeing a lot of R and Python. Other fields like Healthcare, eCommerce, Advertising, and Marketing may not have the same results.
Inspired by Alex & few other TH-cams, I landed an analyst position last month with SQL, intermediate PBI, and very basic Python knowledge. My team expects me to help them with Python migrating local DB to Azure which I completely have no idea about. My English is not bad but during the team meeting, I mostly remain silent and google the keywords and acronyms they use. I haven't been assigned any complex project yet but I spend almost 4-6 hours outside of my work schedule on learning and revising resources and I am so far until now very passionate about it. But what I am really worried about is the possible burnout. @Alex would you mind sharing your thoughts on it, please?
Dude, celery is an underrated veggie. It doesn't have to be the a favorite veggie but it's solid and can be a filler. It's really good if you put it in a smoothie and mix with something naturally sweet like apples and bananas.
And yes, it's only segment I forward to when watching your videos. All this talk about entry level and senior level data analyst doesn't sound fun. 😁😂
Seriously thanks for another informal video about the different levels of a data analyst. Much appreciated!!
Hey, to each his own! :D and you're very welcome - thanks for watching!
What are your thoughts on learning Excel VBA?
Should I bother learning Python or R instead first?
I appreciate your celery story!
VBA is fine to learn, but I don't think it's necessary.
I personally like Python more than R - I've used both, but started with Python and know it much better.
@@AlexTheAnalyst - in Excel, what is your opinion on what the key skills are to know: 1) Power Query, 2) Pivot Tables, 3) Excel Charts, 4) Excel Functions: Sort, Filter, SUMIF, TEXT formulas (LEFT, RIGHT, LEN, SUBSTITUTE etc, IF formulas)?
Celery is necessary! What else would I eat with my wings ? Every week I watch these I wonder what the larger play is with this channel .. extra source of income? Future main source of income ? Career boost by becoming a visible authority on the subject matter ? Benevolence? Some combination of the above ? You don't have to answer lol but that question has been gnawing at me
Gotta get those carrots man! Carrots > Celery for wings. And my plan is to keep growing the channel. I mostly do it for a hobby, but there is the side benefit of potentially a career boost? And yes to the extra source of income. Definitely doesn't hurt!
Great video Alex. Celery is okay in stuffing. That's the only time I eat it is probably at Thanksgiving. BTW, are you planning to enroll in a Master's program in an online program or a traditional brick and mortar school?
Agreed! :D And I think online due to my family/work life right now
I know this is two years old now, but if I don't have any prior experience, or technical bachelors or masters education, would you still advise avoiding putting a coursera certificate on my resume? I only have about 14 years experience as a production supervisor.
I am entering my 4th year towards attaining my bachelor degree in data analytics where i am learning all these program tools you mentioned ( Python, R, SQL, Tableau.) Do you think I could possibly jump into a mid level role? Id love some feedback on what I can do beforehand to help me out. Thanks in advance.
It's definitely possible, but just depends on the company and how well you know those skills out of college.
You need celery for concurrent task programming in Django. So it has that going for it I guess…
You also don’t have to eat it then, so that’s a win!
Yes, celery is great in a Bloody Mary but while I would agree about not putting on free or paid certified or courseware from online classes but what about 'Postgraduate certificate programs' from universities?
Great video, but is there a time window of moving through those positions?
Normally it is around 0-2 year for Junior, 2-5/7 years for mid and 7+ for senior. Just averages.
Hey Alex, How does job title matter. Will having a title like Sales Analyst instead of data analyst affect my chances at a mid level data analyst job even if my responsibilities and tools used are the same as a data analyst. I spend a majority of my time in SQL server, Tableau, Excel, occasionally Python.
I don’t think it will be a big hinderance as long as you’re able to describe your job in your resume well and talk about it well in your interview.
I'm listening to your shows while working so, celery 😁
Slurp the coffee 😂 so they know you’re still there. Jk good info on this video thank you 🙏🏾
Watched 10+ vdos of yours today. Let’s Cheerlery!
You gotta pump those numbers up my friend :)
Hey Alex. Your contant is really helpful. Thank You!
I am working as a Lead Analyst with FP&A CoE, 5 years of progressive experience (started as an analyst). I have a bachelors and will have an ACCA qualification soon. I have advanced skills in Excel, really good hold on Oracle smartview and SAP. Have basically worked a lot on data. A pro with reconciliations. I am a super user for Pyramid Analytics 2020 (pretty similar to Power BI- is that good?). I am also at an intermediate level on my training in Excel VBA. Have just started learning Python as well. I work a lot on analysis and visualization of data. What more would you suggest? And what level would I be if I move to Data Analysis?
Thank You in advance.
A lot of great stuff there! Looks like you have some great experience! I would recommend learning some SQL to query data in databases. I would also consider learning a cloud platform. I think that would really round out your skills set. I think you would be at a mid-level tier.
@@AlexTheAnalyst Thank You very much. I shall work on that. Your videos always help. ☺️
Hey Alex great content a usual!
Im currently studying to obtain a masters degree in data science, and i work at the same time as a financial controller. I want to become a data engineer but i dont how i can land a data engineer job as i wont have any experience at this job? Wwyd?
I would get some certifications for data engineering - they’re more important for that role than a data analyst. I would also build some pipelines and portfolio projects.
Haha that just happened to me. I was listening on my airpods and it went quiet so i checked the phone. Lol
Now this is good content
Thanks
Will an MBA with a specialization in data analytics help or just a related MSc ?
That definitely would help - especially if you’re wanting to go into management eventually. I’ve looked into that myself.
I have a master's degree in Data Science and worked as a student in a company/research for 2.5 years. Of course, jobs were Data Science related. I'd say I'm on an upper mid level. What do you think?
Im currently working on my masters in Data Analytics at WGU. Its a competency based online program. Do you think a masters from a program like this is less favorable or less respected than a traditional masters program? Thanks alex!
I think it's great! I think it will be looked at more favorably than those with a Bachelors and that's the vast majority of people. So keep going :)
Does it matter what field your masters degree is in or is it just more important that you have a masters?
It does. If you have a masters in education and go into teaching you are going to have a different story than someone who has a masters in Computer Science or Analytics. Those with a relevant degree have the opportunity to start in mid-level roles, but those with non-relevant degrees probably will not.
@@AlexTheAnalyst Would you consider an MBA with an emphasis in Information Technology relevant to DA?
Just graduated from university studied Information Technology. I want to start to be data analyst.
What you suggest is better to learn first as visualization tool?? Tablue or power bi or anything else???
Congratulations! And I would personally start with Tableau. I think it's a bit more user friendly and easier to pick up.
Yes, also, tabelau is used most by major companies. The downside to Power BI is that it is only compatible with windows. I think there's a way to have it work with Mac, but most companies use tableau and python as the two standard programming and visual tool systems :)
"Some people never watch me, I could be doing random things with my hands and they would never know"
I was making progress in the google cert im sorry!!! made me tab over XD
Lol :D
What are titles for a mid level ?
I'm a senior but my company doesn't use any R or Python, I do know Python but not comfortable with it because my word doesn't require it, it could be a roadblock when I think of moving to other firm :-?
As the number 5 like to this video, I have a burning question. What is the word on the Google Analytics Cert!?! They were saying it would be released end of the year and we are getting darn close. Do you have any updates because I am over here pacing and stress eating waiting for this thing to go live. The struggle is real!! Any info would be great! Also, do you know if there is an early sign up for it or anything like that? I am super down to collab on this and keep you up to date with the process when I take the course. Cheers, keep killing it! 💪🏽🐂
I just got word they postponed it to March.... I’ll make an update on my channel today about it so everyone knows! I’m super bummed about it - We have been waiting months already lol
@@AlexTheAnalyst ughghgh major bummer. Thanks for keeping us in the loop! Back to Python and SQL.
celery is nice with fresh mayo and carrot!!
Arent Entry Level and Junior not the same and are two different things?? Entry Level is usually 0 years experience straight out of college and Junior is 1 - 2 years experience.
Would a General MBA work for the Senior Job?
Hey, Alex.
Great content as usual.
I have a very big disadvantage compare to other candidates, which is I only have an associate degree from a community college.
This is one thing that scared me the most.
Cause almost 100 percent of jobs require at least a bachelor's degree.
Can you share your thought about it?
Thank you.
Unfortunately, I would agree that you’re at a disadvantage. Since most require a bachelors they will prioritize those people over you for the most part. Having a personal connection who can get you an internship or an in with a company is a really good bet. It’ll allow you to get some experience which will go a long way. It doesn’t mean there aren’t any opportunities though! There are jobs out there that will hire you still!
@@AlexTheAnalyst Thank you so much for your suggestions.
Have a great night.
@@chasehuang3061HEY!
DID YOU GOT INTO THE ROLE? IF SO ANY THING YOU LIKE TO SHARE IT'LL HELP.
Celery sticks are a great light palate cleanser after slamming some hot wings
Carrots > Celery that’s a fact.
Hi Sir , is this video still applicable today? or should I learn python or r as a Junior data analyst?
I think it's still applicable - although it doesn't hurt at all to learn one of those today!
celery
I have a BS in Finance and Accounting, my MBA, and one year experience as a financial analyst (only use SAP and Excel, not SQL and Python). I'm trying to get really good at SQL at home and try for a mid-level role. Possible?
Hope your day is going well!
Absolutely! With your MBA and experience as a financial analyst you should be golden if you can get Some of those hard skills under your belt!
@@AlexTheAnalyst Wow, thanks! I wish you well in your move to senior data analyst and beyond!
SQL is a great database tool. However, the role you will be asked of with an MBA is going to demand far more skills and knowledge of just knowing and understanding SQL if you want to get into data science. Also, be careful, SQL has a very steep learning curve because it requires coding as well. Take your time and really invest in understanding these programming tools and how they would apply to real life scenarios. That's the main key, is to understand what your manager is asking of you ( in terms of data) and how you can not only extract that information and build a data visual to show the results, but also being able to explain it to stake holders in a simple understandable manner. Good luck in your journey. It's a fun field, yet challenging field.
I m from india .. really loves your such advice ... Please suggest me that I have to join an institution or any online course for the data analyst course
Either are great options, just depends on where you are and how fast you want to become an analyst
@@AlexTheAnalyst thanks sir❤️ I want you to my mentor if possible ... Or add me in that groups where you share your tips
But Alex, I thought you were recommending the Coursera certificates? Now you have mixed opinions on them? :(
Hi Alex, I am following your fantastic videos. Thank you for them. I have some questions, but prefer to ask them by email or something like that, we can do that? Thank you
Sure thing -- you can email me at AlexTheAnalyst95@gmail.com
@@AlexTheAnalyst Thank you Alex, I will reach you out
Celery in orange juice tastes nothing but it makes a nice sound in the juicer.
Haha can't argue with you on that one!
I actually had to google what celery even is :D
:D
It’s so funny to hear that u argued with ur wife abt celery😂😂😂😂
It's a weekly argument... I will not stop fighting for justice!
LOL
"Ugh, celery man." 🤣🤣
We've all said it!
Haha just had the experience of thinking the video had been cut off cause you were drinking your coffee 😂
I started to watch on the end. There's coffee talk. There's vegetable word (celery). I'm confused Alex.
Haha welcome to the club - I'm confused all the time
I'm with you that celery doesn't have much flavor to it (it's basically crunchy water), but a few sticks after some super spicy wings can't be beaten!
I really think that this topic is one that a TON of people were looking for clarity on. Thanks for making another killer video!
Haha I prefer carrots :D glad it was helpful!
I currently work as a Sr. Data Analyst and I don’t have my Masters. Not interested in going to get it either lol.
👏👏👏
Here's a Celery joke -- I'm waiting for my first Data Analyst Celery soon to come
What kind of salary range would you expect when you reach the senior level analyst?
Differs from area to area, but probably around 80-110k - somewhere in that range.
@@AlexTheAnalyst Thank you! 🙏
Hello alex, i want to apply a job as data analyst but i could not tell the level. Can i share with the description job to your email??
You should share it in our discord channel - you can join it on my channels homepage on the banner. We have about 400+ data analysts on there and we can definitely help :)
I already signed into your discord. But i don't know to put my question on your discord
@@AlexTheAnalyst I am looking to start the data analyst google certificate program. Would I need to be fully certified to join the discord chat or is that a resource I could join now to help me through?
What is your discord channel?
I hate celery as well, but not to your extent. I can eat it. How about a celery-radish ice cream?
That's blasphemy... lol :)
Selery is ❤because it sounds like SALARY to me. It makes me boost my skills and dedication when i hear it on 😂✌️
Is there a reason why you didn’t mention entry level?
Junior and entry level are the same. Those jobs will have the same job descriptions and pay, but some companies call them entry level and some call them junior.
@@AlexTheAnalyst thank you!
Junior sounds better than entry level
i thought the video stopped when you drank coffee XD
Celery is great in soups
I disagree about degrees. it's only one method of learning and some super smart people get amazingly stressed during exams and just meltdown. Also literal people like me find it very hard to answer questions in exams as they're not clear. So many founders of great IT companies left their degrees.
Celery !
Celery