*brutally* honest career Q&A | how to become a data analyst, certification, job
Vložit
- čas přidán 23. 07. 2024
- 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/zNJ6xW
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!
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)
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.
Hi man, firstly congratulations for your success. I would like to ask, how did you start your journey? Are you learning from free materials?
@@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
@@elifcetin9122
SQL = Sam's teach yourself series
Python/Excel = CodeAcademy BI analyst career path
Looker = Udemy course
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!!
Congratulations ❤❤❤
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!
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 😎
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 📈💯💪🏽
🙌 you’re on track and doing the right things! So happy to hear the videos help :)
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
You’re welcome! I’m glad the video helped!!
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.
You’re welcome!! And you got this 💪 good luck on the interview!
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 😁
You’re welcome! I’m glad this helps!
Great video as always, giving a clear view of things out there in industry.😁
Thank you! And so glad the video helps!!
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!!!
Awesome video as always❤❤
Thank you so much ❤️❤️
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
Amazing content as always ❤❤❤
Thank you 🙌
@@agathakang You're welcome ❤
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.
Can I become a data analyst without a formal degree. Now I'm in the end of google professional certificate.
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!
Do you have any specific courses or websites that you can use to do a project? Or would you just recommend those CZcams one’s where you follow along then try it yourself?
Do you have any certifications? Like PowerBi or Tableu? Would you recommend an entry level position like AWS associate to get experience?
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?
Hi Agatha, I am unable to download the free CV template
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
❤
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?
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
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?
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!
@@agathakang Key words networking and career support