brutally honest career Q&A | how to become a data analyst, certification, job

Подписаться 21 тыс.

Просмотров 6 тыс.

50% 1

What is the day in the life of a data analyst including the career path. I talk about my data analytics experience as well as the skills and tips on how to get a data analyst job. This video includes the skills and roadmap required to learn data analysis including (Excel, SQL, BI Visualization, Python, Statistics) and what you can do to become a data analyst.
📚 Resources
Excel: imp.i384100.net/jr6oAP
SQL (I've personally used DataCamp to learn SQL): datacamp.pxf.io/PynDkY
Tableau: imp.i384100.net/xkoGb5
Python: imp.i384100.net/Gmdz5m
Google Data Analytics Certificate: imp.i384100.net/9gqYQy
Interview Query (similar questions to the ones I’ve seen in my interviews): shorturl.at/lyLNT
🖥️ My Desk Setup
Keyboard: amzn.to/3Sny1fw
Mouse: amzn.to/47aYpgM
Cable Management: amzn.to/47hQz5b
Dell Dock: amzn.to/3tNVahv
🙆🏻‍♀️ Connect
📫 Newsletter w/ Free Resume Template: agathakang.com/subscribe
📸 Instagram: / agathaakang
🔗 LinkedIn: / agatha-kang
🎥 TikTok: / agathaakang
Business inquiries: info@agathakang.com
📄 ABOUT ME:
My mission is to help you grow your career, especially in the world of data analysis. Switching careers to become a data analyst from a non-tech background was overwhelming. I made a lot of mistakes and wasted time trying to figure it out. But having been a manager of data analytics and now a senior business intelligence engineer at Amazon, I've learned a lot and I'm excited to use my experiences to help you navigate your career path. I hope this channel gives you the clarity and motivation to get started!
⌚️Timestamps
00:00 - Intro
00:40 - Question 1
01:56 - Question 2
04:38 - Question 3
06:24 - Question 4
08:28 - Outro
Content is for educational and entertainment purposes only. Some links are affiliate links that support the channel at no cost to you. As an Amazon Associate I earn from qualifying purchases. Thanks for your support!

Опубликовано:

1 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 41

@agathakang Месяц назад

Thanks so much for the thoughtful comments! Feel free to connect with me on 📸instagram: instagram.com/agathaakang/ and through my 📬newsletter: agathakang.com/subscribe (free resume template in link)

@killerbeed01 Месяц назад

Hi Agatha, I've been following your roadmap for a few months now, I recently completed my first dashboard project and wanted to tell you the background of it. I currently work as a call center agent for a very a large company. I told my manager my desire to be a data analyst and he actually gave me a project to do that would benefit the company. I happily took on the project as from your videos, I knew I needed projects for my resume. It took me about 2 days to complete, to be able to pull, clean, verify, and visualize the data. My manager was ecstatic when I handed him the project. He told me he requested a similar dashboard, from the team of BI data analysts that my company employes 6 months ago 😁. My manager is currently working up more projects for me to do and apparently there's talk of me getting increased compensation 🤑. Thank you so much for your videos, and the online mentor you've been to people like me.

@elifcetin9122 Месяц назад

Hi man, firstly congratulations for your success. I would like to ask, how did you start your journey? Are you learning from free materials?

@killerbeed01 Месяц назад

@@elifcetin9122 I used a variety of sources. SQL - Sams teach yourself SQL series Python/Excel - CodeAcademy BI data analysis course Looker - Udemy course Would probably look into the UDEMY courses as they are one time fees

@killerbeed01 Месяц назад

@@elifcetin9122 SQL = Sam's teach yourself series Python/Excel = CodeAcademy BI analyst career path Looker = Udemy course

@agathakang Месяц назад

Hey! Wow this is amazing 🙌 and congrats to you! I love your story of taking initiative, being resourceful, and putting yourself out there. It really does pay off 😀 Most of my data knowledge honestly comes from hands on data work as you troubleshoot data and understand problem solving with stakeholders. Continue to work on data projects and it'll be a natural transition for you into a data analyst role. Thank you so much for sharing and the tip 🙏 Congrats again!!

@dianaandrade7229 Месяц назад

Congratulations ❤❤❤

@Rebellionrider Месяц назад

I've been teaching SQL for the past 10 years and have had a successful career in the data industry. It's refreshing to see that someone like you understands the importance of SQL in analysis. Many people mistakenly believe that knowing Tableau or BI makes them perfect data analysts. How naive they are!

@agathakang Месяц назад

Yes SQL is so fundamental to any data role. I too feel like it is undervalued but it’s such an important skill. Very cool you’ve been teaching SQL 😎

@TechNSaved Месяц назад

You’ve been one of the most helpful ones in helping me become a data analyst in the near future. Currently enrolled in a course and learning Excel, Tableau, SQL and Python 📈💯💪🏽

@agathakang Месяц назад

🙌 you’re on track and doing the right things! So happy to hear the videos help :)

@victorbegnini5754 Месяц назад

This was such an amazing video! The Data Anlytics field is so vast and having people like shedding a light on it helps a lot. Thanks, Agatha s2

@agathakang Месяц назад

You’re welcome! I’m glad the video helped!!

@jennanuntavijan Месяц назад

I have been watching and paying close attention to what you say and recommend, i have an interview coming up. Honestly, I’m very nervous but because of you I’ve gained confidence and trust in the process. So, thank you for all your knowledge.

@agathakang Месяц назад

You’re welcome!! And you got this 💪 good luck on the interview!

@ciscasaclang3378 Месяц назад

thank you ms agatha for this new vid. i started watching tutorials about tableau, as i hit a wall/to get refreshed from learning SQL 😁

@agathakang Месяц назад

You’re welcome! I’m glad this helps!

@adityatanwar9701 Месяц назад

Great video as always, giving a clear view of things out there in industry.😁

@agathakang Месяц назад

Thank you! And so glad the video helps!!

@Madhu._.01 Месяц назад

Awesome video as always❤❤

@agathakang Месяц назад

Thank you so much ❤️❤️

@BillyT83 Месяц назад

It would be helpful if you could provide us a general framework on how we approach a business problem/project (i.e. breaking down, steps to be followed etc)! Thank you for all your videos so far... your insights from the Data Analytics world are great!!!

@andremember Месяц назад

Can you make a video taking about the pros and cons, who is a good fit for the 4 different career progressions you mentioned? I don’t see a lot of people talking about that and I don’t think a lot of people have that experience like you do in each of the 4 paths😊 could be a really valuable video for us. thanks

@dianaandrade7229 Месяц назад

Amazing content as always ❤❤❤

@agathakang Месяц назад

Thank you 🙌

@dianaandrade7229 Месяц назад

@@agathakang You're welcome ❤

@thiriemilia4788 Месяц назад

Can I become a data analyst without a formal degree. Now I'm in the end of google professional certificate.

@marvinfuentes7853 Месяц назад

Do you have any certifications? Like PowerBi or Tableu? Would you recommend an entry level position like AWS associate to get experience?

@Leonardorussobr Месяц назад

Hello, my dear friend. I am a Brazilian guy, a teacher of English and Spanish, currently living in Central Asia. I speak English, Portuguese, Spanish, French, Turkish, and Russian (currently studying Chinese). I am currently enrolled in a Data Analysis bootcamp. What are my chances of getting a remote job as a Data Analyst? Thank you so much for your videos.

@ActuallyGoose 9 дней назад

I'm in the process of teaching myself Excel, SQL, Python, and then going to head into Tableau (still haven't decided between that or Power BI as I've heard mixed opinions of both) But I'm finding that despite learning the programs and skills somewhat easily, I feel anxious about applying those skills towards the work of data analytics, and feel like I wont be able to grasp the day to day of a data analysis. It still seems like a foreign concept. Did you have these same issues/concerns when you first started making the transition to this career, or were you able to understand it, and get used to the workflow easily?

@channelwhoa66 Месяц назад

Agatha, PLEASE HELP! Agatha, I have a BA and an MA in Sociology. This is considered a “data-driven discipline”, I also taught courses for 4 years. So my data analysis consisted of SPSS, during g me education, and spreadsheets analyzing grades or other datasets for instruction purposes. I also completed the GOOGLE Data Analysis Professional Certificate. Would I still be “entry level?” Thanks in advance!

@kalpitthanki5740 Месяц назад

As a Student I don't is data science a good career? Right Now I am Eager to know more And learn more but don't know is Data Science a good option or Not?

@user-hq7ri1fn9o Месяц назад

Hi Agatha, I am unable to download the free CV template

@srs8734 Месяц назад

Mam can u please tell about ur interview at amazon and how to crack them initially they said we need to know Data structure and algorithm to crack them

@jacobmorres9817 Месяц назад

❤

@bl0b651 Месяц назад

Hi agatha ,i am from India iam house wife i have done my MBA & i have career gap of 16 years iwould like restart my career as a Data analytics i recently started with excel pretty interested in subject I am graduated on maths and statistics i feel i can upgrade my skill like excel, my sql, r , python, libraries like pands, numpy etc visualisation tools like power ib and tabelu with in 6 month of time period. Do i have any scope getting as fresher & long gap in career in remote job . Do we need any certification regrading data analytics course for job Please to suggest me for my restart my career Do i have

@samiobied1805 Месяц назад

I am studying MBA (master of business administration) is it going to be beneficial to increase the chance to have a job as a data analyst?

@agathakang Месяц назад

It depends on what type of data analyst you want to be. The biggest benefit I see of a MBA is the network. Take advantage of the networking and career support to land your first data job!