Wow, thank you for the thoughtful comment. I'm really trying to share my knowledge on this channel. Will keep sharing and thanks for subscribing!

Wow thanks so much!!

That's very exciting! Wishing you the best!!

im 41 and im thinking about doing the same, i have 2 course left and i will have an associates degree in information technology!... Good luck on your journey

Same

First I though my right side speaker has died

same

It was i was about to break my airpods

Yh same

I’m excited for you! Glad the video was helpful. I plan to make another soon to give a realistic view of what a data analyst does day to day.

Thank so much! I'm glad you enjoyed the video!

I too had no idea what to do after school so you’re not the only one. Glad the video gave you some insight into what a data analysis does!

Thank you! I’m glad the video was helpful. Let me know if there’s more data analyst questions you have and I’ll make sure to do more

I'm glad you enjoyed it. I try to keep the content straight to the point 😀

I am interested but don't no were to start. I am in Africa pls help

@@edwardalozie3705 I have a video coming out this week 11/12 on how to become a data analyst that I think will help. Stay tuned!

Please give us a proper roadmap, specially the resources which you personally used. Thanks for this great episode. 🙂

Thanks for the content. I used to work as a draftsman in Architecture but after 7+ years I decided to change my career for personal reasons.I got the Google analytics certification and also learned how to use EXCEL, Power BI, SQL ( intermediate level ) but I still can't find a job nor even an internship to gain some experience here in Morocco due to not having a finance, commerce or Mathematics background. could you please give me some insights how to circumvent this "issue" knowing that I don't want to lie in my resume. any response is much appreciated. Thank you.

Currently transitioning into Data Analytics from Zambia. Not the easiest. Done The GDAC course and Currently in Excel Intermediate 1.

Thanks so much for the feedback and for watching! So glad to hear it was useful!

Did u finished the course, how was it? Or if not why did u stop? I am thinking to enroll

@@HelloIamLauraa I haven't finished yet I have one more course. I like it, it's very detailed, you should enroll

@@DeNay25 thank you for your feedback!!☺ and do you think it will be easier to find a nice job with this certificate ?

@@HelloIamLauraa I think so, They discuss a lot in the program about update your resume and there are forums of other people that are taking it as well. I'm hopeful!

@@DeNay25 wish u all the best!!

Glad you enjoyed the video!

Glad it was interesting and made sense to others with no background in data!

@@agathakang thank you 🙂

The job market is tough right now for pretty much any industry but if you're considering a career change into data I say it's definitely worth it. There are many ways to make yourself stand out even in a tough market for entry level data analyst roles. For example, if you are transitioning from a different career, you may have soft skills such as communication and problem solving that you can highlight on your resume. Data analysis is more than just the technical skills and a skill worth learning that is very transferable to other career paths as well. My recommendation is if you're interested, start learning and invest in skills that will make you marketable. Hope this helps!

Appreciate it!!

Congrats on the interview and completing the tech assessment! Next, they will be looking to ask questions about your analytical and soft skills. Have some data projects on hand that you can use as examples to show your ability to clean data, work with different datasets, communicate technical concepts to a nontechnical audience are all good skills to highlight. As a junior data analyst, you may have no work experience but even some projects you've done on your own while studying would help here. They may even give you a case study like "how would you measure the performance of the company" and this is where you can talk about your ability to align with different stakeholders to define metrics and bring insights through data. The fact that you got the interview and completed the tech assessment means you are already qualified! So just make sure you dedicate time the time to preparing and be confident! Hope the interview goes well!

@@agathakang thank youuu☺️

​@@countmindlosdude can I see u r 3 projects

Thanks! My favorite is the problem solving. Being able to solve challenges with data is pretty cool 😎

Thank you!!

Yes, thanks for the feedback. I was thinking the same!

Thank you for pointing this out. I'm still learning how to edit videos and something I'll have to fix for the next videos!

Microsoft excel or google sheets Sql Tabulaeu or power BI Python (optional)

Hi, it's nice to meet a fellow data enthusiast with a healthcare background. I too came from healthcare before tech. The below comment is correct about the types of tools you'll need to know. I updated my description with resources to these tools above, so take a look!

@@agathakang Thank you! I will take a look at these. Keep up the great work. I am looking forward to your upcoming videos.

My favorite part is working on a data team. I've been at companies where I was the only data analyst but now being on a team, we bounce ideas off each other and learn from each other's different career backgrounds. Data Analysis is also good for people who are extroverted introverts. I enjoy talking to people but also LOVE the days I don't have any meetings and can sit with headphones on building lol

The 2 coding languages you will need to know are SQL and Python. If you are applying for entry level jobs, you can start with just Excel and SQL while focusing on learning the fundamentals of data analysis with these 2 tools.

You're very welcome! Glad it was helpful!

Thank you! Will keep making more videos like this

Thanks so much and hello!

Hey! I just created a video on the skills I would learn for an entry level role here: kzfaq.info/get/bejne/mrBxas5mneDQcWw.html

You’re welcome!!

Hey! that is very possible. I was able to become a data analyst with no data background. I will make a video on it and share!

YEah thank you@@agathakang we are waiting

Thanks! I’ve used Microsoft SSIS and AWS Glue but other common ones are Apache Airflow and Hadoop

Thank you ❤️

Glad it was helpful! I plan to make another like this

@@agathakang Please keep them coming. I just subscribed to you today. I am an entry level data scientist. So kinda new in this field.

Same Question

I’ve used both Windows and Mac for data analysis. Windows is more user friendly and common in the workplace but I’m using a Mac today and I find that it is really powerful and compatible with the programs I need. But I work with big data and most of the processing I do is in cloud computing so the OS is not as important.

@@agathakang Have you tried Linux?

@@rubix438 no I have not to give you a comparison

same, can't watch the video like this.

That was my mistake 🤦‍♀

Hey I have a video on how to become a data analyst without a tech background. Hope it helps! studio.kzfaq.infoga23mUpFq00/edit

Thanks so much!

That's my fault! I am working on getting better at video editing

This is a good video idea. I will think about a project based video I can walk you guys through.

Can you tel me u r LinkedIn id

You can find me at agatha-kang

You don't need a powerful laptop for data analysis tasks since you are not working with machine learning. Thinkpads (even the low budget versions) are very good. I think you can get a used or refurbished one.

@@fid8488 can u suggest any specific specifications?

Any laptop will do that you can download excel and sql. Agreed with the comment above that you don’t need anything powerful especially when just starting out

Good question! Naturally a data analyst has many career paths you can take. You can choose to be more technical and go the data science/data engineer path or go into more leadership/manager roles like director of data analytics. I'll probably do a video on this as this is something I'm still thinking through as to what is the next transition for me.

@@agathakang cool I’m thinking a lot about data science because in my psychology bachelor degree a lot of data science is involved

Data science sounds great but needs one to be great at math and stats. And many data science jobs in reality are a hybrid of data engineer and analyst.

I have a video that will answer this question and how to become a data analyst with no experience coming out next week. Stay tuned!

Yes flexibility depends on the company. As for the career field, data analyst roles require having overlap hours with your stakeholders for meetings but there is also a lot of independent time building that this career would allow for flexibility.

Yes Power BI is another very popular data visualization tool. There's so many out there so no reason I did not include it. I mention it in my next video

You’re welcome! I’m a self taught data analyst. My background is in litigation consulting 😂 and I made the switch! I go into my background here How I Changed Careers To Become A Data Analyst kzfaq.info/get/bejne/n5uVnqyHvrveg2Q.html

Hey! You have the advantage that SDE’s are very technical but the skillsets you’ll want to sharpen are SQL, Python for data analysis, and a BI tool like Tableau. You’ll want to also understand the fundamentals of data analysis and how to use data to communicate insights. If you have any opportunities to work closely with the data team on the job, that would be a great way to get hands on experience. I have a video coming out this week 11/12 that I think you’ll find useful. Stay tuned!

Hey I have a video breaking down the skills here: kzfaq.info/get/bejne/mrBxas5mneDQcWw.html

Second this question.

Python is used with a series of Python libraries like Pandas, NumPy, Matplotlib and Jupyter Notebook were you can analyze the data and create data visualizations to graph out your findings.

In addition, python is also used to build custom ETL pipelines.

Hi, you're welcome! There are a lot of misconceptions about what the data analyst role will look like. The data analyst role will not go away but will be redefined as it's a career field that keeps up with the ever-changing technology. We'll be working more closely with AI and integrating that into reporting and data analysis. Average salary in the US is about $66K for entry level in the US but it is a career field that has a high earning potential depending on industry, experience, and location. I plan to make a video about these 2 topics in the coming weeks so stay tuned!

@@agathakang Thankyou very much! Great you responded for the query☺️. Looking forward for the upcoming videos. Keep rocking🥳

Hey thanks so much for watching! I enjoy listening to: www.erikataughtme.com/ as there's a lot of self development and skills you can learn from guests on the show. As for books, storytelling with data is a good book to learn about data visualization. Sounds like you're already on the right track and learning :)

@@agathakang omggg thanksss a lot. i will study harder and harder

Thanks letting me know. I have adjusted this for future videos!

Mac OS and Windows both work well for Data Analysis but personally Mac and Excel sucks lol the quick keys bothered me too but I don't use much of Excel anymore on the job. I mostly use SQL and cloud based tools so having a Mac OS has been easier for me to use as that's what I use on my personal computer as well

My desk setup is in the description above. The track pad: amzn.to/47aYpgM

i'm looking for the palm rest not the track pad. @@agathakang

@@thecowegg misread it - here it is: amzn.to/3FUY9Hh

A portfolio showcasing your media analyst skills will make you can stand out. This is something you can add to your resume and also leverage in interviews. I’m working on a video how to become a data analyst with no experience which I think will help you. Stay tuned!

Hey! Yes I was using smartsheets and that is just a project planning tool I learned on the job. I would say any tool can be used. I see Asana as a popular one and there is a free version you can use too

Thanks so much ❤️ and LOL I was literally just about to watch love is blind Sweden. Thanks for the rec!!

@@agathakang What did you think about Love is Blind Sweden?

I recommend Asana. They have a free version you can use to track personal work

Wow, nice life path🤩 I also want to change to data analytics

Wishing you the best on your path! I believe you will get a job soon!

@@HelloIamLauraa Definitely you should do this

@@bangtanwings4854 Thank you 👌

That's great! I use mostly QuickSight but in the industry Tableau and Power BI are common

Hey! w3schools is a good place to start learning sql for free and practice. You can also go to kaggle for datasets and leetcode for practice sql questions. I learned sql by practicing so my recommendation is to not just watch tutorials but to practice writing to learn.

Hi there! For the BIE role at Amazon, you'll want to know advanced SQL (leetcode.com/studyplan/top-sql-50/) and a visualization tool (ex: Tableau, Power BI, or QuickSight). Depending on the team, some may require more Python and statistics as well. You'll also want to have strong examples of your work in your resume. This could be from job experience or your portfolio that you will leverage to showcase your data analysis skills like the ability to explain trends. When practicing for the interview, use the STAR technique (situation, task, action, result) focusing on the actions and results of your work. I plan to do another video with more tips but I hope these help you get started!

@@agathakang Thank you for your response, really appreciate it!

Thanks so much and yes it was from a data analyst salary but also living at my parents home for years to save up $ haha it helped!

I have not taken any courses for storytelling but I can share but my BI coworker recommends the book Storytelling with Data by Knaflic as a really good resource

Hi and thank you! In the United States where I am located the median salary is around $83,000 for a data analyst. It's on my list to make a video about this as pay is an important factor to consider!

ooh thank u

beacme*

Hey! Yes I have a bachelors in business administration and no masters. I have a video with my background here: kzfaq.info/get/bejne/ncdiZtCG1azVYGQ.htmlsi=DhBh8qU1We-BGyzP and another video this week talking about my data journey. Hope this helps!

Hey I have a video breaking down the path I would take here: kzfaq.info/get/bejne/mrBxas5mneDQcWw.html

Hey I have a video with a path here: kzfaq.info/get/bejne/mrBxas5mneDQcWw.html

Yes I am based in the US

Yes the job market is tough right now with tech layoffs. I'm hoping hiring will pick up in 2024

The field of data analysis is growing rapidly and as a result there is more competition for entry-level positions. You'll have to use a portfolio and resume/interview tips to make yourself stand out in the crowd

Yes, I work on a team of data analysts and data engineers and our work overlaps a lot. It's good because you learn a lot of both which is very useful!

Not realy, as a data engineer you will mostly be cleaning data and fixing broken down datastreams for so called data analysts who are too stupid to write a single query and will complain their powerbi reports can't export to Excel.

Hey I offer 1-1 coaching and coffee chats you can schedule in the description above

I would recommend at least 16 GB but more the better

That’s one of the best ways to transition to a data analyst! Do it internally and learn the skills on the job 😁

Thanks! Im in the US on a hybrid schedule where I work from home half the week

You can find me at agatha-kang

I think they're dried mushrooms. Quite tasty!

​@@austingatchell7642 Yeah, confused them for dried shiitakes for cooking - those things will crack a tooth, and the smell, quite pungent.

Yes there’s so many use cases for data. It is already being used positively in many ways like minimizing waste in the fashion industry