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

[@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)

[@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 😎

[@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 ❤❤❤

[@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 :)

[@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!

[@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!!!

[@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!!

[@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

[@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.

[@adityatanwar9701]

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

[@agathakang]

Thank you! And so glad the video helps!!

[@thiriemilia4788]

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

[@Madhu._.01]

Awesome video as always❤❤

[@agathakang]

Thank you so much ❤️❤️

[@dianaandrade7229]

Amazing content as always ❤❤❤

[@agathakang]

Thank you 🙌

[@dianaandrade7229]

@@agathakang You're welcome ❤

[@marvinfuentes7853]

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

[@ActuallyGoose]

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?

[@3AsianBoi]

Do you have any specific courses or websites that you can use to do a project? Or would you just recommend those KZbin one’s where you follow along then try it yourself?

[@BlessingAjidahun]

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

[@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!

[@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

[@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?

[@jacobmorres9817]

❤

[@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!

[@davidmuchemi3834]

@@agathakang Key words networking and career support

[@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