@@DC-yw5yg I just released the video based on your suggestion! Thanks for your idea and support of the channel! Video ---> th-cam.com/video/oXAwKZWfbW0/w-d-xo.html
Hello Alex, kindly recommend the level of Maths required to get into the field of data analyst. What's sort of core maths skill? Also recommend material and curriculum. I have held back for too long, now it's for me to make a jump. I'll appreciate your guidance.
Hello, I am new to Data Analytics and currently in school. I just subscribed and looking forward to connecting with other analysts. Thanks for the video. Keep me coming.
We have data Analyst in my office ... when I saw your tag I was like “cool he’s in Texas!” Then I saw your office and was like .. “That looks familiar”.... then I saw you said your team meets up at the beginning of shift and was like “wait do we work together” 😂😂😂 your building has similar carpet and everything, weird haha . Seems pretty chill :)
I really love this video. The beginning part with your son and the how you manage time in the office is what I like most. Thanks for sharing. Hope I can manage my time that effectively as a data analyst too. ✌️
You have such a positive vibe to your day. I started fallowing you to better structure my Data Analysis self learning and it's really helped my enjoy the process. Thank you.
Love the content! After everything that has been going on with the pandemic I'm trying to get myself back into the habit of mastering sql and completing my udemy courses. I want you to know your channel is helping me get that inspiration going.
1. does your company offer stand up desk? I can't imagine sitting all day doing this role and would need a stand up desk. I would think many data analytics role offer this perk nowadays. 2. how often do you get to work from home as a data analyst if they offer that option?
Hey Ravi, Yes, we have standing desks and I normally use it about 1-2 times per day. I don't often work from home, but I can when My kid has a holiday that I don't get off or if my kid is sick. They are pretty flexible and let me work from home. During the pandemic I have been working home for the past 3 weeks now! So I'm glad I have a job I can work remotely.
Hi Andy, i got overwhelmed with overload information and theoretical knowledge of the skills and work of DA, can you point me to where i can practice a Real Works of DA...thank you
Hey Alex, I recently found your channel and its been a gift. I do the data and quality for non profit organization and the job its pretty simple. I've been looking to get certificate in anything data related, and finaly found the Google Data Analyst Certification. I started on thursday, march 25, and i'm already on week 3. So far its easy, hopefully it continues like that. My goal is to learn as much as i can about data to become data analyst and work for a big company. Little steps.
Hey, that's where I've lived for the past 15 years, was literally on that road yesterday. Wouldn't be surprised if our paths have crossed at some point.
Hi sir, im a fresh IT graduate and offered a data analyst job but i turn it down somehow because im scared that i cant make this job. And i think my major degree does not fit in the job. Can you give me some advice sir?
I have a degree in Recreational Therapy. I had huge imposter syndrome when I first started because I felt everyone had a better degree or more experience. I just kept my head down and worked extremely hard to develop all the skills and get better. I know it can be tough, but you have to just go for it and make it happen. If you never take the first step you can never get better!
Sophia I applied to the non-profit I was working as a care-taker for. The role was for a Data Collection Specialist and Analyst. I basically only had to use Excel. I was the only applicant so I got hired! I learned a lot and learned I liked Data. The rest is history. I do have a few videos that talk a bit more about this more in-depth.
@@AlexTheAnalyst Thank you so much! This comment was everything I needed to make the decision. I'm going to be getting my foot in the door with Google's Certificate Program and hopefully I can climb my way up an entry level job to a comfortable position.
Incredible video Alex! It was a great snapshot of a life as a Analyst! I have 2 questions: I have a BS in Finance, 14yrs of Banking experience, 16yrs of Restaurant Mgmt. and because of Covid I was let go and I have decided to pursue the IT Path. After applying for a random good online IT school back in April 2020, I am set to finish school end of Jan 2021. However i am seeing that all these certifications I am retrieving are basically just pushing me into the Tech/help desk areas. I want to do Data Analyst as of last month. I found a online school that will BOOT CAMP me for 4 months with them (part of their payment structure ) will find me a job but take a % from my 1st month salary. 1) How do you feel about IT Boot Camp Schools in general and with those strategies ? 2) Do I just hustle myself with learning the SQL, Python, etc all the basics, scrub the resume and hit the normal traffic of job hunting? I appreciate any feedback. Thanks
1. I have a whole video on bootcamps if you want to check it out, but for the most part I think they're way too expensive for what you're getting. 2. I think self learning is the best route for a lot of people and then working with recruiters to get an entry level job.
Being a Data Analyst, do you spend most of your day in your cubicle? How often do you get to collaborate with coworkers and talk to other people? Do you feel like you just do the same thing everyday, or is there more variety than it seems?
Hey Savannah, I spend probably 4-5 hours at my desk per day (when we are at the office/when we go back to the office). The other time is spent in meetings, at coworkers desks, getting lunch downstairs, etc. I would say that I talk with my coworkers every day and we chat about some work and some non-work things. It's usually pretty chill. Some days/weeks it can be the same work, but with the team I'm on we often get requests that are fairly out of the ordinary and get to use some new software or try new things in Python or Azure - which I love. Hope that helps!
@@AlexTheAnalyst Oh thank you Alex! I'm a high school senior and we had a Data Analyst presenter last Friday, and was researching it as I'm trying to pick a major. Thank you for your insight! I've found that experience from people in the specific careers is more helpful and realistic than the job descriptions on Google.
Hello ,i just graduated high school and This is a field I am beginning to get interested in ,but I’m on the fence because I hear this job very math related.i don’t mind math but it can get very confusing at times ,so I just wanted to know how frequently you use math and the difficulty at which you use it .
Honestly, it depends on the position. I work as a data analyst in healthcare and it is not math heavy at all. If you go into finances, banking, etc. that could be more more math heavy. Hope that helps!
@@AlexTheAnalyst Hello Alex, I just discovered your page and I am currently transitioning into an analyst role. I had a few questions. Is there anyway to contact you directly?
So it seemed (at least to me) that you actually spent a lot of time in meetings as opposed to time actually compiling and reporting data. Is that typical? I am looking into going to school for cloud computing, while I simultaneously hit a data analysis course at a local uni. I have only manual labor experience, so I am hoping this gets me out of the rain and into an office seat. I'd honestly be happy with an entry level job making 40-45k. Do you think that's realistic for someone with no office experience, fresh out of school, in a metro area? Thanks for the video by the way! This is appreciated!!
Some days are very meeting heavy, others are work heavy. Having lots of meetings can be normal especially at large companies. I think with what you're saying it's definitely possible! It just will take a lot of hard work and dedication to learning the skills and finding that first job.
Unless it's free, I don't think you should go to school to learn cloud computing. It can easily be learned from (and cheaper) via good platforms like A Cloud Guru, Linux Academy etc.
Back when we were in person I would take coffee breaks with my coworkers or run down to grab a bite to eat when we had the chance. Some days it was too busy to do that, but often times we had the time.
good to see there is no 8 hours of coding :x Im done with become data analyst and getting soon a job. But im still scared what is expected from a junior analyst. I love meetings (: how long would you say from 8 hours do you really spend in coding like: prepare data, eda, sda, visualisation etc ?
Hi @Game_Lab_Germany. I am also a data analyst, have been for about 6 years now. To answer your question: 1. From the 8 hour work day, you would usually spend about around 1 to 1.5 hrs of actualy coding, but this honestly can be more or less depending on the day, your tasks and focus for that week or sprint. Since, most analyst will work on some kind of sprint methodology, if your current tasks require the building of scrips, pipeline, etc, some days will be heavier on code and some less. 2. You do tend to spend more time on visualizations, but the main problem is depends on what company you work for. If you have a central data engineering team, you wont need to clean your data as much, but if you work for a smaller company, then you are most likely part of a one or two or three man show, which means you will need to wear more hats than just simply being an analyst. Overall, the majority of time is spent on dealing and understanding stakeholder requests, cleaning your data, and getting said data ready to be used in some kind of report, dash or viz. Hope this helped!
I enjoyed the video! I know a fair amount of sql however I dont know what I dont know. How much sql knowledge is expected from me or how advance of a query is expected for me to be able to execute in a data analyst position or what would an employer expect from me as a junior/entry level hire in the sql aspect of it. I know different positions ask for different responsibilities but is there a minimum threshold of knowledge that an entry level should know across all data analyst jobs? My background is from a coding bootcamp where I learned python and sql for data science and I'm trying to land a first position as a Data Analyst since I found that it is usually the most efficient path to get experience in data analytics for data science without work experience in it.
Lynwood Productions I think you’re right. It is hard to determine how much you need or how advanced you need to be. I think overall if you’re really good at the basics (select, from, where, group by, order by) and have some knowledge of intermediate sql (joins, Unions, case statements, etc.) you should be good enough to get an Entry Level job. It sounds like you already have knowledge in these areas with your bootcamp, but I do have a course right now going through the basics and intermediate concepts of SQL if you’re interested in seeing what I deem “intermediate”. Hope that helps!
You are almost there Sir , Please try to take some visualization tools seriously like Tableau and Power BI , they are your best friends , I am happy you are good with SQL, you can take some courses in data analysis I don't have one I am a student just like you .
martins Oluwatosin I agree, data visualization tools are great to know. I would start with Tableau as it’s more widely used and also Python for data visualization if you are able.
Basically it seems like you do maybe 3 hours of actual work work, and the rest of the time is on meetings and emails. Is the learning curve hard for this job? I'm thinking of doing the google cert and training on coursera?
Hi Alex, first of all; nice video! I currently study International relations but would rather do data analysis after I graduate, therefore I am learning MySQL + Tableau (already know excel) and later maybe Python. My question would be if you need to know statistics? I know for Data Science you have to know statistics very well, but is it the same for Data analysis? Thanks in advance !
Hi! Nice video! I'm an ecologist and I have a good knowledge of R and Python. I also have a Master and a Ph.D. in ecology, but I want to change careers and work as a data analyst. Do you think it's possible? Even if I don't have a degree in Computer Science?
I don't much about ecology, but I will say that I generally think if you have a passion for it and have the skills that you can make it as a Data Analyst. I don't have a degree even remotely like Computer Science so I know it's not all about the degree. It's more about the experience and skills.
Hi, Alex thank you for your video. I have a one question. Is a data analyst a common job these days? What I mean is most of different companies has the data analyst position? And if you want to change into different area such as a biomedical cooperate as a data analyst, is it easier? or you need to have some domain knowledge about biology?
It's becoming a more and more common job in just about every industry. If you are wanting to change into a different domain a lot of times knowing that other domain knowledge is super important. Sometimes if you have enough technical skills they may take you and you can learn it, but if you know that domain beforehand your chances of being able to do that are much higher.
Eduardo Vergara it’s definitely possible! If you don’t know, I don’t have a relevant degree to Analytics either. It’s all about building and focusing on the right skills and marketing yourself as an analyst. It can be done!
LOL It's comically sad to see these videos now knowing what changed just a few weeks afterwards. (Going to check out the "Quarantine Edition" next. LOL)
Great video but honestly the baby got my like lol It's crazy to think that I used to drive somewhere just to sit at someone else's desk all day and do work and then drive back. I honestly think I was MADE for work from home lol also great watch collection!
I started with pandas instead of SQL or Excel , what's your opinion should I go for the SQL , Excel or not and what is the further process after the pandas to get into the domain
I think Pandas is a great start for learning DataFrames and learning how to combine fields, manipulate the data, etc. Not everyone uses that though and often if you're working with programmers or data architects they are going to use some type of database, whether thats in the cloud of something like SQL. So I highly recommend learning SQL as well.
Hello, I also want to be a Data Analyst, Can you tell me which software you use while working, I mean Tableau, R Programming, Python, Power Bi, do you use these all of these?
Wow you did only 1 hour and 45 minutes of actual work (scripts, and reports) and the rest of the time checking emails and sitting through meetings...what a sweet gig lol
Egyptian Queen math is definitely involved, but I wouldn’t say it’s a huge part. I do have to do calculations and be good with numbers in general. I think that’s pretty standard for most DA positions.
@@AlexTheAnalyst I'm good with profiling data and writing SQL queries. I also have a good grasp with understanding data models and knowledge of the ETL process but I'm not very good at math. Could I still be successful even though I'm weak at math?
Hello, could you make a video or tell me about the minimum knowledge and skills necessary to be a data analyst? In my case it is something that I like, I see many specializations for example in coursera, many courses, many videos on the internet but I left my high school years ago and I would like to improve my skills and employability. I would like to know more about specializing in data analysis what knowledge, for example, mathematics and skills are necessary.
I won't argue with you on that one. It was my first time trying a video like this and I now have a little more experience for future videos like this. Thanks for the feedback and for supporting the channel!
Well, I sure know how to drive, play ping pong, and have lunch. Not sure if it's different for a data analyst. It was a nice video but I was actually expecting what kind of work you do as a data analyst on a daily basis
This was definitely meant to be more fun than educational haha I have lots of other videos that will talk a lot more about the subjects you're wanting :)
Looking to transition careers from the medical field. Are there any new data analysts that would be willing to provide any insight on what the job looks like or what the work schedule flexibility is like?
Hi Alex, I currently work as a Financial analyst , but I would like to make the move to data analyst role. I have experience with excel,SQL,python and tableau is there any other programs I should learn and any math concepts I should look into. Thanks
Hey Anurag, sounds like you already have the core skills down which is great. I don't know if there are any other programs that you "should" learn since the core skills you mentioned can be enough in a lot of cases. Some other options may be learning R, Power BI (just another visualization tool that some companies may use instead of Tabeau), SPSS, and Cloud Platforms (Google, Azure, and AWS are the top ones to learn). For math concepts I would look into regression analysis if you don't already know about that. There are several different types and are used often. Hope that helps!
hey ! i had completed B.tech in information technology and have strong knowledge in python and sql what should i develop more and what kind of project should i do
That's awesome! I would just try to work through some projects. I have a video on my channel about scraping data from Twitter and organizing it in Pandas and then visualizing it. You can try something like that and make it your own - could scrape data for Amazon prices, Football stats, etc. I think that's a good one for people who have Python skills and makes a good project. Hope that helps and congrats on graduating!
Hello Alex. I recent graduated with a degree in business focus in Finance. But I really want to get into Data Analysts. I’m using my time from this quarantine to learn new skills now. I’m learning SQL now. Do you have any recommendations for other skills that I need to learn. Thank you in advance
Thanh Ngo Hey Thanh - that’s awesome! Definitely a great time to learn. I think SQL is crucial, so learning that well is important. I think a few other skills to start out with are learning Excel really well and the basics of Python (pandas, matplotlib, there are a ton of others but that’s a good place to start). With those 3 skills you can go a long way. Hope that helps! Feel free to message me on LinkedIn or email if you have any other questions!
@@AlexTheAnalyst Hello Alex! I am a graduate student currently pursuing a master in Health Informatics. May I ask if I can contact you on LinkedIn regarding your experience in the data analytics field?
Hey Alex! Great video man, and you’re kid is absolutely adorable 😩. I majored in political science, would you recommend taking an online course on data analytics to get an entry level position in the field?
I would recommend taking several courses on SQL and one or two on Tableau/Power BI (whichever you prefer) and going from there. Those are instrumental skills to have so you can get a good sense if you like the work and the technologies used. After that I would focus on building a portfolio and creating a DA resume.
Hi Alex. I work in an engineering field with a manufacturing company as a sales guy. With 10 yrs of experience. I do some basic stuff in excel as part of sales analysis. Looking to get into data analytics, I did PostgreSQL & Tableau courses in the pandemic lockdown time. I am now very confident after learning this backend & frontend tools. Some of my friends still recommend learning ETL tools like Informatica. And I find ETL tools are not open source and hence not able to work hands-on. So haven't started learning it yet. What's your advice for me and do you have any ETL course on offer? Thank you & Best wishes from India.
@@AlexTheAnalyst thats what i wanted to hear 👂🤘.. i considered joyning the ranks of data analysts but in germany almost every company demands a bachelors degree 📜in mathematics or computer science 🧪 .. which i obviously dont have 😭..ok i could take one of the many classes who train you .. but the more i hear about the job .. the more i need to reflect if it is the right choice for me … i dont like endless meetings with no real gain afterwards xD had that in my last positon as e-commerce manager …
Daniel 'Kachi Emechete both are really good options. Once you learn one you really can learn both since they’re similar in a lot of ways. I learned Tableau first, but at my new company we use Power BI so I picked that up quickly. I personally think Tableau is better to learn first since I think it’s more popular and more companies use it. Hope that helps! Thanks for watching!
Hello sir. I am a computer science graduate (fresher). I love to do summarization of data and analysis of data. I know excel, tableau and r programming. Should I go for data analyst? Please suggest me some advice?
For sure! Just about all Data Analysts are working from home during this time. And because of Covid almost all Data Analyst positions are hiring remote.
I would recommend a good mouse and a second monitor. Those will really help with productivity. Any new laptop should be powerful enough to handle what you need it for. Hope that helps!
Himansh Neekhra My biggest advice is start slow and learn the basics of SQL and Tableau. After that try doing a small project. I have lots of videos on other things that I’m sure will help 👍 good luck! You can email me at AlexTheAnalyst95@gmail.com if there’s anything else I can help with!
Nice video, I have a question and is about all the online courses for 3 months about Data Analyst or Science, Do you recommend these online certificates? Or a bachelor's degree and a Masters are the only way to start a career as a Data Analyst?
Really good question. From my experience, online certificates don't have much weight in getting a job. They can be helpful, but doesn't pull half as much weight as a bachelors or masters degree. With that being said I had a bachelors in something completely random, but was still able to land a job focusing really hard on the core skills. I think even if you have no certifications or degrees you can still become a data analyst. It will just be more difficult especially when starting out. I hope that helps!
Nice video ,im a student of business analyst ,so i like learn more about data analytics also,and im having a doubt, What is most useful for data analyst ,is it learning about power bi or learning about machine learning (include python program )which is more useful to become a data analytics and for the business analyst ??????
I would focus on SQL and Tableua/Power BI (whichever you want to use). After you get those down I would start learning Python. That will be the biggest differentiation between a BA and DA.
Very cool! I would start with some simple programming in Python and learning databases. Computer Science is a great degree to get if you're really sure. I would try to build some small projects and really just get used to using these languages and software.
Hi, I want be a data analyst person but iam asking you if can i get job in america or canda etc from my home in another country even I don't have College degree I mean that i will be professional at tools and have a big background about this science, and get job from indeed or any website can i do this ??????? or the only thing i can do with these skills is working as a freelancer Thank you 😊
Hey Abdalrhman, I don't have a lot of experience in this area, but I do have some friends who moved here from India and Pakistan to work and here is what I have heard. For the most part, you'll need some type of college degree to get into America to work, unless you're coming here for school or family. If you are looking to work you may start off working remote and gain credibility and experience working for a US company. That may be helpful when trying to get a job in North America. Sorry I couldn't be more helpful, but that's about all I know.
That's awesome! I think the best place to start is with learning the basics of SQL - I have videos on this if you're interested. Then learning some basic Python - Programming with Mosh has some good tutorials on the basics. After that a really good resume is important to start getting interviews. Feel free to reach out via email or linkedin if you have any more questions!
Aww cute little haha, Nice video mate I want it to ask if il'l study in University business course could become Data Analyst ? And could I also become Data Sciencist? You got like from me (Y)
I think business can lead to becoming a data analyst, but depends on the classes that you take. There are definitely business classes that lean towards analytics. With that being said you can always get a business degree while learning the necessary data analyst skills and have a great combination of degree and skillset. I'm not a data scientist, but I work with many. The majority of data scientists I work with have STEM backgrounds, one has a financial background. So it is possible, but I think it would be harder to attain. Never impossible though. Thanks for watching! Feel free to email or reach out to me on LinkedIn if you have any more questions. -Alex
I wouldn't say you need to know programming languages to become a Data Analyst. A need to know is SQL (which is technically not a programming language). Python and R are great to know are are usually used by mid-level or senior-level positions. So it's very possible to get an entry level Data Analyst position that does not use programming languages.
Everyone wakes up in the morning Everyone has breakfast Everyone drive to work zzzzzzZZZZZZZ....Get to the point. What do you do as a Data Analyst? For example, Do you write queries, Data Modelling, Report Building? Do you use DAX formulas? How much of Power BI or Tableau do you use? These are the kind of stuff people want to know. Show us those videos.
I am mathematics and Computing student and I really want to become a data analyst in business domain. As of now I have zero knowledge and I am really confused on where to start. Could you please help guide me and give a roadmap of the things I should do. It would really be helpful Sir.
Aditya Shenoy if you’re just starting out there’s a lot of things you can do to get ready for entering the job market. I have a few videos on writing a DA resume. I lap am about to release a series on DA Interviews starting next Thursday that I think will be helpful. Another big thing you can do is to make sure you have the necessary marketable skills. I would make sure you know the basics of SQL very well. I have a tutorial if you’re interested. If you can learn some more advanced things than the basics that would be even better. I would also learn some Python (my personal preference, there are other options) and start with learning DataFrames in Pandas and some Data visualization. I think those are the really big things to start with! I hope that helps!
I don't think you absolutely need one, but it does make it a lot harder without one. A lot of jobs require that as a minimum and a lot of Job sites will filter you out without one on your resume. If you are able to gain experience (internship, volunteering, entry level position), that would be one of the biggest things you can do if you don't have a degree.
My day to day looks just a little bit different since the pandemic 🙃
@@DC-yw5yg Good Idea!
@@DC-yw5yg I just released the video based on your suggestion! Thanks for your idea and support of the channel! Video ---> th-cam.com/video/oXAwKZWfbW0/w-d-xo.html
Hello Alex, kindly recommend the level of Maths required to get into the field of data analyst. What's sort of core maths skill? Also recommend material and curriculum. I have held back for too long, now it's for me to make a jump. I'll appreciate your guidance.
@@AlexTheAnalyst I'm a data analyst freelancer hope to connect with data analysts
Hello, I am new to Data Analytics and currently in school. I just subscribed and looking forward to connecting with other analysts. Thanks for the video. Keep me coming.
We have data Analyst in my office ... when I saw your tag I was like “cool he’s in Texas!” Then I saw your office and was like .. “That looks familiar”.... then I saw you said your team meets up at the beginning of shift and was like “wait do we work together” 😂😂😂 your building has similar carpet and everything, weird haha . Seems pretty chill :)
Catina DeAnn haha that would have been wild 😁
I really love this video. The beginning part with your son and the how you manage time in the office is what I like most. Thanks for sharing.
Hope I can manage my time that effectively as a data analyst too. ✌️
Thanks so much for watching! Glad you liked it!
Thanks, man! You're the best! ALL THE BEST! God bless!
You have such a positive vibe to your day. I started fallowing you to better structure my Data Analysis self learning and it's really helped my enjoy the process. Thank you.
Meghan Crandall thank you! I like to think of my self as a positive, optimistic person haha super glad my videos have been helpful!
Love the content! After everything that has been going on with the pandemic I'm trying to get myself back into the habit of mastering sql and completing my udemy courses. I want you to know your channel is helping me get that inspiration going.
Nic Betancourt hey Nic, that means a lot to me - thank you! You got it! Good luck!
Did you master SQL? Are you any closer to becoming an analyst?
1. does your company offer stand up desk? I can't imagine sitting all day doing this role and would need a stand up desk. I would think many data analytics role offer this perk nowadays. 2. how often do you get to work from home as a data analyst if they offer that option?
Hey Ravi, Yes, we have standing desks and I normally use it about 1-2 times per day. I don't often work from home, but I can when My kid has a holiday that I don't get off or if my kid is sick. They are pretty flexible and let me work from home. During the pandemic I have been working home for the past 3 weeks now! So I'm glad I have a job I can work remotely.
Hi Andy, i got overwhelmed with overload information and theoretical knowledge of the skills and work of DA, can you point me to where i can practice a Real Works of DA...thank you
You're very blessed man, been working very hard to get an analyst job. Wish me luck!
Matt L i have been very blessed indeed. You got it, Matt! Don’t stop till you get it!
@@AlexTheAnalyst 👍🏽
Hey Alex, I recently found your channel and its been a gift. I do the data and quality for non profit organization and the job its pretty simple. I've been looking to get certificate in anything data related, and finaly found the Google Data Analyst Certification. I started on thursday, march 25, and i'm already on week 3. So far its easy, hopefully it continues like that. My goal is to learn as much as i can about data to become data analyst and work for a big company. Little steps.
I'm so glad to hear that! I think that's a great plan I wish you the best of luck! :D
Hey, that's where I've lived for the past 15 years, was literally on that road yesterday. Wouldn't be surprised if our paths have crossed at some point.
Hi sir, im a fresh IT graduate and offered a data analyst job but i turn it down somehow because im scared that i cant make this job. And i think my major degree does not fit in the job. Can you give me some advice sir?
I have a degree in Recreational Therapy. I had huge imposter syndrome when I first started because I felt everyone had a better degree or more experience. I just kept my head down and worked extremely hard to develop all the skills and get better. I know it can be tough, but you have to just go for it and make it happen. If you never take the first step you can never get better!
Alex The Analyst how did you land your first job?
Sophia I applied to the non-profit I was working as a care-taker for. The role was for a Data Collection Specialist and Analyst. I basically only had to use Excel. I was the only applicant so I got hired! I learned a lot and learned I liked Data. The rest is history. I do have a few videos that talk a bit more about this more in-depth.
@@AlexTheAnalyst DUDE! I have a Social Communications degree! Do you know how much I needed to hear that? Thank you!
@@AlexTheAnalyst Thank you so much! This comment was everything I needed to make the decision. I'm going to be getting my foot in the door with Google's Certificate Program and hopefully I can climb my way up an entry level job to a comfortable position.
Incredible video Alex! It was a great snapshot of a life as a Analyst! I have 2 questions:
I have a BS in Finance, 14yrs of Banking experience, 16yrs of Restaurant Mgmt. and because of Covid I was let go and I have decided to pursue the IT Path. After applying for a random good online IT school back in April 2020, I am set to finish school end of Jan 2021. However i am seeing that all these certifications I am retrieving are basically just pushing me into the Tech/help desk areas. I want to do Data Analyst as of last month. I found a online school that will BOOT CAMP me for 4 months with them (part of their payment structure ) will find me a job but take a % from my 1st month salary.
1) How do you feel about IT Boot Camp Schools in general and with those strategies ?
2) Do I just hustle myself with learning the SQL, Python, etc all the basics, scrub the resume and hit the normal traffic of job hunting?
I appreciate any feedback. Thanks
1. I have a whole video on bootcamps if you want to check it out, but for the most part I think they're way too expensive for what you're getting.
2. I think self learning is the best route for a lot of people and then working with recruiters to get an entry level job.
@@AlexTheAnalyst Thank you very much! by the way...I live in Dallas as well. I was transferred from NYC...lol
Please keep posting videos , i hope someday you get the recognition you deserve . Great content ! Take care Alex.
Hey, I hope so too :D Thanks for watching!
Being a Data Analyst, do you spend most of your day in your cubicle? How often do you get to collaborate with coworkers and talk to other people? Do you feel like you just do the same thing everyday, or is there more variety than it seems?
Hey Savannah, I spend probably 4-5 hours at my desk per day (when we are at the office/when we go back to the office). The other time is spent in meetings, at coworkers desks, getting lunch downstairs, etc. I would say that I talk with my coworkers every day and we chat about some work and some non-work things. It's usually pretty chill. Some days/weeks it can be the same work, but with the team I'm on we often get requests that are fairly out of the ordinary and get to use some new software or try new things in Python or Azure - which I love. Hope that helps!
@@AlexTheAnalyst Oh thank you Alex! I'm a high school senior and we had a Data Analyst presenter last Friday, and was researching it as I'm trying to pick a major. Thank you for your insight! I've found that experience from people in the specific careers is more helpful and realistic than the job descriptions on Google.
@@savannah3780 do data analysis
I will like to politely point out that the video lasts 4:20.
Hello ,i just graduated high school and This is a field I am beginning to get interested in ,but I’m on the fence because I hear this job very math related.i don’t mind math but it can get very confusing at times ,so I just wanted to know how frequently you use math and the difficulty at which you use it .
Honestly, it depends on the position. I work as a data analyst in healthcare and it is not math heavy at all. If you go into finances, banking, etc. that could be more more math heavy. Hope that helps!
@@AlexTheAnalyst Hello Alex, I just discovered your page and I am currently transitioning into an analyst role. I had a few questions. Is there anyway to contact you directly?
So it seemed (at least to me) that you actually spent a lot of time in meetings as opposed to time actually compiling and reporting data. Is that typical? I am looking into going to school for cloud computing, while I simultaneously hit a data analysis course at a local uni. I have only manual labor experience, so I am hoping this gets me out of the rain and into an office seat. I'd honestly be happy with an entry level job making 40-45k. Do you think that's realistic for someone with no office experience, fresh out of school, in a metro area? Thanks for the video by the way! This is appreciated!!
Some days are very meeting heavy, others are work heavy. Having lots of meetings can be normal especially at large companies. I think with what you're saying it's definitely possible! It just will take a lot of hard work and dedication to learning the skills and finding that first job.
Unless it's free, I don't think you should go to school to learn cloud computing. It can easily be learned from (and cheaper) via good platforms like A Cloud Guru, Linux Academy etc.
Do you get to socialize/ network as well and take breaks or that doesn’t work in this kind of job style?
Back when we were in person I would take coffee breaks with my coworkers or run down to grab a bite to eat when we had the chance. Some days it was too busy to do that, but often times we had the time.
Good to see you're putting in your hours but heading out 'on time'. More to life than work
Got that right!
I love your video! You help me get more motivation in choosing Data analyst as my main subject to study in college.
Thank you! So glad to hear that!
good to see there is no 8 hours of coding :x Im done with become data analyst and getting soon a job. But im still scared what is expected from a junior analyst. I love meetings (: how long would you say from 8 hours do you really spend in coding like: prepare data, eda, sda, visualisation etc ?
Hi @Game_Lab_Germany. I am also a data analyst, have been for about 6 years now. To answer your question:
1. From the 8 hour work day, you would usually spend about around 1 to 1.5 hrs of actualy coding, but this honestly can be more or less depending on the day, your tasks and focus for that week or sprint. Since, most analyst will work on some kind of sprint methodology, if your current tasks require the building of scrips, pipeline, etc, some days will be heavier on code and some less.
2. You do tend to spend more time on visualizations, but the main problem is depends on what company you work for. If you have a central data engineering team, you wont need to clean your data as much, but if you work for a smaller company, then you are most likely part of a one or two or three man show, which means you will need to wear more hats than just simply being an analyst.
Overall, the majority of time is spent on dealing and understanding stakeholder requests, cleaning your data, and getting said data ready to be used in some kind of report, dash or viz.
Hope this helped!
@@everydaydatanalyst thank you (:
Wait you work from 8am to 4:45pm? Is that even possible??
Yeah - pretty common at a lot of companies
Living a dream dude. Congrats for the success
Thanks man!
Forgive my ignorance but whats the difference between a Team Standup to Team Meeting? Cheers
They can be the same thing? We call them standups because we use Agile Methodology and that's what they call it. Probably the same though.
Thanks for that! I feel like there is a lot of work-life balance in this career.
Which industry do you work in as a DA? Different industry have different salary, right?
I work in Healthcare - and yes, different industries as well as different locations have different salaries
I enjoyed the video! I know a fair amount of sql however I dont know what I dont know. How much sql knowledge is expected from me or how advance of a query is expected for me to be able to execute in a data analyst position or what would an employer expect from me as a junior/entry level hire in the sql aspect of it. I know different positions ask for different responsibilities but is there a minimum threshold of knowledge that an entry level should know across all data analyst jobs? My background is from a coding bootcamp where I learned python and sql for data science and I'm trying to land a first position as a Data Analyst since I found that it is usually the most efficient path to get experience in data analytics for data science without work experience in it.
Lynwood Productions I think you’re right. It is hard to determine how much you need or how advanced you need to be. I think overall if you’re really good at the basics (select, from, where, group by, order by) and have some knowledge of intermediate sql (joins, Unions, case statements, etc.) you should be good enough to get an Entry Level job. It sounds like you already have knowledge in these areas with your bootcamp, but I do have a course right now going through the basics and intermediate concepts of SQL if you’re interested in seeing what I deem “intermediate”. Hope that helps!
You are almost there Sir , Please try to take some visualization tools seriously like Tableau and Power BI , they are your best friends , I am happy you are good with SQL, you can take some courses in data analysis I don't have one I am a student just like you .
martins Oluwatosin I agree, data visualization tools are great to know. I would start with Tableau as it’s more widely used and also Python for data visualization if you are able.
Do you like your job? Is it stressful? Is it boring? Would you recommend it?
Love my job - not super stressful, but sometimes - can be boring, but I enjoy it - I definitely recommend it!
Basically it seems like you do maybe 3 hours of actual work work, and the rest of the time is on meetings and emails. Is the learning curve hard for this job? I'm thinking of doing the google cert and training on coursera?
Some days that is very accurate. Learning curve can tough for some - I think it's not too bad - maybe a 6/10 when you get into a job. And do it!
It's like you have done nothing during the day 🤣😂😂😂
That's why I don't like remote working
But that's not remote...
Hi Alex, first of all; nice video! I currently study International relations but would rather do data analysis after I graduate, therefore I am learning MySQL + Tableau (already know excel) and later maybe Python. My question would be if you need to know statistics? I know for Data Science you have to know statistics very well, but is it the same for Data analysis? Thanks in advance !
It's definitely not as statistics heavy as Data Science, but it is used enough for you to know it.
@@AlexTheAnalyst Thanks, then this is something that I should look into :)
Hi! Nice video! I'm an ecologist and I have a good knowledge of R and Python. I also have a Master and a Ph.D. in ecology, but I want to change careers and work as a data analyst. Do you think it's possible? Even if I don't have a degree in Computer Science?
I don't much about ecology, but I will say that I generally think if you have a passion for it and have the skills that you can make it as a Data Analyst. I don't have a degree even remotely like Computer Science so I know it's not all about the degree. It's more about the experience and skills.
@@AlexTheAnalyst Thanks! That was very helpful!
If you are a quick Learner you will survive
Hi, Alex thank you for your video. I have a one question.
Is a data analyst a common job these days? What I mean is most of different companies has the data analyst position?
And if you want to change into different area such as a biomedical cooperate as a data analyst, is it easier? or you need to have some domain knowledge about biology?
It's becoming a more and more common job in just about every industry. If you are wanting to change into a different domain a lot of times knowing that other domain knowledge is super important. Sometimes if you have enough technical skills they may take you and you can learn it, but if you know that domain beforehand your chances of being able to do that are much higher.
Hi Alex, I am a Psychology graduate. Do you think I would ever make it as a Data Analyst?
Eduardo Vergara it’s definitely possible! If you don’t know, I don’t have a relevant degree to Analytics either. It’s all about building and focusing on the right skills and marketing yourself as an analyst. It can be done!
LOL It's comically sad to see these videos now knowing what changed just a few weeks afterwards. (Going to check out the "Quarantine Edition" next. LOL)
Haha! Yes... what a difference :D
Great video but honestly the baby got my like lol It's crazy to think that I used to drive somewhere just to sit at someone else's desk all day and do work and then drive back. I honestly think I was MADE for work from home lol also great watch collection!
love how short and to the point the video was
I started with pandas instead of SQL or Excel , what's your opinion should I go for the SQL , Excel or not and what is the further process after the pandas to get into the domain
I think Pandas is a great start for learning DataFrames and learning how to combine fields, manipulate the data, etc. Not everyone uses that though and often if you're working with programmers or data architects they are going to use some type of database, whether thats in the cloud of something like SQL. So I highly recommend learning SQL as well.
Are you based in Texas or North Carolina?
Based out of Dallas, Tx
Hello, I also want to be a Data Analyst, Can you tell me which software you use while working, I mean Tableau, R Programming, Python, Power Bi, do you use these all of these?
Wow you did only 1 hour and 45 minutes of actual work (scripts, and reports) and the rest of the time checking emails and sitting through meetings...what a sweet gig lol
Things have changed a lot since covid haha now it's more work than meetings - not a bad thing at all
Nice video, this is definitely my dream job ! But im wonder if a degree in MIS will help me in this career...
Yes, that would definitely be a helpful degree!
Hi Alex. Is math involved a lot in your job? Do you have to be really good at crunching and calculating numbers to be a good Data Analyst?
Egyptian Queen math is definitely involved, but I wouldn’t say it’s a huge part. I do have to do calculations and be good with numbers in general. I think that’s pretty standard for most DA positions.
@@AlexTheAnalyst I'm good with profiling data and writing SQL queries. I also have a good grasp with understanding data models and knowledge of the ETL process but I'm not very good at math. Could I still be successful even though I'm weak at math?
@@egyptianqueen4007 Same here at math :D
@@hosnygamal5369 are you a Data Analyst as well?
A day in the life of how Walter White sneaks into a data analysis company
Hello, could you make a video or tell me about the minimum knowledge and skills necessary to be a data analyst? In my case it is something that I like, I see many specializations for example in coursera, many courses, many videos on the internet but I left my high school years ago and I would like to improve my skills and employability. I would like to know more about specializing in data analysis what knowledge, for example, mathematics and skills are necessary.
Check out my other videos
Nice video! You have a good mix of tools & skills you use every day.
I agree! I like the stack that my team is using at the moment. Thanks for watching!
Awesome vid man. New subscriber. A request is just turn down the background music a little bit
I won't argue with you on that one. It was my first time trying a video like this and I now have a little more experience for future videos like this. Thanks for the feedback and for supporting the channel!
Hey!
What type of reports did you prepare? Did you use any specific programs or languages. Thanks
Reports in SQL and Python - Mostly cost analysis reporting and things like that
Well, I sure know how to drive, play ping pong, and have lunch. Not sure if it's different for a data analyst. It was a nice video but I was actually expecting what kind of work you do as a data analyst on a daily basis
This was definitely meant to be more fun than educational haha I have lots of other videos that will talk a lot more about the subjects you're wanting :)
@@AlexTheAnalyst Well actually I checked another video of yours and got what I wanted so kudos to you :)
Looking to transition careers from the medical field. Are there any new data analysts that would be willing to provide any insight on what the job looks like or what the work schedule flexibility is like?
Hi Alex,
I currently work as a Financial analyst , but I would like to make the move to data analyst role. I have experience with excel,SQL,python and tableau is there any other programs I should learn and any math concepts I should look into. Thanks
Hey Anurag, sounds like you already have the core skills down which is great. I don't know if there are any other programs that you "should" learn since the core skills you mentioned can be enough in a lot of cases. Some other options may be learning R, Power BI (just another visualization tool that some companies may use instead of Tabeau), SPSS, and Cloud Platforms (Google, Azure, and AWS are the top ones to learn). For math concepts I would look into regression analysis if you don't already know about that. There are several different types and are used often.
Hope that helps!
hey ! i had completed B.tech in information technology and have strong knowledge in python and sql
what should i develop more and what kind of project should i do
That's awesome! I would just try to work through some projects. I have a video on my channel about scraping data from Twitter and organizing it in Pandas and then visualizing it. You can try something like that and make it your own - could scrape data for Amazon prices, Football stats, etc. I think that's a good one for people who have Python skills and makes a good project. Hope that helps and congrats on graduating!
@@AlexTheAnalyst Please, help with the link to the video on scrapping data from Twitter. I have not seen it on your page.
Thanks
Hello Alex. I recent graduated with a degree in business focus in Finance. But I really want to get into Data Analysts. I’m using my time from this quarantine to learn new skills now. I’m learning SQL now. Do you have any recommendations for other skills that I need to learn. Thank you in advance
Thanh Ngo Hey Thanh - that’s awesome! Definitely a great time to learn. I think SQL is crucial, so learning that well is important. I think a few other skills to start out with are learning Excel really well and the basics of Python (pandas, matplotlib, there are a ton of others but that’s a good place to start). With those 3 skills you can go a long way.
Hope that helps! Feel free to message me on LinkedIn or email if you have any other questions!
@@AlexTheAnalyst Hello Alex! I am a graduate student currently pursuing a master in Health Informatics. May I ask if I can contact you on LinkedIn regarding your experience in the data analytics field?
@@mimichen123 Sure thing! Feel free to send me a request.
Why do a data analyst use Azure and Databricks? Should are not they part of data engineering?
Access to data :)
Did I miss the work part?
Alex, I love your content. Keep up the good work!
Thank you! I definitely will!
How many years does it take to become a data analyst
I was able to do it in 4 months, but that can vary depending on where you are in school, your career, and personal responsibilities.
When do you take the time to learn new stuff Alex?
Love the videos!!! What earbuds are you using?
Andrew Baxter thanks! They’re Jabra Elites 65ft 👍
This content is pure gold
Thanks Frenki!
Hey Alex! Great video man, and you’re kid is absolutely adorable 😩. I majored in political science, would you recommend taking an online course on data analytics to get an entry level position in the field?
I would recommend taking several courses on SQL and one or two on Tableau/Power BI (whichever you prefer) and going from there. Those are instrumental skills to have so you can get a good sense if you like the work and the technologies used. After that I would focus on building a portfolio and creating a DA resume.
Hi Alex. I work in an engineering field with a manufacturing company as a sales guy. With 10 yrs of experience. I do some basic stuff in excel as part of sales analysis. Looking to get into data analytics, I did PostgreSQL & Tableau courses in the pandemic lockdown time. I am now very confident after learning this backend & frontend tools. Some of my friends still recommend learning ETL tools like Informatica. And I find ETL tools are not open source and hence not able to work hands-on. So haven't started learning it yet.
What's your advice for me and do you have any ETL course on offer?
Thank you & Best wishes from India.
Nice Watchcollection :D .. thats data analyst money well spend ^^
Haha still haven't stopped
@@AlexTheAnalyst thats what i wanted to hear 👂🤘.. i considered joyning the ranks of data analysts but in germany almost every company demands a bachelors degree 📜in mathematics or computer science 🧪 .. which i obviously dont have 😭..ok i could take one of the many classes who train you .. but the more i hear about the job .. the more i need to reflect if it is the right choice for me … i dont like endless meetings with no real gain afterwards xD had that in my last positon as e-commerce manager …
TABLEAU or POWER BI for Business Intelligence? I'm an intermediate Excel user, and I've already started learning SQL.
Daniel 'Kachi Emechete both are really good options. Once you learn one you really can learn both since they’re similar in a lot of ways. I learned Tableau first, but at my new company we use Power BI so I picked that up quickly. I personally think Tableau is better to learn first since I think it’s more popular and more companies use it. Hope that helps! Thanks for watching!
How many times have you used stackoverflow? 😅
Too many
Hello sir. I am a computer science graduate (fresher). I love to do summarization of data and analysis of data. I know excel, tableau and r programming. Should I go for data analyst? Please suggest me some advice?
Hi,can data analysts work from home?
For sure! Just about all Data Analysts are working from home during this time. And because of Covid almost all Data Analyst positions are hiring remote.
Thank you for replying^_^
Would you recommend any tools and gadgets like laptop or something else for the new data analysts who want to make a career
Thanks
I would recommend a good mouse and a second monitor. Those will really help with productivity. Any new laptop should be powerful enough to handle what you need it for. Hope that helps!
Wish me luck 🤞! I want to be a Data analyst... Any advice is welcomed
Himansh Neekhra My biggest advice is start slow and learn the basics of SQL and Tableau. After that try doing a small project. I have lots of videos on other things that I’m sure will help 👍 good luck! You can email me at AlexTheAnalyst95@gmail.com if there’s anything else I can help with!
@@AlexTheAnalyst will do! Thanks a bunch 😄
Do days ever drag or does it feel like time goes by quickly at work?
Sometimes they do, but more often than not I enjoy it and it's not boring.
Nice video, I have a question and is about all the online courses for 3 months about Data Analyst or Science, Do you recommend these online certificates? Or a bachelor's degree and a Masters are the only way to start a career as a Data Analyst?
Really good question. From my experience, online certificates don't have much weight in getting a job. They can be helpful, but doesn't pull half as much weight as a bachelors or masters degree. With that being said I had a bachelors in something completely random, but was still able to land a job focusing really hard on the core skills. I think even if you have no certifications or degrees you can still become a data analyst. It will just be more difficult especially when starting out. I hope that helps!
Nice video ,im a student of business analyst ,so i like learn more about data analytics also,and im having a doubt,
What is most useful for data analyst ,is it learning about power bi or learning about machine learning (include python program )which is more useful to become a data analytics and for the business analyst ??????
I would focus on SQL and Tableua/Power BI (whichever you want to use). After you get those down I would start learning Python. That will be the biggest differentiation between a BA and DA.
@@AlexTheAnalyst ok i got it...thankz for your reply ...💪
Unrelated question: do you drive a GX? I’m considering one. Great video though!
I drive a Toyota Forerunner haha thanks for watching!
I just started getting interested in this field what should I do in college if I want to be a data analyst for a sports team? Any Advice?
Very cool! I would start with some simple programming in Python and learning databases. Computer Science is a great degree to get if you're really sure. I would try to build some small projects and really just get used to using these languages and software.
@@AlexTheAnalyst Did you find it Difficult to learn Computer Science?
A day in the life of any office worker. LOL
Hi,
I want be a data analyst person but iam asking you if can i get job in america or canda etc from my home in another country even I don't have College degree
I mean that i will be professional at tools and have a big background about this science, and get job from indeed or any website can i do this ??????? or the only thing i can do with these skills is working as a freelancer
Thank you 😊
Hey Abdalrhman, I don't have a lot of experience in this area, but I do have some friends who moved here from India and Pakistan to work and here is what I have heard. For the most part, you'll need some type of college degree to get into America to work, unless you're coming here for school or family. If you are looking to work you may start off working remote and gain credibility and experience working for a US company. That may be helpful when trying to get a job in North America. Sorry I couldn't be more helpful, but that's about all I know.
@@AlexTheAnalyst
i appreciate your reply and attention
Thank you very much ❤️
Interesting video. I’m trying to switch my career into analytics. Any tips on where to start? Also I suck at math so any tips would help
That's awesome! I think the best place to start is with learning the basics of SQL - I have videos on this if you're interested. Then learning some basic Python - Programming with Mosh has some good tutorials on the basics. After that a really good resume is important to start getting interviews.
Feel free to reach out via email or linkedin if you have any more questions!
@@AlexTheAnalyst kindly paste here link of linkedin
Sameer Khan sure thing - linkedin.com/in/alex-freberg
too many meetings, not enough coding seems like typical corporate job 💯😅
What exactly do you analyze?
I work on Claims data, Drug Pricing Information, and Patient information for example
Little man is adorable😍
Which mouse do u use???
Great video!
Thank you!
Whoever crowned Prince William the "world's sexiest bald man" obviously has not seen Alex The Analyst's videos :)
Awesome video bruh
Thanks! I appreciate it!
Sir? Have you any job or work for me in your end?
Hello I'm from Thai and I will study university and I interested data analyst. I thank you when you share story about work.
So cool! You’re most welcome! 😁
Have been working to be a data analysis, it not easy. Pls where can i start as a learner, python , power bi or tablaeu?
Hey, I have a whole video on Courses - both free or paid - on my channel. I think that would be a great place to start!
Aww cute little haha,
Nice video mate I want it to ask if il'l study in University business course could become Data Analyst ? And could I also become Data Sciencist?
You got like from me (Y)
I think business can lead to becoming a data analyst, but depends on the classes that you take. There are definitely business classes that lean towards analytics.
With that being said you can always get a business degree while learning the necessary data analyst skills and have a great combination of degree and skillset. I'm not a data scientist, but I work with many. The majority of data scientists I work with have STEM backgrounds, one has a financial background. So it is possible, but I think it would be harder to attain. Never impossible though.
Thanks for watching! Feel free to email or reach out to me on LinkedIn if you have any more questions.
-Alex
I’m here because I don’t know what to do with my life after graduating in business administration
Sir where do u live and where do u work ? 😌😌😌 Plzzz replyyy
I work in Dallas, Tx
@@AlexTheAnalyst sir u are my inspiration to becoming a data anayst ☺️☺️
So basically Baby Alex does all the data cleaning for you, mmmm i see lol
Do data analyst include programming language? I really wanna Pursue this field and I've basic knowledge of programming! Can I pursue?
I wouldn't say you need to know programming languages to become a Data Analyst. A need to know is SQL (which is technically not a programming language). Python and R are great to know are are usually used by mid-level or senior-level positions. So it's very possible to get an entry level Data Analyst position that does not use programming languages.
I will be a data analyst,
Nice video
Saumitra J thanks for watching!
My dream to become software engineer I learn HTML and python now to learn C and Java
Trackball gang rise up
Everyone wakes up in the morning
Everyone has breakfast
Everyone drive to work
zzzzzzZZZZZZZ....Get to the point. What do you do as a Data Analyst? For example, Do you write queries, Data Modelling, Report Building? Do you use DAX formulas? How much of Power BI or Tableau do you use? These are the kind of stuff people want to know. Show us those videos.
I am mathematics and Computing student and I really want to become a data analyst in business domain. As of now I have zero knowledge and I am really confused on where to start. Could you please help guide me and give a roadmap of the things I should do. It would really be helpful Sir.
Aditya Shenoy if you’re just starting out there’s a lot of things you can do to get ready for entering the job market. I have a few videos on writing a DA resume. I lap am about to release a series on DA Interviews starting next Thursday that I think will be helpful. Another big thing you can do is to make sure you have the necessary marketable skills. I would make sure you know the basics of SQL very well. I have a tutorial if you’re interested. If you can learn some more advanced things than the basics that would be even better. I would also learn some Python (my personal preference, there are other options) and start with learning DataFrames in Pandas and some Data visualization. I think those are the really big things to start with!
I hope that helps!
Is business analyst a dying career?
No, I really don't think it is. I believe it will only continue to increase year over year.
Do i need bachelor degree!??
I don't think you absolutely need one, but it does make it a lot harder without one. A lot of jobs require that as a minimum and a lot of Job sites will filter you out without one on your resume. If you are able to gain experience (internship, volunteering, entry level position), that would be one of the biggest things you can do if you don't have a degree.