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

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

🖥️ My Desk Setup

🙆🏻‍♀️ Connect

📄 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!

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

[killerbeed]

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.

[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 📈💯💪🏽

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

[victorbegnini]

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

[ciscasaclang]

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 😁

[BillyT]

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

[adityatanwar]

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

[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

[thiriemilia]

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

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

[marvinfuentes]

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

[AsianBoi]

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

[channelwhoa]

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!

[srs]

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

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

[hqrifno]

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

[kalpitthanki]

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?

[blb]

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

[samiobied]

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?